Database Management Claudeスキル

dbt Performance Optimization

Optimizes dbt and Snowflake performance through expert guidance on materialization strategies, warehouse sizing, and advanced query patterns.

SQL Query Optimization

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

Bun Redis Integration

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

Database Schema Design

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

Bun SQLite

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

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.

Vercel KV Storage & Caching

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

Cloudflare Vectorize for RAG & AI

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

Symfony Cache

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

Doctrine Batch Processing

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

SQL Development & Optimization

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

ETL Pipeline Architect

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

Cloudflare D1 Database Manager

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

Cloudflare Workers KV

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

Doctrine Performance & Fetch Modes

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

Zod Schema Designer

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

Neon & Vercel Serverless Postgres

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

Drizzle ORM for Cloudflare D1

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

Doctrine Transaction Manager

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

Cloudflare Hyperdrive Integration

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

Doctrine Migrations for Symfony

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

Doctrine Entity Relations for Symfony

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

Upstash Search TypeScript SDK

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

Supabase Database Configurator

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

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.