Best dbt MCP Servers
dbt (data build tool) is an open-source command-line tool that enables data analysts and engineers to transform data in their warehouses using SQL. It helps organizations build reliable data pipelines and analytics workflows through version control, documentation, and testing.
Why this server?
Integrates with dbt pipelines to run data quality checks as part of transformation workflows.
AlicenseBqualityCmaintenanceAgentic data quality MCP server — runs structured validation rules against warehouses (DuckDB, BigQuery, Athena, Databricks, Postgres), diagnoses failures with LLM root cause analysis, and proposes SQL remediations. Full audit trail of every AI decision.64Apache 2.0Why this server?
Provides tools to interact with dbt, including executing dbt CLI commands (build, compile, run, test), accessing Semantic Layer for metric querying, and using Discovery API to explore models and their relationships in a dbt project.
Why this server?
Provides optional dbt adapters for governed extension packs, allowing integration with dbt transformation workflows while remaining advisory and not altering readiness state.
Why this server?
Provides tools for interacting with a dbt project, enabling AI agents to list models, tests, sources, exposures, macros, runs, check freshness, coverage, and explore the DAG using the project's manifest, run results, and catalog.
AlicenseBqualityAmaintenanceA read-only MCP server that exposes dbt project artifacts and data quality result tables (BigQuery/Postgres) to LLM clients, enabling deep introspection, run-history analysis, source freshness, test coverage, and lineage walks.2777MITWhy this server?
Integrates with dbt for data transformation, lineage, and understanding of data pipeline changes.
AlicenseAqualityAmaintenanceglama.json already carries one, so this may prefill61275AGPL 3.0Why this server?
Allows AI agents to execute dbt CLI commands and interact with dbt projects. Supports operations like run, test, compile, list resources, debug, install dependencies, and load seed data.
AlicenseAqualityDmaintenanceA Model Context Protocol (MCP) server that wraps the dbt CLI tool, enabling AI coding agents to interact with dbt projects through standardized MCP tools. Developed by Mammoth Growth.918MITWhy this server?
Provides remediation for dbt projects by detecting schema-drift incidents against DataHub lineage, generating minimal dbt compatibility patches, and verifying them with dbt parse before human approval.
Why this server?
Works with dbt to automatically profile and monitor data models after runs.
Why this server?
Generates dbt-fabric project file contents for a Fabric Data Warehouse, enabling data transformation workflows with dbt.
AlicenseBqualityAmaintenanceCLI and MCP server for administering Microsoft Fabric Data Warehouses and SQL Analytics Endpoints.12110MIT