Database Management Habilidades de Claude

ClickHouse Analytics & Data Engineering

Implements high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for analytical workloads.

PostgreSQL Expert

Streamlines PostgreSQL development, administration, and performance tuning through comprehensive documentation and best practices.

WorldCrafter Database Setup

Generates Prisma models, database migrations, and Row-Level Security policies to establish a secure data foundation for world-building features.

Database Query Safety

Prevents silent failures and data loss in Supabase and PostgREST queries by identifying eight critical implementation pitfalls.

Data Integrity & Financial Accuracy

Enforces strict accuracy and traceability standards for data display, transformation, and storage within financial applications.

Migration Safety & Reliability

Safeguards database schema changes with idempotent patterns and PostgreSQL best practices to prevent migration failures and data loss.

Neon Database Manager

Manages Neon serverless Postgres databases, branching workflows, and connection strings directly through the CLI.

Supabase pgvector Setup

Configures pgvector on Supabase to enable high-performance semantic search, RAG systems, and hybrid search capabilities.

Rails Performance Optimization

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

Snowflake Automation

Automates Snowflake data warehouse operations including schema discovery, metadata inspection, and SQL execution via Composio MCP.

Neon Automation

Automates Neon serverless Postgres operations by managing projects, branches, databases, and secure connection strings via the Composio MCP.

Algolia Automation

Automates Algolia search indexing and management tasks through the Rube MCP and Composio toolkit.

Baserow Automation

Automates Baserow database operations and data management workflows via the Rube MCP server.

Reference Field Manager

Automates the creation and synchronization of embedded reference fields between Express.js and MongoDB resources.

Express MongoDB Seed & Script Generator

Automates the generation of database seed files and migration scripts for Express.js and MongoDB applications.

Database Migration Patterns

Implements safe, reversible database schema changes and zero-downtime deployment strategies across major SQL databases and ORMs.

Kotlin Exposed Patterns

Implements production-grade database access patterns using the JetBrains Exposed ORM for Kotlin applications.

PostgreSQL Patterns

Provides optimized PostgreSQL database patterns for query performance, schema design, and security enforcement.

Safe Database Migrations

Implements safe, reversible database schema changes and zero-downtime deployment patterns across major SQL databases and ORMs.

ClickHouse Analytics & Performance

Optimizes high-performance analytical workloads using ClickHouse-specific schema designs, query patterns, and data engineering best practices.

PostgreSQL Patterns & Optimization

Optimizes database development with expert PostgreSQL patterns for query performance, schema design, and high-performance indexing.

JPA & Hibernate Patterns for Spring Boot

Optimizes Java persistence layers with production-ready JPA and Hibernate patterns for Spring Boot applications.

DBT Model Developer

Automates the design and implementation of dbt models using standardized data warehouse architectures and best practices.

Dremio Cloud Data Assistant

Facilitates data ingestion, transformation, and querying within Dremio Cloud using optimized SQL and REST API integrations.

dbt Model Optimizer

Optimizes and refactors dbt models to improve SQL performance and data transformation efficiency.

DBT Model Visualizer

Automates the generation of ER diagrams, lineage charts, and metadata reports for DBT projects using dbterd and Mermaid.

dbt Quality Rule Definer

Automates the definition and configuration of dbt-expectations data quality tests for dbt projects using LLM-driven schema analysis.

Data Structure & DBT Analyzer

Conducts comprehensive database reverse engineering and metadata analysis to generate actionable data lineage reports.

Database Migrations & Schema Management

Implement safe, reversible database schema changes and zero-downtime deployments using industry-standard migration patterns.

DBT Job Runner

Executes and monitors DBT projects with intelligent error handling, performance analysis, and automated model retries.