Database Management Claude 技能

Database Designer

Designs production-ready database schemas and generates SQL scripts, ER diagrams, and comprehensive documentation.

Database Schema Designer

Generates production-ready database schemas with executable SQL scripts, visual ER diagrams, and comprehensive Markdown documentation.

Spring Boot Data DDD

Implements Domain-Driven Design (DDD) tactical patterns in the Spring Boot 4 data layer using JPA or JDBC.

Database Replication Manager

Automates the design, implementation, and scaling of database replication and sharding architectures for high-availability systems.

PostgreSQL Schema Architect

Designs optimized, production-ready PostgreSQL schemas following industry best practices for data integrity and performance.

SQL Optimization Patterns

Optimizes database performance through advanced query patterns, indexing strategies, and detailed execution plan analysis.

Database Migration & Schema Evolution

Manages complex database migrations, schema transformations, and zero-downtime deployment strategies across multiple ORMs.

Python Database Patterns

Implements modern SQLAlchemy 2.0 patterns and asynchronous database workflows for Python applications.

Data Quality Validation Patterns

Provides standardized SQL templates and strategies for validating data consistency between dbt models during migrations and refactors.

Database Migration Best Practices

Implements industry-standard database migration strategies including zero-downtime patterns, rollback procedures, and schema safety protocols.

Database Recovery & Resilience Manager

Orchestrates complex database recovery operations including point-in-time recovery, disaster recovery planning, and automated failover management.

Database Migration & Schema Evolution

Manages complex database migrations, schema transformations, and zero-downtime deployment strategies across multiple ORMs.

NoSQL Data Modeler

Designs, optimizes, and implements high-performance NoSQL database schemas and document structures with automated guidance.

CQRS Projection Patterns

Builds efficient read models and materialized views from event streams to optimize query performance in event-sourced architectures.

Database Recovery Manager

Manages automated database recovery, point-in-time restoration, and disaster recovery strategies for production environments.

Database Schema Diff & Migration Tool

Compares database schemas and generates transaction-safe migration scripts with automated rollback procedures for PostgreSQL and MySQL.

Database Data Validation Engine

Enforces database integrity and business rules by automating the validation of data types, ranges, and complex formats.

Database Audit Logger

Implements robust database audit logging and change tracking to ensure data integrity and regulatory compliance.

Database Archival System

Automates the migration of historical database records to cold storage to optimize performance and ensure compliance.

Database Documentation Generator

Generates comprehensive schema documentation, ERD diagrams, and data dictionaries automatically from existing databases.

AgentDB Performance Optimization

Optimizes AgentDB vector databases using quantization, HNSW indexing, and advanced caching for ultra-fast, memory-efficient AI agent performance.

Database Partition Manager

Automates the design and implementation of database partitioning strategies to optimize query performance and manage large-scale datasets.

Database Index Advisor

Optimizes database query performance through intelligent index design, implementation, and automated performance validation.

Database Data Validation Engine

Automates the enforcement of data types, referential integrity, and custom business rules across database schemas to ensure high-quality data storage.

Database Recovery Manager

Automates database disaster recovery, point-in-time restoration, and failover orchestration for production systems.

Database Schema Designer

Architects normalized database schemas, generates visual ERD diagrams, and produces optimized SQL scripts for production environments.

PostgreSQL & Drizzle ORM Setup

Configures a type-safe PostgreSQL database layer with Drizzle ORM, Docker-based local development, and production-ready migration workflows.

NoSQL Data Modeler

Architects efficient NoSQL database schemas and document structures for high-performance applications like MongoDB and DynamoDB.

Database Schema Designer

Architects optimized relational database schemas through normalization, ERD visualization, and automated SQL generation.

Database Design Decisions

Guides architectural choices for database systems, schema design, and scaling patterns to optimize performance and consistency.