Database Management Claude 스킬

ClickHouse Analytics & Data Patterns

Optimizes ClickHouse database performance with expert patterns for schema design, high-volume data ingestion, and complex analytical queries.

Optimizing Performance

Identifies and resolves performance bottlenecks across databases, application logic, and infrastructure using proven optimization patterns.

Supabase Database Design

Enforces lean PostgreSQL conventions and a tight-fit design philosophy for optimized Supabase database schemas.

CHGIS Temporal Gazetteer

Queries the China Historical GIS Temporal Gazetteer API to retrieve and analyze historical Chinese placenames and administrative structures from 222 BCE to 1911 CE.

JUDO RDBMS Query Debugger

Troubleshoots and traces JUDO DAO SQL generation to resolve performance bottlenecks and query inaccuracies.

JUDO RDBMS Dialect Extension

Extends the JUDO DAO framework to support new database dialects like MySQL, Oracle, and custom RDBMS systems.

JUDO Query Optimization

Optimizes JUDO query performance by analyzing join strategies, caching mechanisms, and expression evaluation patterns.

Database Schema Management

Manages PostgreSQL database schemas and Prisma ORM migrations within the ClaudeCode Sentiment Monitor project.

JUDO Expression Syntax

Facilitates the implementation and debugging of JUDO expression metamodels and transfer object bindings.

Database Migration Master

Facilitates seamless database schema and data migrations across multiple ORMs with a focus on zero-downtime strategies and safety.

JUDO DAO Core Patterns

Guides the implementation of standardized data access patterns, payload processing, and entity lifecycle management within the JUDO framework.

dbt Data Modeling Expert

Implements industry-standard dbt patterns for scalable data transformation, automated testing, and comprehensive documentation.

PostgreSQL & Supabase Migration Assistant

Manages PostgreSQL database migrations and Row-Level Security (RLS) policies for Supabase projects with safe, reversible schema changes.

SQL Code Formatter

Formats and polishes SQL queries according to Oracle Database 19 best practices for improved readability and consistency.

Backend Migrations

Manages database schema transitions with a focus on reversibility, data integrity, and zero-downtime deployment strategies.

JUDO Query Translation

Translates logical JUDO expressions and models into structured SQL queries for efficient data retrieval.

Codebase & Schema Explorer

Accelerates codebase onboarding by automating the discovery of database schemas, API endpoints, and architectural patterns.

Backend Migrations

Manages database schema evolutions through versioned migration files that prioritize data integrity, reversible changes, and zero-downtime deployment strategies.

JUDO Custom RDBMS Queries

Extends the JUDO DAO RDBMS query translation layer with custom mappers, translators, and join strategies.

JUDO Entity Mapping

Maps complex domain entities to transfer objects while handling unit conversion and instance graph relationships.

Database Management & Design

Optimizes database performance and manages schema design, migrations, and complex SQL query generation for relational databases.

JUDO Custom Expression Translators

Extends the JUDO Expression module by implementing custom translators for domain-specific logic and specialized calculations.

Master Data Release Key Reporter

Automates the extraction, analysis, and reporting of project-specific master data based on unique release keys.

Supabase Storage Manager

Manages file storage, bucket configurations, and secure access policies within the Supabase ecosystem.

Prisma ORM Development

Streamlines database development using Prisma 5+ with type-safe schema design, migration workflows, and optimized query patterns.

Prisma ORM Setup & Patterns

Configures and optimizes Prisma ORM for type-safe database access and streamlined schema management in Node.js applications.

Master Data CSV Validator

Validates master data CSV files against database schemas and templates to ensure data integrity and deployment readiness.

Database Schema Reviewer

Analyzes and optimizes database schemas for normalization, data integrity, and high-performance indexing.

Spring Data JPA Best Practices

Implements high-performance Spring Data JPA repositories and entities using modern aggregate-centric patterns.

ClickHouse Analytics & I/O

Optimizes high-performance analytical workloads by implementing ClickHouse-specific database patterns and query best practices.