Databases Agent Skills

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

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments in PostgreSQL with Prisma…

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

Guide for querying databases through DBHub MCP server.

Build, test, and debug dbt projects across models, sources, data and unit tests, semantic layer, and CLI.

dbt (data build tool) patterns for model organization, incremental strategies, and testing.

Transform AI agents into experts on dbt command-line operations, model selection patterns, Jinja templating, and troubleshooting…

Complete guide for dbt data transformation including models, tests, documentation, incremental builds, macros, packages, and production…

Use when reviewing a new or changed dbt incremental model -- the strategy looks over-engineered, rebuild or delete behavior is unclear, or…

Transform AI agents into experts on writing production-quality dbt models, providing guidance on CTE patterns, SQL structure, and best…

Transform AI agents into experts on dbt and Snowflake performance optimization, providing guidance on choosing optimal materializations…

Use when a dbt change needs preflight before a PR, review, or merge -- changed models, snapshots, seeds, macros, or semantic YAML whose…

Deploy, manage, and monitor dbt projects natively within Snowflake using web-based workspaces, schema-level DBT PROJECT objects, and…

Generates dbt tests including schema tests, data quality tests, and freshness checks.

Diagnose a failed Bauplan job, pin the exact data state, collect evidence, apply a minimal fix, and rerun.

Design and build database schema — tables, columns, types, indexes, constraints, relationships.

Design data systems by understanding storage engines, replication, partitioning, transactions, and consistency models.

Apply data-correctness rules when writing or reviewing code that touches shared state — SQL/ORM queries and transactions, read replicas…

Use when Django ORM patterns with models, queries, and relationships.

USE FOR: Drasi continuous-query solutions - real-time queries, change detection, reactive events, data-trigger pipelines on Drasi Server…

Execute the proper Drizzle Kit workflow for database schema migrations in asset-forge.