Database design and migration patterns for Alembic migrations, schema design (SQL/NoSQL), and database versioning.
Database design patterns, SQL best practices, ORM usage (Prisma/Drizzle), and migration strategies.
Database reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns.
Implements production-ready database schemas and ORM models for full-stack applications with a focus on migrations and data integrity.
Database version control and change management patterns.
Transforms the assistant into a Senior Databricks Solutions Architect Agent that designs, implements, and reviews production-grade…
Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities.
Plans new DataHub connectors by classifying the source system, researching it using a dedicated agent or inline research, and generating a…
Deep expertise in creating and managing Dataverse tables, columns, relationships, option sets, and solutions via the Dataverse Web API…
Automate Airtable tasks via Rube MCP (Composio): records, bases, tables, fields, views.
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…