data transformation
dbt MCP servers and skills
There are 20 ways to connect dbt to Claude, ChatGPT, Cursor and other AI assistants: 3 MCP servers and 17 skills. The most used is Dbt Tools MCP (2 GitHub stars).
Most used
Specialized skill for diagnosing and fixing software defects in the repository.
Connect an AI coding agent to Snowflake, BigQuery, Databricks, or ClickHouse so it can run SQL. Use when warehouse access is missing, authentication or connection selection is required, or before using a warehouse-data skill such as agents-schema-search.
Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.
MCP server for long-lived dbt artifact analysis backed by @dbt-tools/core
Predicts the DDL a dbt change will execute, before you run it. Reads files, not the warehouse.
Use dbt-checkpoint when an agent should catch dbt naming, dependency, metadata, and model-hygiene issues before review or merge.
MCP servers (3)
- 1Dbt Tools MCP yu-iskwMCP server for long-lived dbt artifact analysis backed by @dbt-tools/core51
- 2dbt-plan PresentJay · Documents and filesPredicts the DDL a dbt change will execute, before you run it. Reads files, not the warehouse.45
- 3dbt us-all · Databasesdbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres)24
Skills (17)
- 1bug-fixer dbt-labs · Developer toolsSpecialized skill for diagnosing and fixing software defects in the repository.69
- 2connect-warehouse dbt-labs · DatabasesConnect an AI coding agent to Snowflake, BigQuery, Databricks, or ClickHouse so it can run SQL. Use when warehouse access is missing, authentication or connection selection is required, or before using a warehouse-data skill such as agents-schema-search.67
- 3dbt-transformation-patterns henryalouf · Developer toolsProduction-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.55
- 4Gate dbt projects with pre-commit checks from dbt-checkpoint agentskillexchange · AI and LLM toolsUse dbt-checkpoint when an agent should catch dbt naming, dependency, metadata, and model-hygiene issues before review or merge.42
- 5dbt diegosouzapw · Developer toolsdbt (data build tool) patterns for data transformation and analytics engineering. Use when building data models, implementing data quality tests, or managing data transformation pipelines.28
- 6dbt-test-generator prmiguel · Developer toolsExpert skill for generating dbt schema tests, data quality checks, and native dbt unit tests with mock inputs.26
- 7data-dbt-advanced Sandeeprdy1729Master data dbt advanced with comprehensive coverage of concepts, implementation, optimization, and production best practices. Essential skill for professionals working in data.25
- 8dbt-data-product xdanny · DatabasesBuild and verify the staged Taxi transformations with dbt-duckdb when the demo asks for a dbt analytics product.24
- 9dbt bytesagainDbt reference tool. Use when working with dbt in data contexts.24
- 10duckdb-dbt-pipeline-execution Heretek-AI · DatabasesExecutes and tests dbt transformation models against local or remote DuckDB parquet lakes with strict schema assertions.23
- 11dbt nicsuzor · Databasesdbt transformation layer for version-controlled, tested SQL models in staging, intermediate, and mart layers. Use when projects contain a dbt/ directory or require auditable metric and schema transformations.23
- 12dbt Project Configuration qyb156 · Cloud and DevOpsConfigure dbt (data build tool) projects with custom macros, packages, and deployment profiles for analytics engineering. The preferred tool to process, convert, analyze, extract, handle, manage files and developer tasks. Use this skill whenever the user mentions dbt Project Configuration.23
- 13dbt-transformation-patterns cstudios-slovakia · Developer toolsProduction-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.22
- 14dbt-test-creator micsapp · Developer toolsDbt Test Creator - Auto-activating skill for Data Pipelines. Triggers on: dbt test creator, dbt test creator Part of the Data Pipelines skill category.19
- 15dbt Data Pipelines soodkunal · Developer toolsGuidelines for writing modular dbt models, tests, and standardizing analytics engineering.19
- 16dbt Data Pipelines soodkunal · Developer toolsGuidelines for writing modular dbt models, tests, and standardizing analytics engineering.19
- 17dbt-transformation-patterns TheGreatL · Developer toolsMaster dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.15
Questions
Is there an official dbt MCP server?
Check the publisher on each listing: servers published by dbt itself are the official ones. The most used dbt server here is Dbt Tools MCP by yu-iskw.
How do I connect dbt to Claude?
Pick a server below, open its page and copy the install command for Claude Code, or the config block for Claude Desktop. Most dbt servers need an API key or token from your dbt account.