Database Management Habilidades de Claude

Flyway Migration Generator

Generates standardized Flyway SQL migrations optimized for DDD scaffolds without foreign key constraints.

Database Replication Manager

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

Backend Models

Defines and optimizes database models and ORM entities with robust relationships, data validation, and integrity constraints.

Backend Models

Defines robust database schemas and ORM entities with precise data types, relationships, and validation constraints.

NoSQL Data Modeler

Designs and optimizes high-performance NoSQL schemas for MongoDB, DynamoDB, and other document-based databases using industry best practices.

Database Migration (SQLModel + Alembic)

Automates database migration workflows for SQLModel projects using Alembic with strict enforcement of model-first principles and safety checks.

Database Index Advisor

Analyzes query workloads and provides actionable recommendations to optimize database indexing strategies for improved performance.

Query Performance Analyzer

Analyzes database EXPLAIN plans to identify performance bottlenecks and provide actionable SQL optimization recommendations.

Drizzle Cube Definition

Defines type-safe semantic layer cubes using Drizzle ORM for multi-tenant analytics and business logic abstraction.

Database Designer

Infers and generates database schemas, migrations, and ORM models directly from natural language feature descriptions.

Supabase Migration Toolkit

Manages Supabase database migrations using standardized naming conventions, automated linting, and security-first SQL templates.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers across major SQL databases using natural language.

Database Deadlock Detector

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

SQLDelight KMP Database Integration

Generates type-safe Kotlin APIs from SQL schemas for robust cross-platform data persistence in Kotlin Multiplatform projects.

Database Deadlock Detector

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

Stored Procedure Generator

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

SQL Query Optimizer

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

Database Connection Pooler

Optimizes database connection pooling and lifecycle management to enhance application performance and resource efficiency.

DynamoDB Single-Table Designer

Architects high-performance, production-ready AWS DynamoDB schemas using single-table design principles to optimize scalability and cost.

AGI Memory System

Manages persistent AI memory through semantic, episodic, and working storage to enhance long-term context and knowledge recall.

Database Connection Optimizer

Enhances application performance by configuring and optimizing database connection pools across various programming languages.

Database Audit Logger

Implements comprehensive database audit logging to track data changes, maintain compliance, and enhance system observability.

Rails Performance Optimization

Optimizes Ruby on Rails applications by identifying and resolving N+1 queries, implementing efficient caching, and managing background processing.

Rails Active Record Patterns

Optimizes Ruby on Rails data models using industry-standard ActiveRecord patterns for associations, validations, and high-performance queries.

Database Schema Designer

Designs, normalizes, and visualizes robust relational database schemas using industry best practices and Mermaid ERD diagrams.

Warehouse Optimization

Optimizes data warehouse performance through efficient partitioning, query tuning, and cost-effective resource management.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient SQL patterns.

PostgreSQL Table Design

Architects high-performance, production-ready PostgreSQL schemas using modern best practices and advanced indexing patterns.

Supabase RLS Policy Setup

Configures production-ready Row Level Security policies for Supabase tables to ensure secure, role-based data access.

Atomic Transaction Manager for Supabase

Implements secure, atomic PostgreSQL transactions in Supabase using PL/pgSQL RPC functions to ensure data consistency.