Database Management Habilidades de Claude

TimescaleDB Expert

Optimizes time-series data management and PostgreSQL analytics through advanced hypertables, compression, and performance tuning.

Data Management Patterns

Provides standardized patterns for zero-downtime migrations, automated backups, data retention policies, and GDPR compliance workflows.

Redis Replication & High Availability

Configures and manages Redis master-replica architectures and Sentinel high-availability clusters for resilient data scaling.

Conversation State Management

Implements robust, database-persisted conversation tracking for stateless AI agents using PostgreSQL.

Airtable PM Data Model

Provides a standardized data model reference for orchestrating Product Management workflows and requirements within Airtable.

Database Recovery & Backup Manager

Automates database disaster recovery, point-in-time recovery (PITR), and failover strategies to ensure production system resilience.

Database Replication Manager

Automates the setup and management of database replication, failover, and high availability configurations for PostgreSQL and MySQL.

Database Schema Designer

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

Database Sharding Manager

Architects and implements horizontal database sharding strategies to scale data storage and performance across multiple servers.

Database Transaction Monitor

Monitors database transactions in real-time to detect long-running queries, lock contention, and transaction anomalies.

Database Seeder & Data Generator

Generates realistic, schema-aware test data and database seed scripts to populate development and testing environments.

Database Integrity & Validation Engine

Ensures database reliability by automatically implementing data types, ranges, and referential integrity constraints using a specialized validation engine.

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data models optimized for scalability in databases like MongoDB and DynamoDB.

ORM & Database Schema Generator

Generates production-ready ORM models and database schemas for frameworks like TypeORM, Prisma, and SQLAlchemy using natural language.

Database Query Performance Optimizer

Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks.

SQL Query Optimizer

Analyzes and refines SQL queries to enhance database performance through index recommendations and structural rewrites.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for major SQL databases to optimize performance and enforce business logic.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-efficiency table design, advanced query patterns, and real-time analytics best practices.

Database Design & Architecture

Architects optimized database schemas and selects the ideal data stack based on specific project requirements and performance needs.

NoSQL Database Architect

Architects high-scale distributed database schemas for Cassandra and DynamoDB using query-first modeling and performance-optimized patterns.

Database Design Architect

Optimizes database architecture by providing expert guidance on schema design, ORM selection, and performance indexing.

Database Design & Strategy

Architects high-performance database schemas and provides strategic guidance on database and ORM selection.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-performance schema design, analytical query patterns, and efficient data engineering practices.

ClickHouse Analytics & Data Engineering

Optimizes high-performance analytical workloads using specialized ClickHouse query patterns, table engines, and data engineering best practices.

NoSQL Expert Design Patterns

Architects high-performance distributed database schemas using query-first modeling and single-table design patterns for Cassandra and DynamoDB.

DuckDB ETL Pipeline

Automates the ingestion of CSV and Excel files into DuckDB with integrated data validation and markdown reporting.

NoSQL Expert Patterns

Optimizes distributed database architecture for Cassandra and DynamoDB using query-first modeling and high-scale design patterns.

Rails ActiveRecord Optimization Patterns

Optimizes Ruby on Rails database interactions with production-grade ActiveRecord patterns and performance best practices.

Firebase Backend Suite

Implements scalable serverless backend services including Firestore, Authentication, and Cloud Functions using production-grade security patterns.

SQL Expert & Data Modeling

Optimizes database performance through advanced query tuning, strategic indexing, and production-grade data modeling.