Databases

This skill enables Claude to design NoSQL data models. It activates when the user requests assistance with NoSQL database design, including schema creation, data modeling for MongoDB or DynamoDB, or defining document structures. Use this skill when the user mentions "NoSQL data model", "design MongoDB schema", "create DynamoDB table", or similar phrases related to NoSQL database architecture. It assists in understanding NoSQL modeling principles like embedding vs. referencing, access pattern optimization, and sharding key selection.

This skill enables Claude to collect comprehensive infrastructure performance metrics across compute, storage, network, containers, load balancers, and databases. It is triggered when the user requests "collect infrastructure metrics", "monitor server performance", "set up performance dashboards", or needs to analyze system resource utilization. The skill configures metrics collection, sets up aggregation, and helps create infrastructure dashboards for health monitoring and capacity tracking. It supports configuration for Prometheus, Datadog, and CloudWatch.

This skill automates database archival processes. It helps reduce primary database size by moving historical records to archive tables or cold storage solutions like S3, Azure Blob, or GCS. The plugin supports PostgreSQL and MySQL, implementing automated retention policies, compression, compliance tracking, and zero-downtime migration. Use this when the user mentions "database archival", "archive old database records", "retention policies", "cold storage", or "reduce database size." It is particularly useful for handling requests related to data lifecycle management and compliance requirements in database systems.

Domain specialist for infrastructure, CI/CD, containers, observability, and DevOps operations. Scope: CI/CD pipelines, containerization, infrastructure as code, monitoring and observability, container security, release strategies, infrastructure reliability patterns. Excludes: code-level security, application architecture, database design, API design, performance profiling. Triggers: "CI/CD", "Docker", "Kubernetes", "K8s", "deployment", "pipeline", "monitoring", "observability", "Terraform", "Ansible", "infrastructure".

Writing style guide for jonmagic / Jonathan Hoyt with authentic voice patterns and tone guidelines. Use when generating any prose content on jonmagic's behalf—blog posts, documentation, reflections, feedback, snippets, or any written communication. Ensures first-person narratives with introspective framing, concrete examples, and thoughtful principal-engineer perspective.

外部キー制約と参照整合性をC.J. Dateの理論に基づいて設計するスキル。CASCADE動作の戦略的選択、循環参照の検出・解消、ソフトデリート整合性を提供。SQLite/Turso + Drizzle ORM環境に最適化。Anchors:• An Introduction to Database Systems（C.J. Date） / 適用: FK設計 / 目的: 理論的に正しい制約設計• The Pragmatic Programmer（Hunt, Thomas） / 適用: 実装品質 / 目的: 保守性の高い設計Trigger:Use when designing foreign key relationships, selecting CASCADE behavior, detecting circular references, integrating soft delete patterns, or reviewing database schema integrity.

TypeScript厳格モードによる型安全性設計を専門とするスキル。型推論、型ガード、ジェネリック、識別可能ユニオンのパターンを体系的に設計します。Anchors:• 『Effective TypeScript』（Dan Vanderkam） / 適用: 型設計原則 / 目的: 型安全性最大化• TypeScript Handbook / 適用: 型システム理解 / 目的: 正確な型設計Trigger:TypeScript型設計時、型ガード実装時、ジェネリック設計時、ユニオン型設計時に使用

統合テストの設計・実装・実行スキル。複数コンポーネント間の相互作用を検証し、エンドツーエンドのワークフローが正しく機能することを確認します。Anchors:• Growing Object-Oriented Software, Guided by Tests (Freeman) / 適用: 境界テスト設計 / 目的: 契約ベースのテスト• Continuous Delivery (Humble) / 適用: パイプライン統合 / 目的: 早期フィードバック• Testing Microservices with Mountebank (Byars) / 適用: サービス仮想化 / 目的: 分散システムテスト効率化Trigger:Use when testing component interactions, database integration, external API connections, or E2E workflows.integration testing, database testing, api testing, contract testing, test isolation

Use when receiving code review feedback, before implementing suggestions, especially if feedback seems unclear or technically questionable - requires technical rigor and verification, not performative agreement or blind implementation

Comprehensive knowledge about vulnerability exploitation and initial access. Provides expertise on finding and adapting exploits, adapting proof-of-concepts, gaining shells, and capturing user flags. Covers reverse shells, file uploads, SQL injection, and RCE vulnerabilities.

This skill enables Claude to detect potential memory leaks and analyze memory usage patterns in code. It is triggered when the user requests "detect memory leaks", "analyze memory usage", or similar phrases related to memory leak detection and performance analysis. The skill identifies potential issues such as unremoved event listeners, closures preventing garbage collection, uncancelled timers, unbounded cache growth, circular references, detached DOM nodes, and unnecessary global state accumulation. It then provides detailed fix recommendations. Use this skill to proactively identify and resolve memory leaks, improving application performance and stability.

.gitignore設計と管理スキル。機密ファイルパターン、プロジェクト固有除外、プラットフォーム別パターン、.gitignore検証手法を提供。Anchors:• Pro Git (Scott Chacon) / 適用: バージョン管理 / 目的: 除外パターンの基礎• The Pragmatic Programmer / 適用: 実践的改善 / 目的: 効率的なパターン設計• GitHub gitignore templates / 適用: 言語別テンプレート / 目的: 標準パターンTrigger:Use when designing gitignore files, adding sensitive file patterns, configuring project-specific exclusions, validating gitignore patterns, or optimizing cross-platform exclusion rules.gitignore, ignore patterns, secrets, env files, build artifacts, cache

Multi-language backend development skill for Node.js, Python, and Go applications.This skill should be used when: designing RESTful/GraphQL APIs, optimizing database queries,implementing authentication/authorization, reviewing API security, or building microservices.

SQLアンチパターンの検出・分析・改善提案を支援するスキル。スキーマ設計レビュー、クエリ実装レビュー、パフォーマンス問題の診断と改善を行う。Anchors:• SQL Antipatterns (Bill Karwin) / 適用: アンチパターンカタログ / 目的: 設計問題の体系的検出• Database Design for Mere Mortals / 適用: 正規化とスキーマ設計 / 目的: 適切なデータモデリング• Use The Index, Luke / 適用: インデックス最適化 / 目的: クエリパフォーマンス改善Trigger:Use when reviewing database schema, detecting SQL anti-patterns, diagnosing performance issues, or planning schema refactoring.sql anti-pattern, schema review, N+1, EAV, polymorphic associations, jaywalking, database design, query optimization

Ensures engaging user experience through validation of animations, transitions, micro-interactions, and feedback states, preventing flat/static interfaces that lack polish and engagement. Works with Tanstack Start (React) + shadcn/ui components.

Receive and act on code review feedback with technical rigor, not performative agreement or blind implementation

This skill enables Claude to monitor database transactions for performance and lock issues using the database-transaction-monitor plugin. It is triggered when the user requests transaction monitoring, lock detection, or rollback rate analysis for databases. Use this skill when the user mentions "monitor database transactions," "detect long-running transactions," "identify lock contention," "track rollback rates," or asks about "transaction anomalies." The skill leverages the `/txn-monitor` command to provide real-time alerts and insights into database health.

Audits database schemas for naming conventions, type consistency, nullability patterns, and missing constraints. Provides violations report with recommended fixes. Use for "schema validation", "database linting", "schema standards", or "consistency checks".

Use when creating or modifying a CQRS Query (Get, List, Search) or query handler with filtering, paging, or full-text search.

This skill implements backup strategies for databases and applications. It generates configuration files and setup code to ensure data protection and disaster recovery. Use this skill when the user requests to "implement backup strategy", "configure backups", "setup data recovery", or needs help with "backup automation". The skill provides production-ready configurations, best practices, and multi-platform support for database and application backups. It focuses on security and scalability.