Database Management Claude 스킬

dbt Architecture

Guides the implementation of medallion architecture and production-grade project organization within dbt.

Bun Drizzle Integration

Integrates Drizzle ORM with Bun's SQLite driver to provide type-safe database schemas and streamlined migration workflows.

Database Sharding

Implement horizontal scaling and high-performance sharding strategies for PostgreSQL and MySQL databases.

Cloudflare Vectorize for RAG & AI

Implements high-performance semantic search and RAG workflows using Cloudflare's globally distributed vector database.

Vercel KV Storage & Caching

Implements production-ready Vercel KV (Redis) storage patterns for caching, session management, and rate limiting in serverless applications.

Bun SQLite

Integrates high-performance local data storage and management using Bun's native SQLite driver.

Doctrine Performance & Fetch Modes

Optimizes Symfony Doctrine queries using fetch modes, lazy loading strategies, and advanced query hints to eliminate N+1 issues.

Doctrine Transaction Manager

Manages database transactions and concurrency in Symfony applications using Doctrine ORM best practices.

Doctrine Batch Processing

Optimizes large-scale Symfony data operations through memory-efficient Doctrine ORM patterns and bulk database strategies.

ETL Pipeline Architect

Builds robust, idempotent data pipelines with a focus on data quality, error handling, and operational reliability.

SQL Development & Optimization

Optimizes SQL development through expert query tuning, strategic indexing, and robust data modeling for high-performance analytics and pipelines.

Doctrine Migrations for Symfony

Manages database schema versioning and migrations within Symfony applications using Doctrine.

Cloudflare D1 Database Manager

Manages Cloudflare D1 serverless SQLite databases with best practices for migrations, query optimization, and global read replication.

Drizzle ORM for Cloudflare D1

Streamlines Cloudflare D1 database management using Drizzle ORM with type-safe schemas, automated migrations, and optimized query patterns.

Zod Schema Designer

Designs and implements robust Zod schemas and TypeScript types using a Zod-first development approach for safe data modeling.

Cloudflare Hyperdrive Integration

Connects Cloudflare Workers to PostgreSQL and MySQL databases with high-performance connection pooling and query caching.

Neon & Vercel Serverless Postgres

Configures and manages Neon and Vercel Serverless Postgres databases optimized for edge and serverless environments.

Bun Redis Integration

Implements high-performance Redis patterns for Bun environments including caching, session management, and real-time data structures.

SQL Query Optimization

Optimizes SQL queries for PostgreSQL and MySQL using indexing, execution plan analysis, and performance-driven pattern rewriting.

Database Schema Design

Designs and optimizes production-ready PostgreSQL and MySQL database schemas using normalization and performance best practices.

Cloudflare Workers KV

Integrates Cloudflare Workers KV storage into Claude Code for high-performance global key-value management and edge caching.

Doctrine Entity Relations for Symfony

Configures and optimizes Doctrine ORM entity relationships, fetch modes, and cascade operations for Symfony applications.

Symfony Cache

Implement and optimize high-performance caching strategies using the Symfony Cache component.

Supabase Database Configurator

Configures and integrates PostgreSQL databases using Supabase for persistent data storage in AI-driven applications.

Upstash Search TypeScript SDK

Integrates high-performance AI search capabilities into TypeScript applications using the Upstash REST API.

Supabase Database Integrator

Configures persistent PostgreSQL databases for ChatGPT applications using Supabase with a focus on secure data isolation.

dbt Test Generator

Generates comprehensive dbt test suites including schema validations, data quality checks, and source freshness monitors.

DBT Model Builder

Builds standardized dbt data models with structured layering, incremental strategies, and comprehensive schema documentation.

ETL Designer

Designs robust and scalable ETL/ELT pipelines with built-in orchestration, error handling, and monitoring capabilities.

SQL Query Optimizer

Optimizes SQL database performance through advanced indexing strategies, query rewriting, and execution plan analysis.