Database Management Claude 技能

Database Schema Design

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

Doctrine Batch Processing

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

Bun Redis Integration

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

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.

ETL Incremental Patterns

Implements efficient data loading strategies including incremental syncs, CDC, and parallel backfill operations.

Secure Database Migrations

Enforces security-first database migrations with mandatory Row Level Security policies and architectural oversight.

Schema Designer

Architect robust relational database structures with optimized normalization, indexing, and data integrity constraints.

Database Migration Helper

Manages database schema changes safely with rollback support and best practices across multiple ORMs and SQL.

Rails AI Solid Stack (Jobs & Cache)

Configures database-backed background jobs, caching, and WebSockets using the Rails 8 Solid Stack while strictly excluding Redis and Sidekiq.

SQL Query Optimizer

Analyzes and optimizes SQL queries for PostgreSQL and MySQL to improve performance and reduce execution time.

Supabase Data Manager

Manages Supabase databases through direct REST API calls for CRUD operations and advanced data filtering.

Rails Model Architect

Designs robust Ruby on Rails models using industry-standard ActiveRecord patterns and data integrity best practices.

DLT Pipeline Creator

Automates the creation and maintenance of robust data ingestion pipelines using the dlt library for various APIs and databases.

Database Sharding Architect

Implements horizontal data partitioning and sharding strategies to scale large-scale database architectures across multiple servers.

Litestream for Rails

Configures continuous SQLite backups for Rails 8+ applications using Litestream and S3-compatible storage.

SQL Patterns & Optimization

Provides advanced SQL design patterns and optimization techniques for efficient data engineering and complex query construction.

Production ETL Patterns

Orchestrates production-grade Extract-Transform-Load (ETL) pipelines using reliability patterns and incremental load strategies.

Parquet Data Engineering

Optimizes columnar data storage using Parquet patterns for partitioning, predicate pushdown, and schema evolution.

dbt Coder

Standardizes dbt project architecture and SQL transformation patterns for scalable analytics engineering.

Database Schema Documentation

Generates comprehensive database schema documentation, ERD diagrams, and technical data dictionaries for clear data modeling.

Data Migration Script Generator

Generates robust, reversible, and production-grade database migration scripts for schema changes and data transformations.

Reference Data & Security Master

Designs and manages authoritative reference data systems including security masters, client models, and multi-source identifier mapping for financial services.

Financial Data Quality Manager

Implements and manages data quality programs for financial services, focusing on golden source architecture and regulatory compliance.

Data Modeling Patterns

Designs optimized database schemas and data models using normalization, denormalization, and advanced relationship patterns.