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.
AlicenseBqualityAmaintenanceAgentic 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.Last updated64Apache 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 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.Last updated129Apache 2.0Why this server?
Supports dbt tasks in job creation and execution.
AlicenseBqualityCmaintenanceExposes Databricks REST APIs as MCP tools for managing and querying a Databricks workspace, including clusters, jobs, SQL, Unity Catalog, and more.Last updated100MITWhy this server?
Generates dbt-fabric project file contents for a Fabric Data Warehouse, enabling data transformation workflows with dbt.
AlicenseBqualityBmaintenanceCLI and MCP server for administering Microsoft Fabric Data Warehouses and SQL Analytics Endpoints.Last updated1007MITWhy this server?
Provides tools for compiling, previewing, and validating dbt transformations, as well as listing and triggering dbt runs and managing dbt orchestration pipelines.
AlicenseAqualityBmaintenanceRead-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.Last updated25AGPL 3.0Why this server?
Works with dbt to automatically profile and monitor data models after runs.
Why this server?
Integrates with dbt for data transformation, lineage, and understanding of data pipeline changes.
AlicenseAqualityBmaintenanceglama.json already carries one, so this may prefillLast updated6575AGPL 3.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.Last updated1414MIT