Database Management Claude 스킬

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.

SQL Performance Optimizer

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

Data Ingestion Patterns

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

Streaming Data & Event-Driven Systems

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

Time-Series Database Implementation

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

Document Database Implementation

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

Relational Database Implementation

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

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.

Graph Database Implementation

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

SaaS Database Architect

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

Transaction Correctness Auditor

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

Persistence & Performance Auditor

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

Universal Seed Data Generator

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

Query Efficiency Auditor

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

Database Implementation

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

Database Implementation

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

Java AWS DynamoDB SDK v2

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

Spring Data JPA Persistence

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

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.

Cloudflare D1 Database

Manages Cloudflare D1 serverless SQLite databases, automates SQL migrations, and optimizes query performance for edge workers.

Vercel KV Integration

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

Drizzle ORM for Cloudflare D1

Builds type-safe Cloudflare D1 databases using Drizzle ORM with automated migration management and transaction error prevention.

Cloudflare Hyperdrive Integration

Connects Cloudflare Workers to SQL databases with high-performance connection pooling and global query caching.

Cloudflare Vectorize V2

Implement high-performance semantic search and RAG workflows using Cloudflare Vectorize V2 with optimized metadata filtering and async mutation handling.

Cloudflare Workers KV

Manages global key-value storage for Cloudflare Workers with optimized patterns for edge caching and high-performance data retrieval.

Neon & Vercel Postgres for Edge

Configures serverless PostgreSQL with Neon and Vercel Postgres optimized for edge environments like Cloudflare Workers and Vercel Edge Runtime.