Database Management Habilidades de Claude

Database Schema Designer

Designs production-ready SQL and NoSQL database schemas using industry-standard normalization, indexing, and performance optimization patterns.

WordPress SQL Query Manager

Executes SQL queries against WordPress development databases to inspect audit logs, debug table structures, and manage activity data.

Data Model Creation

Designs complex relational database schemas using Mermaid diagrams for enterprise-level documentation and automated relationship management.

Bkend Database Manager

Manages bkend.ai database schemas, CRUD operations, and complex data queries via MCP and REST APIs.

Senior Data Engineer

Builds scalable data pipelines, ETL/ELT systems, and production-grade data infrastructure using modern tools like Spark, Airflow, and dbt.

Fetch dbt Documentation

Retrieves and searches dbt documentation in LLM-friendly markdown format for dbt Cloud, Core, and the Semantic Layer.

dbt MCP Server Configurator

Automates the setup and configuration of Model Context Protocol (MCP) servers to integrate dbt workflows with AI coding assistants.

dbt Fusion Migration Assistant

Triages and classifies dbt-core to Fusion migration errors into actionable categories to streamline data project upgrades.

Running dbt Commands

Optimizes and executes dbt CLI workflows with smart command formatting and resource selection.

dbt Unit Test Generator

Generates standardized dbt unit test YAML definitions to validate SQL transformation logic using mocked inputs and expected outputs.

Cross-Platform dbt Migration

Migrates dbt projects between data platforms like Snowflake and Databricks using real-time SQL dialect conversion and validation.

dbt Semantic Layer Builder

Automates the definition and validation of dbt Semantic Layer components to create consistent, governed business metrics.

dbt Analytics Engineering

Builds, modifies, and validates dbt models using industry best practices for modular data transformation and automated testing.

Django Performance Review

Analyzes and validates Django code to identify high-impact performance bottlenecks like N+1 queries, unbounded querysets, and missing database indexes.

Supabase Database Explorer

Enables seamless exploration and querying of Supabase databases directly through Claude's interface.

MongoDB Management & Optimization

Provides expert guidance on MongoDB schema design, indexing strategies, and aggregation pipeline optimization for high-performance database management.

MongoDB Setup & Troubleshooting

Streamlines the configuration and troubleshooting of MongoDB MCP integrations for Claude Code.

Supabase MCP Setup

Streamlines the configuration and troubleshooting of Supabase MCP integrations within the Claude Code environment.

Firebase Firestore Database

Builds and manages scalable NoSQL databases with real-time synchronization, offline support, and advanced querying capabilities.

Axiom Database Migration

Ensures safe database schema evolution and prevents data loss in iOS and macOS applications using SQLite, GRDB, or SwiftData.

Datasette Plugin Development

Provides comprehensive guidance and implementation patterns for building, testing, and deploying custom plugins for the Datasette data exploration tool.

Backend Migration Standards

Creates and manages database migrations with reversible changes, proper naming conventions, and zero-downtime deployment strategies.

Backend Models Standards

Defines robust and maintainable database models with clear naming, appropriate data types, constraints, and relationships.

Database Performance Patterns

Optimizes .NET data access layers using high-performance patterns like CQRS, batching, and efficient querying with EF Core and Dapper.

Upstash Redis KV Store

Interact with Upstash Redis-compatible key-value stores to persist data, manage caches, and handle complex data structures.

Upstash Redis KV Connector

Manages data in Upstash Redis-compatible stores using a comprehensive suite of REST-based commands for caching, state management, and real-time data structures.

EF Core .NET 10 Expert

Implements high-performance Entity Framework Core patterns and database management workflows for .NET 10 applications.

Migration Workflow

Provides structured, safe procedures for EF Core database migrations, .NET version upgrades, and NuGet dependency management.

PostgreSQL to TimescaleDB Hypertable Migration

Migrates standard PostgreSQL tables to TimescaleDB hypertables using optimized partitioning, chunking, and compression configurations.

PostgreSQL Hypertable Candidate Finder

Analyzes PostgreSQL database schemas and query patterns to identify tables that would benefit from TimescaleDB hypertable conversion.