Databases Agent Skills for Claude Desktop

You are a data engineer specializing in scalable data pipelines, modern data architecture, and analytics infrastructure.

Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental…

Comprehensive performance optimization guide for Postgres, maintained by Supabase.

Generate database migrations for a Medusa module

Process, analyze, and visualize geospatial data at scale.

Reflection-first problem solving methodology for Convex development.

Use when hitting Salesforce governor limits in Apex — SOQL, DML, heap, CPU optimization, async offloading, bulk processing strategies.

Reviews database migrations, data models, and persistent data code for safety.

Validates data migrations, backfills, and production data transformations against reality.

Produces Go/No-Go deployment checklists with SQL verification queries, rollback procedures, and monitoring plans.

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow…

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

Build production-grade Azure Cosmos DB NoSQL services following clean code, security best practices, and TDD principles.

Use when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.

Django performance code review. Use when asked to "review Django performance", "find N+1 queries", "optimize Django", "check queryset…

JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in…

MUST use when writing MySQL queries.

Authors n8n database migrations. Use when creating or modifying files under packages/@n8n/db/src/migrations/, when the user asks to add a…

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL…