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.
AlicenseBqualityDmaintenanceAgentic 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?
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 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.
AlicenseBqualityBmaintenanceA 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.2735 npmMITWhy 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?
Supports importing and exporting dbt semantic interfaces for use in the semantic model.
AlicenseAqualityAmaintenanceAnswers natural-language questions against Postgres, Oracle, Snowflake, Databricks, DuckDB and SQLite via db_read(question) and get_schema(), each separately grantable. The model only proposes SQL — shape, access, dialect and query plan are checked deterministically before any rows are read, and the server refuses rather than returning an unverified answer.341Apache 2.0Why 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 compiling, previewing, and validating dbt transformations, as well as listing and triggering dbt runs and managing dbt orchestration pipelines.
AlicenseAqualityAmaintenanceRead-only-by-default MCP server for Datanika, an open-source dlt + dbt-core data pipeline platform: browse connections, introspect and preview source tables, compile and run dbt transformations, and monitor pipeline runs. 25 tools (17 read-only, plus 8 write tools gated behind --allow-write); source lives in the datanika-mcp/ subdirectory of the repo.25AGPL 3.0Why this server?
Integrates with dbt projects to auto-detect schema definitions and semantic layers for curated querying.
AlicenseAqualityCmaintenanceSchemaBrain is an MCP server that sits between AI agents (Claude, Cursor, Windsurf) and your SQL database as a read-only trust + intelligence layer. The agent never writes SQL — 12 tools compile it from definitions you control, PII and secret categories are refused before the query runs, and every call lands in a tamper-evident (SHA-256-chained) audit log. Postgres today.1224 PyPI9Apache 2.0