Database Management Claude 스킬

ORM Code Generator

Generates production-ready ORM models and database schemas across multiple frameworks and programming languages to accelerate backend development.

Database Caching Layer

Optimizes application performance by implementing multi-tier caching strategies including Redis, in-memory L1 layers, and CDN integration.

Query Performance Analyzer

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

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data models optimized for MongoDB, DynamoDB, and other document-based databases.

Database Audit Logger

Automates the implementation of robust database audit trails and change tracking to ensure data compliance and security.

Stored Procedure Generator

Generates production-ready stored procedures, triggers, and custom database logic for PostgreSQL, MySQL, and SQL Server.

Database Seed Data Generator

Generates realistic, schema-aware test data and database seed scripts to populate development and testing environments efficiently.

Database Caching Layer

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

NoSQL Data Modeler

Designs optimized NoSQL data structures and schema definitions for document and key-value databases like MongoDB and DynamoDB.

FairDB Backup Manager

Manages and automates PostgreSQL backup and recovery operations using pgBackRest and Wasabi S3 storage.

Database Migration Manager

Automates the creation, application, and rollback of version-controlled database migrations across multiple SQL and NoSQL engines.

Database Deadlock Detector

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

Database Integrity & Validation

Automates the enforcement of database integrity through rigorous data type, range, and format validation rules.

ORM Code Generator

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

Stored Procedure & Trigger Generator

Generates production-ready stored procedures, database functions, and triggers for PostgreSQL, MySQL, and SQL Server to optimize performance and data integrity.

Database Deadlock Detector

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

Database Migration Manager

Automates database schema evolution by generating and managing version-controlled migrations for SQL and NoSQL databases.

Stored Procedure Generator

Generates production-ready stored procedures, triggers, and functions to handle complex database logic and optimize performance.

Database Schema Designer

Designs, normalizes, and visualizes relational database schemas with automated ERD and SQL generation.

Database Migration Manager

Manages version-controlled database schema changes by generating, applying, and rolling back migrations for multiple database engines.

Database Schema Designer

Designs, visualizes, and normalizes robust database schemas while generating SQL and Mermaid ERD diagrams.

Database Query Performance Analyzer

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

Database Deadlock Detector

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

Database Diff Tool

Compares and synchronizes database schemas across different environments using automated guidance and structured validation workflows.

SQL Query Optimizer

Optimizes database query performance through structured analysis, automated implementation, and comprehensive validation across multiple database systems.

Database Connection Pooler

Optimizes database resource management by implementing and configuring efficient connection pooling strategies across various programming environments.

NoSQL Data Modeler

Designs and optimizes non-relational database structures through structured architectural guidance and automated implementation workflows.

Database Caching Implementation

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

Cache Performance Optimizer

Optimizes application caching strategies by analyzing hit rates, TTL configurations, and invalidation logic to enhance performance.

Firestore Manager

Manages comprehensive Firebase/Firestore operations, including standard database CRUD, advanced multi-agent communication, and secure service integrations.