Database Management Habilidades de Claude

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.

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.

Database Design Decisions

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

Cache Performance Optimizer

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

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 Caching Layer

Implements production-ready multi-tier caching architectures to optimize database performance and reduce latency.

Query Performance Analyzer

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

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data structures for MongoDB, DynamoDB, and other non-relational databases.

Database Replication Manager

Automates the configuration and management of database replication, failover, and high availability for robust data consistency.

Database Documentation Generator

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

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data models optimized for scalability and specific query access patterns.

Database Replication Manager

Automates the configuration and management of database replication, failover procedures, and high availability settings for PostgreSQL and MySQL.

ORM Code Generator

Automates the creation of ORM models, entity classes, and database schemas with standardized best practices and comprehensive documentation.

Database Schema Designer

Designs, normalizes, and visualizes efficient database schemas using industry best practices and automated ERD generation.

Database Schema Designer

Architects normalized database schemas, generates Mermaid ERD diagrams, and produces optimized SQL CREATE statements for robust data modeling.

FairDB Backup Manager

Automates PostgreSQL backup and recovery operations using pgBackRest and Wasabi S3 storage for FairDB environments.

Database Sharding Manager

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

Database Logic & Stored Procedure Generator

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