資料庫

Check for pending Codex (GitHub AI) feedback on current branch's PR. Use to review and address AI suggestions before merge. This is the rate-limiting step before merge.

This skill enables Claude to analyze and optimize database query performance. It activates when the user discusses query performance issues, provides an EXPLAIN plan, or asks for optimization recommendations. The skill leverages the query-performance-analyzer plugin to interpret EXPLAIN plans, identify performance bottlenecks (e.g., slow queries, missing indexes), and suggest specific optimization strategies. It is useful for improving database query execution speed and resource utilization.

Remote control tmux sessions for interactive CLIs (python, gdb, etc.) by sending keystrokes and scraping pane output. Use when debugging applications, running interactive REPLs (Python, gdb, ipdb, psql, mysql, node), automating terminal workflows, or when user mentions tmux, debugging, or interactive shells.

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.

TMDB (The Movie Database) API integration for React Native TV streaming apps. Use when users need help with movie/TV show data, poster images, search functionality, trending content, video trailers from TMDB, API authentication, rate limiting, or TypeScript types for TMDB responses.

データベースクエリ最適化を専門とするスキル。N+1問題の回避、フェッチ戦略の選択、実行計画分析、インデックス活用を通じてパフォーマンスを向上させます。Anchors:• High Performance MySQL (Baron Schwartz) / 適用: クエリ最適化原則 / 目的: パフォーマンス向上の体系的アプローチ• SQL Performance Explained (Markus Winand) / 適用: インデックス設計とアクセスパターン / 目的: 実行計画の最適化• High-Performance Java Persistence (Vlad Mihalcea) / 適用: ORM最適化とN+1問題解決 / 目的: アプリケーションレベルの最適化Trigger:Use when optimizing query performance, analyzing execution plans, resolving N+1 problems, designing fetch strategies, improving database performance, or tuning ORM queries.Keywords: query optimization, N+1 problem, execution plan, index design, fetch strategy, database performance, ORM optimization