Database Management Habilidades de Claude

Read-Only SQL Lookup

Executes safe, read-only PostgreSQL queries to inspect repository data and verify database records.

PostgreSQL Table Design

Architects high-performance PostgreSQL schemas using industry best practices for data integrity, indexing, and advanced features.

Database Migration Master

Facilitates seamless database schema and data migrations across multiple ORMs with a focus on zero-downtime strategies and safety.

dbt Data Modeling Expert

Implements industry-standard dbt patterns for scalable data transformation, automated testing, and comprehensive documentation.

Database Management & Design

Optimizes database performance and manages schema design, migrations, and complex SQL query generation for relational databases.

Database Schema Reviewer

Analyzes and optimizes database schemas for normalization, data integrity, and high-performance indexing.

Migration Checker

Audits database migrations for schema safety, data integrity, and zero-downtime deployment patterns.

Mongo TS

Executes native MongoDB query syntax directly from the command line with built-in safety features and flexible output formatting.

Supabase Expert

Implements high-performance database architectures, secure Row Level Security policies, and type-safe data services for Supabase environments.

Backend Migrations

Generates robust database migrations following Laravel best practices for reversible schema changes and optimal performance.

ClickHouse Analytics & Data Patterns

Optimizes ClickHouse database performance with expert patterns for schema design, high-volume data ingestion, and complex analytical queries.

Optimizing Performance

Identifies and resolves performance bottlenecks across databases, application logic, and infrastructure using proven optimization patterns.

PowerSync Local-First Development

Builds offline-capable, local-first TypeScript applications by synchronizing SQLite with backend databases like Postgres and MongoDB.

Black Lake DB Metadata Helper

Accesses and queries Black Lake v3_metadata database tables for object codes, events, custom fields, and system configurations.

Common Database Queries

Provides a standardized workflow and SQL templates for efficient database querying and structured result analysis using the exec_sql tool.

JUDO RDBMS Query Debugger

Troubleshoots and traces JUDO DAO SQL generation to resolve performance bottlenecks and query inaccuracies.

JUDO RDBMS Dialect Extension

Extends the JUDO DAO framework to support new database dialects like MySQL, Oracle, and custom RDBMS systems.

JUDO Query Optimization

Optimizes JUDO query performance by analyzing join strategies, caching mechanisms, and expression evaluation patterns.

Universal Database Query Tool

Executes and manages SQL queries while providing structured schema insights and formatted data results via MCP tools.

JUDO Expression Syntax

Facilitates the implementation and debugging of JUDO expression metamodels and transfer object bindings.

Backend Queries

Optimizes database performance and security through efficient query patterns, eager loading, and transaction management.

JUDO DAO Core Patterns

Guides the implementation of standardized data access patterns, payload processing, and entity lifecycle management within the JUDO framework.

OP Database Metadata Manager

Provides specialized SQL query templates for managing and exploring v3_metadata database structures, including business objects and custom fields.

Sequelize Migration Expert

Provides battle-tested Sequelize migration patterns and best practices for safe PostgreSQL schema changes.

AgentDB Advanced Features

Implements advanced vector database capabilities including QUIC synchronization, hybrid search, and distributed multi-agent coordination.

AgentDB Vector Search

Implements high-performance semantic vector search and document retrieval for RAG systems and intelligent knowledge bases.

JUDO Query Translation

Translates logical JUDO expressions and models into structured SQL queries for efficient data retrieval.

Codebase & Schema Explorer

Accelerates codebase onboarding by automating the discovery of database schemas, API endpoints, and architectural patterns.

AgentDB Vector Search

Implements high-performance semantic vector search and intelligent document retrieval using HNSW indexing and quantization for sub-millisecond querying.

JUDO Custom RDBMS Queries

Extends the JUDO DAO RDBMS query translation layer with custom mappers, translators, and join strategies.