Database Management Claude 스킬

Backend Models Standards

Defines robust and maintainable database models with clear naming, appropriate data types, constraints, and relationships.

Database Performance Patterns

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

Upstash Redis KV Store

Interact with Upstash Redis-compatible key-value stores to persist data, manage caches, and handle complex data structures.

Upstash Redis KV Connector

Manages data in Upstash Redis-compatible stores using a comprehensive suite of REST-based commands for caching, state management, and real-time data structures.

PostgreSQL to TimescaleDB Hypertable Migration

Migrates standard PostgreSQL tables to TimescaleDB hypertables using optimized partitioning, chunking, and compression configurations.

PostgreSQL Table Design

Optimizes PostgreSQL database schemas using industry-standard patterns for data types, indexing, and high-performance architecture.

PostgreSQL Hypertable Candidate Finder

Analyzes PostgreSQL database schemas and query patterns to identify tables that would benefit from TimescaleDB hypertable conversion.

TimescaleDB Hypertable Setup

Architects optimized TimescaleDB schemas with hypertables, compression policies, and continuous aggregates for high-performance time-series data.

Snowflake Platform & AI

Develops and deploys applications on Snowflake's AI Data Cloud using snow CLI, Cortex AI, and Native App frameworks.

Time-Series Database Implementation

Implements high-performance storage and querying architectures for time-stamped metrics, IoT, and financial data.

Relational Database Implementation

Implements robust relational database systems across Python, Rust, Go, and TypeScript using industry-standard ORMs and query builders.

Document Database Implementation

Implements flexible-schema NoSQL database patterns including MongoDB, DynamoDB, and Firestore with optimized indexing and aggregation strategies.

Graph Database Implementation

Implements and optimizes graph database architectures for relationship-heavy data models like social networks and recommendation engines.

Data Transformation & Pipelines

Transforms raw data into clean, analytical assets using modern ETL/ELT patterns, SQL (dbt), and high-performance Python frameworks.

Data Architecture Strategist

Guides architects through strategic data platform design, storage paradigms, and modeling approaches for modern cloud-native systems.

Data Ingestion Patterns

Streamlines the process of loading data from cloud storage, APIs, and streaming sources into databases using optimized multi-language patterns.

SQL Performance Optimizer

Optimizes SQL query performance across PostgreSQL, MySQL, and SQL Server through execution plan analysis and strategic indexing.

Streaming Data & Event-Driven Systems

Builds production-ready event streaming systems and real-time data pipelines using modern brokers like Kafka, Redpanda, and Pulsar.

SaaS Database Architect

Simplifies database design and implementation for solo founders using Supabase and PostgreSQL to build secure, multi-tenant SaaS applications.

Universal Seed Data Generator

Generates realistic, deterministic seed data from ORM schemas or entity definitions across multiple languages and formats.

Persistence & Performance Auditor

Orchestrates comprehensive database and runtime performance audits by coordinating specialized analysis workers to optimize backend efficiency.

Query Efficiency Auditor

Audits database query patterns to detect and resolve performance bottlenecks like N+1 loops, redundant fetches, and over-fetching.

Transaction Correctness Auditor

Audits database transaction patterns to ensure data integrity, optimal scope, and proper error handling.

Database Implementation

Manages database schema design, migrations, and query optimization using SQL, Flyway, and Exposed ORM.

Database Implementation

Streamlines database schema design, Flyway migrations, and ORM integration for production-ready applications.

Spring Data JPA Persistence

Implements robust persistence layers with Spring Data JPA through automated repository generation, entity mapping, and query optimization.

Java AWS DynamoDB SDK v2

Simplifies Amazon DynamoDB integration in Java applications using the AWS SDK v2 and Enhanced Client patterns.

Spring Data Neo4j Integration

Streamlines graph database development by providing standardized patterns for Spring Data Neo4j entity mapping, Cypher queries, and repository implementation.

Django Performance Reviewer

Audits Django codebases to identify and fix critical performance bottlenecks like N+1 queries and unbounded querysets.

Vercel KV Integration

Integrates Redis-compatible storage for caching, session management, and rate limiting in Next.js applications.