Database Management Claudeスキル

Database Designer

Generates production-ready database schemas, SQL scripts, and ER diagrams compatible with DrawDB.

Database Query Performance Analyzer

Analyzes database EXPLAIN plans to identify performance bottlenecks and provide actionable SQL optimization recommendations.

SQL Optimization Patterns

Optimizes database performance through systematic query analysis, advanced indexing strategies, and execution plan debugging.

Database Designer

Generates production-ready database schemas, SQL scripts, and visual ER diagrams for diverse business systems.

Database Migration Best Practices

Implements industry-standard database migration strategies including zero-downtime patterns, rollback procedures, and schema safety protocols.

Database Migrator

Manages database schema evolution through version-controlled migrations, automated script generation, and safe rollback procedures.

Brokle Migration Workflow

Manages database migration lifecycles for PostgreSQL and ClickHouse through automated CLI commands, schema enforcement, and data seeding.

Django Pro Architect

Enforces opinionated, production-ready Django development patterns and project structures.

Frappe DocType Generator

Generates production-ready Frappe Framework v15 DocTypes with service layers, repository patterns, and full test coverage.

Cool MySQL

Provides comprehensive guidance and implementation patterns for the cool-mysql Go library to optimize database operations, caching, and connection management.

PostgreSQL Table Design

Designs high-performance PostgreSQL schemas using industry-standard best practices for data types, indexing, and performance.

Event Store Design

Architects and implements robust, scalable event storage systems for event-sourced backend applications.

dbt Transformation Patterns

Implements production-ready dbt patterns for analytics engineering, including Medallion architecture, data testing, and incremental processing.

Database Backup Automator

Automates the creation of scheduled, encrypted, and compressed database backups with integrated recovery procedures.

Database Diff & Migration Tool

Synchronizes and compares PostgreSQL and MySQL database schemas while generating safe migration scripts and rollback procedures.

Database Index Advisor

Optimizes database performance by analyzing query workloads to recommend missing indexes and identify redundant ones.

Database Query Performance Analyzer

Analyzes and optimizes database query performance by interpreting EXPLAIN plans and identifying execution bottlenecks.

Database Cache Layer Implementation

Implements multi-tier caching strategies using Redis, in-memory L1 layers, and CDNs to optimize database performance and reduce load.

Database Schema Designer

Architects robust database schemas and automates migrations using industry best practices for SQL and NoSQL systems.

Database Deadlock Detector

Identifies, analyzes, and resolves database deadlock issues to ensure optimal application performance and system stability.

Database Caching Layer

Implements high-performance multi-tier caching architectures to optimize database latency and reduce server load.

Database Migration Manager

Automates the creation, application, and rollback of version-controlled database schema migrations for SQL and NoSQL databases.

Database Recovery Manager

Automates database management, optimization, and recovery operations using production-grade safety protocols and automation scripts.

Automated Database Backups

Automates the creation of scheduled database backup scripts, encryption protocols, and restoration procedures for major database engines.

Database Connection Pooler

Optimizes and manages database connection pooling to enhance system performance and resource efficiency.

FairDB Backup Manager

Automates PostgreSQL backup orchestration, recovery, and monitoring using pgBackRest and Wasabi S3 storage for FairDB environments.

Database Index Advisor

Analyzes database query patterns and workloads to provide actionable recommendations for index optimization and performance tuning.

Database Migration Manager

Manages database schema migrations across SQL and NoSQL environments with automated workflows and safety-first validation.

Database Deadlock Detector

Identifies, analyzes, and resolves database lock contention and transaction deadlocks to maintain system stability.

Database Partition Manager

Optimizes large-scale database performance by automating the design and implementation of table partitioning strategies.