dbt MCP

dbt-mcp

The official MCP server from dbt Labs: the Semantic Layer, project metadata, dbt commands and SQL against the warehouse from an agent

  • 608 ★ on the repository
  • Last commit
  • Apache-2.0
MCP serverOfficial

Extended access

Why this level

  • Warehouse queries and dbt runs go under your token
  • Some tools need the dbt platform
All reasons and checks

dbt-labs/dbt-mcp

Install

Manual install

Text for your agent

Open the dbt MCP documentation, connect the dbt-mcp package server and set DBT_HOST, DBT_TOKEN and DBT_PROD_ENV_ID. Ask the owner what rights the token has and start with a test environment.

Access and checks

How we review

Extended accessThe tool runs code or makes network calls and only reads external data.

  • Warehouse queries and dbt runs go under your token
  • Some tools need the dbt platform

This is third-party code. Review the repository files before installing.

What it does

dbt MCP gives an agent access to a dbt project: Semantic Layer queries, model and source metadata, dbt commands and SQL execution. Text to SQL runs on the dbt platform (`text_to_sql`). The package is named `dbt-mcp`, the README has no install command and it is described in the dbt documentation. Setup uses the variables `DBT_HOST`, `DBT_TOKEN`, `DBT_PROD_ENV_ID`, `DBT_PROJECT_DIR` and `DBT_PATH`. For clients with package support, an experimental `dbt-mcp.mcpb` file sits in the releases. Version 2.5.0, Apache-2.0 license.

Who it is for. For analysts and data engineers who work with dbt and want to ask questions about metrics and models from an agent.

Good fit when

  • You need to ask an agent for metrics from the Semantic Layer
  • You need metadata of dbt project models and sources
  • You need to run dbt commands and SQL from a chat

Not a fit when

  • You need a server with no dbt token: some tools work only with the dbt platform
  • You cannot let an agent query the production warehouse

Example request

Show revenue by month from the Semantic Layer and name the dbt models it depends on

MCP

Transport
stdio
Authentication
API key

Limitations

The agent runs warehouse queries and dbt under your token, so access is extended. Issue a token with minimal rights and start with a test environment. See the dbt documentation for launch commands: the README has none. The MCPB file for package-aware clients is experimental.

How to disable. Remove the server entry from the client settings and revoke the dbt token in your account.

FAQ

What does dbt MCP do?

It gives an agent access to the Semantic Layer, dbt project metadata, dbt commands and SQL against the warehouse.

How do I install it?

The README has no command and the procedure is in the dbt documentation. The package is named dbt-mcp and setup uses environment variables.

Is it an official server?

Yes, the repository belongs to the dbt Labs organization.

Discussion

No questions or reviews yet.

Official

Official Apache IoTDB MCP server: SQL over time series in tree and table models, with CSV and Excel export

MCP serverBroad access39Repository stars
Official

YDB's own official MCP server from the database's developers: parameterized SQL queries, execution plans, directory browsing, and a base for custom servers

MCP serverBroad access29Repository stars

DB MCP Server

db-mcp-server

An MCP server for several databases with protection: a read-only mode per database and a row limit. Written in Go, launched in Docker

MCP serverBroad access461Repository stars

A context layer for data agents: semantic layer, company wiki and MCP so the agent writes correct warehouse queries

CLIExtended access1.6KRepository stars

A Python MCP server for MySQL: listing tables, reading data, running SQL and inspecting schema through a controlled interface

MCP serverBroad access1.4KRepository stars
Official

Official MongoDB MCP server: queries and aggregations, index management, Atlas clusters and local deployments

MCP serverBroad access1.1KRepository stars

Comparison with similar tools

Entries that share the main search query, and how they differ.

EntryOfficialAuthenticationRepository starsMain difference
dbt MCP (this entry)yesAPI key608
DB MCP ServernoAPI key461several databases with a read_only mode per database
ArcticDB MCPnonot required775the ArcticDB time series store
dbt Chartsyes563dashboards as YAML on top of SQL, beta

README in short

The README describes an MCP server for dbt projects with Semantic Layer, metadata, dbt command and SQL tools and points to the dbt documentation for installation. Apache-2.0 license.

README badge

Report a problem

Foxx AIdbt MCP
Foxx AI

I am Foxx AI and I have already vetted this tool. Ask about install, setup or anything else, and I will keep it simple.