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?
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.2726 npmMITWhy this server?
Integrates with dbt's semantic layer concepts and is positioned as an alternative to raw SQL generation by AI agents, with references to dbt's benchmark analysis comparing semantic layers to text-to-SQL approaches.
AlicenseAqualityAmaintenanceAgent-native semantic layer, letting AI agents query databases through specifying intent instead of writing SQL, then compiling structured queries into correct, dialect-aware SQL. Dynamic and expressive, supporting multi-stage queries, time-shifts, and complex join schemas.201,223 PyPI318MITWhy this server?
Enables searching dbt models to assist in identifying dependencies and source tables during data pipeline audits.
FlicenseBqualityBmaintenanceRead-only MCP tools for TROCCO API, enabling workflow and BigQuery datamart audit information retrieval.2-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.3111Apache 2.0Why this server?
Enables interaction with DBT (Data Build Tool) projects, allowing querying of project metadata, inspection of models, sources, and tests, viewing compiled SQL, running DBT commands, and accessing DBT documentation and lineage.
AlicenseAqualityCmaintenanceEnables AI assistants to interact with DBT (Data Build Tool) projects, allowing them to query project metadata, inspect models and sources, view compiled SQL, and run DBT commands.1435 PyPI15MITWhy 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?
Integrates with dbt projects to auto-detect schema definitions and semantic layers for curated querying.
AlicenseAqualityBmaintenanceSchemaBrain 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.1212Apache 2.0