Database Management Claude 스킬

Redis Development Conventions

Standardizes Redis implementation with expert guidance on data structures, hierarchical key naming, and memory-efficient TTL strategies.

Prisma Database Expert

Optimizes Prisma ORM workflows including schema design, migration management, and high-performance query modeling.

PostgreSQL Nanoid Identifiers

Implements a hybrid ID strategy using Nanoids for public-facing identifiers and UUIDs for internal PostgreSQL references.

Supabase Expert

Provides comprehensive guidance for building secure and scalable applications using Supabase database, auth, storage, and edge functions.

Unified SQL Data Analyst

Queries and joins data across PostgreSQL, MySQL, and SQLite databases using a unified SQL engine for advanced data exploration.

Firebase Backend Suite

Implements scalable serverless backend services including Firestore, Authentication, and Cloud Functions using production-grade security patterns.

NoSQL Expert Design Patterns

Architects high-performance distributed database schemas using query-first modeling and single-table design patterns for Cassandra and DynamoDB.

ClickHouse Analytics & Data Engineering

Optimizes high-performance analytical workloads using specialized ClickHouse query patterns, table engines, and data engineering best practices.

SQL Server Patterns

Provides optimized T-SQL patterns and SQL Server best practices for high-performance database development and administration.

Database Migrations

Implements production-safe database schema changes, data migrations, and zero-downtime deployment patterns across major SQL dialects and ORMs.

NoSQL Database Architect

Architects high-scale distributed database schemas for Cassandra and DynamoDB using query-first modeling and performance-optimized patterns.

Lutece ElasticData Integration

Implements high-performance Elasticsearch DataSources for the Lutece 8 platform using standard patterns and CDI auto-discovery.

Database Design & Architecture

Architects optimized database schemas and selects the ideal data stack based on specific project requirements and performance needs.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for major SQL databases to optimize performance and enforce business logic.

SQL Query Optimizer

Analyzes and refines SQL queries to enhance database performance through index recommendations and structural rewrites.

Database Query Performance Optimizer

Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks.

ORM & Database Schema Generator

Generates production-ready ORM models and database schemas for frameworks like TypeORM, Prisma, and SQLAlchemy using natural language.

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data models optimized for scalability in databases like MongoDB and DynamoDB.

Data Quality Frameworks

Implements comprehensive data validation using Great Expectations, dbt tests, and data contracts to ensure reliable data pipelines.

Database Integrity & Validation Engine

Ensures database reliability by automatically implementing data types, ranges, and referential integrity constraints using a specialized validation engine.

Database Seeder & Data Generator

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

Database Transaction Monitor

Monitors database transactions in real-time to detect long-running queries, lock contention, and transaction anomalies.

Database Sharding Manager

Architects and implements horizontal database sharding strategies to scale data storage and performance across multiple servers.

Database Schema Designer

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

Database Replication Manager

Automates the setup and management of database replication, failover, and high availability configurations for PostgreSQL and MySQL.

Database Recovery & Backup Manager

Automates database disaster recovery, point-in-time recovery (PITR), and failover strategies to ensure production system resilience.

Database Partitioning Manager

Automates the design, implementation, and management of database partitioning strategies to optimize query performance and data archival.

Database Migration Manager

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

Database Index Advisor

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

Database Documentation Generator

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