Database Management Claude 스킬

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.

dbt Coder

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

Parquet Data Engineering

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

Litestream for Rails

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

SQL Patterns & Optimization

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

DynamoDB Toolbox v2 for TypeScript

Implements type-safe DynamoDB single-table designs and entity modeling using DynamoDB Toolbox v2 for scalable NoSQL data layers.

Drizzle ORM for TypeScript

Simplifies database management with type-safe SQL schemas, relational queries, and design patterns for Drizzle ORM in TypeScript.

SQLAlchemy Python Patterns

Implements modern SQLAlchemy 2.0+ ORM patterns for efficient Python database management and querying.

DLT Pipeline Creator

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

Tidewave Phoenix Dev Tools

Connects Claude to running Phoenix applications via the Model Context Protocol for live code execution, database querying, and runtime introspection.

SQL

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

PostgreSQL Database Administration

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

Event Sourcing

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

dbt Data Transformation

Streamlines analytics engineering workflows by implementing modular SQL transformations, automated testing, and comprehensive data documentation using dbt.

Kafka Stream Processing

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

Pre-Dev Data Modeling

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

Database Management Patterns

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

PostgreSQL Database Engineering

Optimizes and manages professional PostgreSQL environments through advanced indexing strategies, query tuning, and high-availability architecture patterns.

Vector Database Management

Manages and optimizes vector databases like Pinecone, Weaviate, and Chroma for semantic search, RAG systems, and similarity-based AI applications.

Redis State Management

Implements high-performance Redis patterns for caching, session management, and distributed state coordination.

Psycopg PostgreSQL Adapter

Simplifies PostgreSQL database operations in Python with specialized support for connection pooling, asynchronous I/O, and secure query execution.

Alembic Database Migration

Manages complex database schema evolutions and data migrations using Alembic and SQLAlchemy with a focus on production stability.

Neon Serverless Postgres

Streamlines database development by providing expert guidance on Neon's serverless architecture, branching features, and driver integrations.

Realistic Dummy Dataset Generator

Generates realistic, customizable mock datasets for software testing and system demonstrations in multiple formats.

SQL Query Generator

Converts natural language requirements into optimized, dialect-specific SQL queries while analyzing database schemas and providing performance recommendations.

Database Architect & Management

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

Ampi Vault Builder

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

SQLAlchemy ORM Expert

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

Database WAL Recovery

Recovers data from SQLite Write-Ahead Log (WAL) files by identifying, analyzing, and decrypting corrupted or inaccessible database components.

SQL Query Optimization

Optimizes SQL queries for maximum performance by identifying bottlenecks, rewriting inefficient subqueries, and implementing high-performance patterns like window functions and CTEs.