Databases

Domain specialist for code quality assessment, maintainability, complexity analysis, code smells detection, anti-patterns identification, and code style enforcement. Scope: code review methodologies, naming conventions, coding standards, technical debt management. Excludes: database design, API design, infrastructure, performance, security, deployment/CI/CD. Triggers: "quality", "code quality", "code health", "smell", "code smell", "anti-pattern", "complexity", "cyclomatic complexity", "maintainability", "naming", "naming convention", "style", "code style", "linting", "technical debt", "debt", "refactoring", "refactor", "review", "code review".

This skill enables Claude to automatically generate comprehensive documentation for existing database schemas using the database-documentation-gen plugin. It is triggered when the user requests database documentation, ERD diagrams, or a data dictionary. The plugin supports multiple database engines and generates documentation that includes ERD diagrams, table relationships, column descriptions, indexes, triggers, stored procedures, and interactive HTML documentation. Use this skill when you need to document existing database schemas for team onboarding, architectural reviews, or data governance purposes. The trigger terms include "database documentation", "ERD diagram", "data dictionary", and `/db-docs`.

Define database schemas in JSON and generate migration plans. Use this skill when creating or modifying database models, defining tables with columns, constraints, and ENUM types for Vespertide-based projects.

Orchestrates git workflow for Python feature/release/hotfix development.Loads and coordinates other skills based on current context.Includes PR feedback handling via work-item generation.Use when:- User says "next step?" or "continue workflow"- Working in git repo with TODO_[feature|release|hotfix]_*.md files- Need to determine workflow phase and load appropriate skills- Handling PR feedback via work-itemsTriggers: next step, continue, what's next, workflow status, PR feedbackCoordinates: tech-stack-adapter, git-workflow-manager, bmad-planner,speckit-author, quality-enforcer, workflow-utilitiesContext management: Prompt user to run /context when context usageis high, then /init to reset before continuing workflow.

データベースバックアップ戦略、RPO/RTO設計、復旧ランブック作成、検証運用を体系化するスキル。多層防御と復旧演習を通じて、復旧準備の抜け漏れを防ぐ。Anchors:• Database Reliability Engineering / 適用: 信頼性設計 / 目的: 失敗前提の運用整理• Backup & Recovery (W. Curtis Preston) / 適用: バックアップ戦略 / 目的: 復旧可能性の担保• Site Reliability Engineering / 適用: RTO/RPO設計 / 目的: 目標と検証の整合Trigger:Use when designing backup strategies, defining RPO/RTO, drafting recovery runbooks, planning DR drills, or verifying backup readiness.backup strategy, rpo rto, recovery runbook, disaster recovery, backup validation

Comprehensive React component library with 30+ production-ready components using shadcn/ui architecture, CVA variants, Radix UI primitives, and Tailwind CSS. Use when users need to (1) Create React UI components with modern patterns, (2) Build complete component systems with consistent design, (3) Implement accessible, responsive, dark-mode-ready components, (4) Generate form components with React Hook Form integration, (5) Create data display components like tables, cards, charts, or (6) Build navigation, layout, or feedback components. Provides instant generation of customizable components that would otherwise take 20-45 minutes each to hand-code.

Expert guidance on Turborepo build orchestration and remote caching workflow. Use this skill when running build commands, troubleshooting caching issues, working with monorepo task execution, or investigating CI/CD pipeline problems. Covers the critical pattern of always using root-level pnpm scripts, understanding the turbo-wrapper.js authentication system, filter syntax for targeting packages, and remote cache configuration.

Use when generating tests for backend code (Express routes, MongoDB models, Node services) - analyzes file type, detects test framework from package.json, generates comprehensive tests with setup/teardown and edge case coverage

This skill enables Claude to design, execute, and analyze performance tests using the performance-test-suite plugin. It is activated when the user requests load testing, stress testing, spike testing, or endurance testing, and when discussing performance metrics such as response time, throughput, and error rates. It identifies performance bottlenecks related to CPU, memory, database, or network issues. The plugin provides comprehensive reporting, including percentiles, graphs, and recommendations.

This skill enables Claude to generate realistic test data and database seed scripts for development and testing environments. It uses Faker libraries to create realistic data, maintains relational integrity, and allows configurable data volumes. Use this skill when you need to quickly populate a database with sample data for development, testing, or demonstration purposes. The skill is triggered by phrases like "seed database", "generate test data", "create seed script", or "populate database with realistic data".

This skill enables Claude to generate ORM models and database schemas. It is triggered when the user requests the creation of ORM models, database schemas, or wishes to generate code for interacting with databases. The skill supports various ORMs including TypeORM, Prisma, Sequelize, SQLAlchemy, Django ORM, Entity Framework, and Hibernate. Use this skill when the user mentions terms like "ORM model", "database schema", "generate entities", "create migrations", or specifies a particular ORM framework like "TypeORM entities" or "SQLAlchemy models". It facilitates both database-to-code and code-to-database schema generation.

This skill enables Claude to manage database schema changes through version-controlled migrations. It is activated when the user requests to create, apply, or rollback database migrations. The skill supports generating timestamped migration files with both up and down migrations for PostgreSQL, MySQL, SQLite, and MongoDB. It helps in tracking schema evolution and ensuring safe database modifications. Use this skill when the user mentions "database migration", "schema change", "add column", "rollback migration", or "create migration".

ユーザー入力のサニタイズとセキュリティ対策を専門とするスキル。XSS、SQLインジェクション、コマンドインジェクションなどの攻撃を防止。Anchors:• OWASP Top 10 / 適用: インジェクション対策 / 目的: 主要脆弱性の予防• Web Application Hacker's Handbook / 適用: 入力検証 / 目的: 攻撃ベクトル理解Trigger:Use when handling user input, building database queries, processing file uploads, or generating dynamic HTML content.XSS, SQL injection, command injection, sanitization, validation, escape

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.

This skill enables Claude to perform automated fuzz testing on APIs to discover vulnerabilities, crashes, and unexpected behavior. It leverages malformed inputs, boundary values, and random payloads to generate comprehensive fuzz test suites. Use this skill when you need to identify potential SQL injection, XSS, command injection vulnerabilities, input validation failures, and edge cases in APIs. Trigger this skill by requesting fuzz testing, vulnerability scanning, or security analysis of an API. The skill is invoked using the `/fuzz-api` command.

Implement multi-tenant PostgreSQL database layer with row-level security. Use for database schema design, tenant isolation, migrations, connection pooling, and data access patterns. Triggers on "database schema", "PostgreSQL", "multi-tenant", "row-level security", "RLS", "database migration", "sqlc", or when implementing the data layer for AgentStack.

プロダクトバックログの作成・整理・優先順位付けを行うためのスキル。ユーザーストーリー作成、DEEP原則の適用、健全性分析を通じて実装可能な状態を維持します。Anchors:• Agile Estimating and Planning / 適用: 見積もりと優先度 / 目的: 計画精度の向上• User Stories Applied / 適用: ストーリー作成 / 目的: 要件の明確化• The Product Owner's Handbook / 適用: バックログ運用 / 目的: 価値最大化Trigger:Use when managing product backlogs, refining user stories, prioritizing items, or assessing backlog health.

Domain specialist for software architecture, design patterns, code quality, and refactoring. Scope: SOLID principles, GoF design patterns, anti-patterns, code smells, clean architecture, code injection vulnerabilities, performance issues, modern language features. Excludes: infrastructure configuration, security operations beyond code injection, database design, API design, performance testing. Triggers: "SOLID", "design pattern", "refactor", "architecture", "code quality", "clean code", "factory", "singleton", "observer", "strategy", "dependency injection".

Apply Martin Fowler's refactoring patterns - extract variables to eliminate repetition, split temporary variables, replace temp with query for cleaner, more maintainable code

Defines database performance monitoring strategy with slow query detection, resource usage alerts, query execution thresholds, and automated alerting. Use for "database monitoring", "performance alerts", "slow queries", or "DB metrics".