Database Management Habilidades de Claude

Database Schema Diff & Migration Tool

Automates database schema comparisons and generates transaction-safe migration scripts for PostgreSQL and MySQL environments.

Database Index Advisor

Analyzes database query patterns and workloads to provide actionable recommendations for index optimization and storage efficiency.

Database Index Advisor

Analyzes database workloads and query patterns to provide actionable recommendations for optimizing and managing indexes.

Database Recovery Manager

Automates database disaster recovery, point-in-time recovery (PITR), and failover strategies to ensure high availability and data resilience.

Database Recovery Manager

Automates database disaster recovery, point-in-time recovery, and failover strategies for production environments.

Database Sharding Manager

Designs and implements horizontal database sharding strategies to scale applications beyond single-server limitations.

Firestore Operations Manager

Manages Firebase Firestore operations, A2A agent communication patterns, and MCP server integrations for advanced database workflows.

SQL Query Optimizer

Optimizes SQL queries and database performance by identifying bottlenecks, suggesting indexes, and rewriting complex queries.

Database Documentation Generator

Generates comprehensive database documentation, ERD diagrams, and data dictionaries automatically from existing schemas.

SQL Query Optimizer

Analyzes and refines SQL queries to eliminate performance bottlenecks and improve database execution speed.

Cache Performance Optimizer

Optimizes application caching strategies by analyzing hit rates, TTL configurations, and key design to enhance system performance.

Database Archival System

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

Database Backup Automator

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

Database Deadlock Detector

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

Database Schema Comparison & Migration

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

Database Documentation Generator

Generates comprehensive database documentation, ERD diagrams, and data dictionaries from existing schemas automatically.

Database Migration Manager

Manages database schema changes through automated, version-controlled migration files for SQL and NoSQL databases.

Database Partition Manager

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

Database Recovery Manager

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

Database Replication Manager

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

Database Schema Designer

Designs, normalizes, and visualizes relational database schemas with automated SQL generation and ERD mapping.

Database Sharding Manager

Designs and implements horizontal database sharding strategies to scale applications beyond single-server limitations.

Database Integrity & Validation

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

NoSQL Data Modeler

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

Database Query Performance Analyzer

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

Stored Procedure Generator

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

FairDB Backup Manager

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

FairDB Backup Manager

Automates PostgreSQL backup, restoration, and monitoring workflows using pgBackRest and Wasabi S3 storage.

Database Schema Designer

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

Database Documentation Generator

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