Database Management Claude 스킬

Database Diff Tool

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

Firestore Manager

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

ORM Code Generator

Generates production-grade ORM models and entity classes while providing comprehensive architectural guidance and automation for database schema management.

PostgreSQL Optimization

Optimizes PostgreSQL database performance through advanced indexing, query plan analysis, partitioning, and connection pooling strategies.

Database Optimization

Optimizes database performance through query analysis, advanced indexing strategies, and architectural best practices for PostgreSQL and MySQL.

Data Engineering Patterns

Implements robust ETL pipelines, data warehousing schemas, and Apache Spark processing for scalable data infrastructure.

Redis Patterns & Optimization

Implements high-performance Redis patterns including advanced caching strategies, rate limiting, and distributed locking.

SQL Research for dbplyr

Researches and documents database-specific SQL syntax and behaviors to ensure accurate R-to-SQL translations within dbplyr.

Local Environment Manager

Manages local database operations, test data setup, and Docker-based environment configurations for the daily-api service.

Supabase Platform Specialist

Accelerates full-stack development with expert guidance on PostgreSQL 16, pgvector similarity search, and secure multi-tenant Row-Level Security.

Database Performance Patterns

Optimizes .NET data access layers using high-performance patterns like CQRS, batching, and efficient EF Core/Dapper configurations.

EF Core Best Practices & Patterns

Implements high-performance Entity Framework Core patterns, migration workflows, and database resiliency strategies for .NET applications.

Database Domain Specialist

Optimizes and implements advanced database patterns across PostgreSQL, MongoDB, and Redis for scalable modern applications.

Chroma Vector DB

Manages local and server-based vector embeddings for RAG and semantic search applications.

Qdrant Vector Search

Implements high-performance vector similarity search and metadata filtering for production-grade RAG and semantic search systems.

Rails Model TDD Generator

Automates Ruby on Rails model creation following a strict Test-Driven Development (TDD) workflow for Rails 8.1 applications.

Database Schema Designer

Designs production-ready SQL and NoSQL database schemas using industry-standard normalization, indexing, and performance optimization patterns.

WordPress SQL Query Manager

Executes SQL queries against WordPress development databases to inspect audit logs, debug table structures, and manage activity data.

Data Model Creation

Designs complex relational database schemas using Mermaid diagrams for enterprise-level documentation and automated relationship management.

Bkend Database Manager

Manages bkend.ai database schemas, CRUD operations, and complex data queries via MCP and REST APIs.

Senior Data Engineer

Builds scalable data pipelines, ETL/ELT systems, and production-grade data infrastructure using modern tools like Spark, Airflow, and dbt.

dbt Analytics Engineering

Builds, modifies, and validates dbt models using industry best practices for modular data transformation and automated testing.

dbt Semantic Layer Builder

Automates the definition and validation of dbt Semantic Layer components to create consistent, governed business metrics.

Fetch dbt Documentation

Retrieves and searches dbt documentation in LLM-friendly markdown format for dbt Cloud, Core, and the Semantic Layer.

dbt MCP Server Configurator

Automates the setup and configuration of Model Context Protocol (MCP) servers to integrate dbt workflows with AI coding assistants.

dbt Fusion Migration Assistant

Triages and classifies dbt-core to Fusion migration errors into actionable categories to streamline data project upgrades.

Running dbt Commands

Optimizes and executes dbt CLI workflows with smart command formatting and resource selection.

Cross-Platform dbt Migration

Migrates dbt projects between data platforms like Snowflake and Databricks using real-time SQL dialect conversion and validation.

dbt Unit Test Generator

Generates standardized dbt unit test YAML definitions to validate SQL transformation logic using mocked inputs and expected outputs.

Django Performance Review

Analyzes and validates Django code to identify high-impact performance bottlenecks like N+1 queries, unbounded querysets, and missing database indexes.