Database Management Claude 스킬

Schema Designer

Architect robust relational database structures with optimized normalization, indexing, and data integrity constraints.

Database Migration Helper

Manages database schema changes safely with rollback support and best practices across multiple ORMs and SQL.

ETL Incremental Patterns

Implements efficient data loading strategies including incremental syncs, CDC, and parallel backfill operations.

Secure Database Migrations

Enforces security-first database migrations with mandatory Row Level Security policies and architectural oversight.

SQL Query Optimizer

Analyzes and optimizes SQL queries for PostgreSQL and MySQL to improve performance and reduce execution time.

Rails Model Architect

Designs robust Ruby on Rails models using industry-standard ActiveRecord patterns and data integrity best practices.

Rails AI Solid Stack (Jobs & Cache)

Configures database-backed background jobs, caching, and WebSockets using the Rails 8 Solid Stack while strictly excluding Redis and Sidekiq.

Supabase Data Manager

Manages Supabase databases through direct REST API calls for CRUD operations and advanced data filtering.

DLT Pipeline Creator

Automates the creation and maintenance of robust data ingestion pipelines using the dlt library for various APIs and databases.

Database Sharding Architect

Implements horizontal data partitioning and sharding strategies to scale large-scale database architectures across multiple servers.

Database Schema Documentation

Generates comprehensive database schema documentation, ERD diagrams, and technical data dictionaries for clear data modeling.

Parquet Data Engineering

Optimizes columnar data storage using Parquet patterns for partitioning, predicate pushdown, and schema evolution.

Data Migration Script Generator

Generates robust, reversible, and production-grade database migration scripts for schema changes and data transformations.

Litestream for Rails

Configures continuous SQLite backups for Rails 8+ applications using Litestream and S3-compatible storage.

Reference Data & Security Master

Designs and manages authoritative reference data systems including security masters, client models, and multi-source identifier mapping for financial services.

SQL Patterns & Optimization

Provides advanced SQL design patterns and optimization techniques for efficient data engineering and complex query construction.

Financial Data Quality Manager

Implements and manages data quality programs for financial services, focusing on golden source architecture and regulatory compliance.

Production ETL Patterns

Orchestrates production-grade Extract-Transform-Load (ETL) pipelines using reliability patterns and incremental load strategies.

dbt Coder

Standardizes dbt project architecture and SQL transformation patterns for scalable analytics engineering.

Data Modeling Patterns

Designs optimized database schemas and data models using normalization, denormalization, and advanced relationship patterns.

SQL Query Optimization

Optimizes database performance through advanced query rewriting, index design strategies, and EXPLAIN plan analysis.

SQLAlchemy ORM Expert

Implements professional-grade SQLAlchemy ORM patterns and database optimizations for modern Python applications.

Event Sourcing

Implements event sourcing and CQRS patterns to maintain a full history of state changes through immutable event streams.

Ampi Vault Builder

Transforms document folders or SQLite tables into searchable, Ampi-compliant database vaults with keyword and semantic indexing.

Database Management Patterns

Optimizes data architecture and performance across SQL and NoSQL systems through comprehensive schema design, indexing strategies, and scaling patterns.

Database Architect & Management

Architects, queries, and optimizes complex data storage systems across SQL and NoSQL paradigms.

Pre-Dev Data Modeling

Defines technology-agnostic data entities, relationships, and ownership to ensure robust system architecture before database selection.

PostgreSQL Database Administration

Manages and optimizes PostgreSQL databases for customer support environments, including schema design, performance tuning, and advanced query implementation.

SQL

Writes and optimizes SQLite queries, schemas, and migrations using standardized best practices and specific implementation patterns.

Kafka Stream Processing

Architects and implements scalable event-driven systems using Apache Kafka for real-time data processing and high-throughput messaging.