Database Management Claude 스킬

Database Documentation Generator

Automates the creation of comprehensive database documentation, ERD diagrams, and data dictionaries from existing schemas.

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data models optimized for scalability and specific query access patterns.

Database Schema Designer

Designs, normalizes, and visualizes efficient database schemas using industry best practices and automated ERD generation.

ORM Code Generator

Automates the creation of ORM models, entity classes, and database schemas with standardized best practices and comprehensive documentation.

Database Schema Designer

Architects normalized database schemas, generates Mermaid ERD diagrams, and produces optimized SQL CREATE statements for robust data modeling.

Python Database Patterns

Implements modern SQLAlchemy 2.0 patterns and asynchronous database workflows for Python applications.

Data Quality Validation Patterns

Provides standardized SQL templates and strategies for validating data consistency between dbt models during migrations and refactors.

Database Documentation Generator

Generates comprehensive database documentation, ERD diagrams, and data dictionaries automatically from existing schemas.

Database Design Decisions

Guides architectural choices for database systems, schema design, and scaling patterns to optimize performance and consistency.

Database Sharding Manager

Designs and implements horizontal database sharding strategies to scale high-traffic applications beyond single-server limitations.

Database Audit Logger

Implements comprehensive audit logging and change tracking to ensure database security and regulatory compliance.

Database ORM Generator

Generates production-ready ORM models and database schemas across multiple frameworks and programming languages.

Stored Procedure Generator

Generates production-ready stored procedures, triggers, and functions for PostgreSQL, MySQL, and SQL Server databases.

Stored Procedure Generator

Automates the creation of optimized, production-ready SQL stored procedures and database functions with built-in best practices.

Database Archival System

Automates the transfer of historical database records to archive tables or cold storage to optimize performance and reduce primary storage costs.

Database Deadlock Detector

Detects, analyzes, and resolves database deadlocks by monitoring lock contention and transaction patterns.

FairDB Backup Manager

Automates PostgreSQL backup and recovery operations using pgBackRest and Wasabi S3 storage for FairDB environments.

Database Deadlock Detector

Identifies and resolves database lock contention and transaction deadlocks to improve system stability and performance.

Database Replication Manager

Automates the configuration and management of database replication, failover, and high availability for robust data consistency.

Database Deadlock Detector

Detects, resolves, and prevents database deadlocks across PostgreSQL, MySQL, and MongoDB environments to ensure system stability.

Database Migration & Schema Management

Execute database migrations, schema transformations, and data management tasks across multiple ORMs with zero-downtime strategies.

PostgreSQL Schema Design

Architects production-grade PostgreSQL schemas using performance-tuned patterns, advanced data types, and indexing best practices.

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.

Go Database Management

Streamlines Go database operations using production-ready patterns for SQL, ORMs, transactions, and schema migrations.

PostgreSQL Table Design

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

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.

Event Store Design

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