Database Management Habilidades de Claude

PostgreSQL Rails Analyzer

Audits Ruby on Rails applications for PostgreSQL performance bottlenecks, N+1 queries, and missing database indexes.

Supabase Patterns & Best Practices

Standardizes Supabase implementations by providing patterns for authentication, row-level security, and database schema design.

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.

PostgreSQL Table Design

Architects optimized PostgreSQL database schemas following production-grade best practices for performance, scalability, and data integrity.

Entity-Yajña Knowledge Linker

Synchronizes triplet entities with content nodes to build searchable, high-performance knowledge graphs within the Soul ecosystem.

Event Store Design & Implementation

Designs and implements robust event store architectures for event-sourced systems and microservices.

Database Migration

Facilitates seamless database schema and data migrations across multiple ORMs with zero-downtime strategies and robust rollback procedures.

Projection Patterns for Event Sourcing

Build efficient read models and materialized views from event streams to optimize query performance and implement CQRS architectures.

Data Quality Frameworks

Implements comprehensive data validation using Great Expectations, dbt tests, and data contracts to ensure reliable data pipelines.

DBT Transformation Patterns

Implements production-ready dbt patterns for scalable data transformation, model organization, and analytics engineering best practices.

Database Architect & Manager

Streamlines the design, management, and optimization of MongoDB and PostgreSQL databases through schema modeling, complex querying, and performance tuning.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, EXPLAIN plan analysis, and query restructuring patterns.

WordPress Database SQL Manager

Executes SQL queries against WordPress development databases via Docker containers to inspect data and debug issues.

Unified Database Management

Streamlines schema design, query optimization, and administrative workflows for MongoDB and PostgreSQL database systems.

WordPress SQL Database Manager

Executes SQL queries against WordPress development databases running in Docker MariaDB environments.

Database Management & Design

Manages, designs, and optimizes MongoDB and PostgreSQL databases through schema modeling, query generation, and performance tuning.

Pinecone Vector Database Integration

Streamlines the implementation and optimization of Pinecone vector databases for production-grade RAG and semantic search applications.

Database Schema Architect

Analyzes database schemas and migration files to visualize data models, map table relationships, and accelerate developer onboarding.

Database Schema & Query Expert

Manages and optimizes MongoDB and PostgreSQL databases through expert schema design, query generation, and administration patterns.

MongoDB Query & Explorer

Enables read-only exploration and querying of MongoDB databases through an integrated MCP server.

SQL Research Specialist

Conducts systematic research on SQL syntax and database behaviors to ensure accurate implementation and translation.

MongoDB Database Explorer

Explores and queries MongoDB databases to retrieve data, inspect schemas, and analyze collections through secure, read-only access.

MongoDB Database Explorer

Enables read-only exploration and querying of MongoDB databases using Model Context Protocol tools.

Wheels Migration Generator

Generates database-agnostic CFWheels migrations for schema management, table modification, and data versioning.

Database Migration & Schema Evolution

Manages complex database schema transitions and data transformations across multiple ORMs with a focus on zero-downtime and safety.

TimescaleDB Setup & Hypertable Configuration

Configures high-performance TimescaleDB hypertables with optimized compression, retention policies, and continuous aggregates.

Wheels Migration Generator

Generates database-agnostic CFML migrations for the Wheels framework to manage schema changes reliably.

Wheels Migration Generator

Generates database-agnostic CFWheels migrations for schema management while enforcing best practices and fixing common CLI bugs.

Wheels Migration Generator

Generates database-agnostic CFWheels migrations for schema management, table creation, and cross-platform database consistency.