Database Management Claude 技能

Database Schema Comparison & Migration

Automates database schema comparisons, migration script generation, and rollback procedures for PostgreSQL and MySQL environments.

Database Index Advisor

Optimizes database performance by analyzing query workloads to recommend missing indexes and identify redundant ones.

Database Deadlock Detector

Identifies, analyzes, and resolves database lock contention and transaction deadlocks to maintain system stability.

Stored Procedure Generator

Generates production-ready stored procedures, triggers, and custom database logic for PostgreSQL, MySQL, and SQL Server.

Query Performance Analyzer

Analyzes database EXPLAIN plans to pinpoint performance bottlenecks and provide actionable optimization strategies.

Database Deadlock Detector

Detects, analyzes, and prevents database deadlocks by monitoring lock contention and transaction patterns in real-time.

Database Replication Manager

Automates the configuration and management of database replication, failover, and high availability for distributed SQL environments.

Database Query Performance Analyzer

Analyzes and optimizes database query performance by interpreting EXPLAIN plans and identifying execution bottlenecks.

Database Partition Manager

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

Stored Procedure Generator

Generates production-ready stored procedures, triggers, and functions to handle complex database logic and optimize performance.

Database Schema Designer

Designs, visualizes, and normalizes robust database schemas while generating SQL and Mermaid ERD diagrams.

Database Migration Manager

Automates database schema evolution by generating and managing version-controlled migrations for SQL and NoSQL databases.

NoSQL Data Modeler

Designs optimized NoSQL database schemas and data models for high-performance applications using MongoDB, DynamoDB, and more.

Database Caching Layer

Implements high-performance multi-tier caching architectures to optimize database query latency and reduce server load.

NoSQL Data Modeler

Designs efficient NoSQL data models and schemas optimized for performance and scalability across document and key-value databases.

Database Audit Logger

Automates the implementation of robust database audit trails and change tracking to ensure data compliance and security.

Database Migration Manager

Automates the creation, application, and rollback of version-controlled database migrations across multiple SQL and NoSQL engines.

Database ORM Generator

Generates optimized ORM models and database schemas across multiple frameworks to streamline backend data persistence.

Database Partition Manager

Automates the design, implementation, and management of database partitioning strategies to optimize performance for datasets exceeding 100GB.

Database Connection Pooler

Optimizes database performance and resource management by implementing and fine-tuning connection pooling configurations across multiple programming languages.

Database Backup Automator

Automates the creation of scheduled, encrypted database backups and recovery procedures for PostgreSQL, MySQL, MongoDB, and SQLite.

Database Documentation Generator

Automates the creation of comprehensive database documentation, ERD diagrams, and data dictionaries from existing schemas.

Database Integrity & Validation

Automates the enforcement of database integrity through rigorous data type, range, and format validation rules.

Query Performance Analyzer

Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks like missing indexes or inefficient joins.

FairDB Backup Manager

Manages and automates PostgreSQL backup and recovery operations using pgBackRest and Wasabi S3 storage.

Database Partition Manager

Automates the design, implementation, and management of table partitioning strategies to optimize database performance for large-scale datasets.

Database Caching Implementation

Implements multi-tier database caching solutions using Redis, in-memory layers, and CDNs to optimize query performance and reduce backend load.

Database Diff Tool

Compares and synchronizes database schemas across different environments using automated guidance and structured validation workflows.

SQL Query Optimizer

Optimizes database query performance through structured analysis, automated implementation, and comprehensive validation across multiple database systems.

NoSQL Data Modeler

Designs and optimizes non-relational database structures through structured architectural guidance and automated implementation workflows.