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?
Integrates with dbt for data transformation, lineage, and understanding of data pipeline changes.
AlicenseAqualityAmaintenanceglama.json already carries one, so this may prefill662 npm6AGPL 3.0Why 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.
AlicenseBqualityCmaintenanceA 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.2745 npmMITWhy 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?
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.346Apache 2.0Why this server?
Provides lineage information by reading the dbt manifest.json, allowing AI agents to trace metric dependencies from source models to marts.
AlicenseAqualityCmaintenanceExposes a governed semantic layer to AI agents so they select metrics and dimensions from a closed, engineer-declared vocabulary instead of writing SQL. Validates every typed call against the contract, rejects out-of-contract requests with structured errors and suggestions, and returns query rows together with the compiled SQL and dbt lineage for auditing.4MIT