Data and BI - official dbt Labs server
dbt MCP server
MCP server that gives AI clients access to dbt project metadata, the Semantic Layer, Discovery and Admin APIs, SQL execution and text-to-SQL, plus dbt CLI commands when self-hosted. Available as a self-hosted Python package (uvx dbt-mcp) or a remote server hosted on the dbt platform. It is served from your own instance at https://YOUR_DBT_HOST_URL/api/ai/v1/mcp/ with OAuth or API key auth.
Last verified 15 tools7 sources
Install
Claude Code
About Claude Codeclaude mcp add --transport http dbt https://YOUR_DBT_HOST_URL/api/ai/v1/mcp/Cursor
About Cursor{
"mcpServers": {
"dbt": {
"url": "https://YOUR_DBT_HOST_URL/api/ai/v1/mcp/"
}
}
}VS Code
{
"servers": {
"dbt": {
"type": "http",
"url": "https://YOUR_DBT_HOST_URL/api/ai/v1/mcp/"
}
}
}Generic
{
"mcpServers": {
"dbt": {
"command": "uvx",
"args": ["dbt-mcp"],
"env": {
"DBT_HOST": "YOUR-ACCESS-URL"
}
}
}
}Tools
execute_sql- Executes SQL on dbt Platform infrastructure with Semantic Layer support.
text_to_sql- Generates SQL from natural language using project context.
list_metrics- Retrieves all defined metrics.
query_metrics- Executes metric queries with filtering and grouping options.
get_dimensions- Gets dimensions for specified metrics.
get_all_models- Retrieves name and description of all models.
get_lineage- Gets a bounded lineage graph with type, depth and direction filtering.
get_node_details- Gets full details for any dbt resource type.
get_model_health- Gets health signals: run status, test results and upstream source freshness.
build- Executes models, tests, snapshots and seeds in DAG order.
run- Executes models to materialize them in the database.
test- Runs tests to validate data and model integrity.
compile- Generates executable SQL from models, tests and analyses.
trigger_job_run- Triggers a dbt Platform job run, with optional overrides.
get_job_run_error- Gets error and warning details for a job run.
As documented on October 17, 2026. A running server reports its current list through tools/list.
Notes and caveats
- Remote URL is account-specific: copy it from Account settings > Access URLs > MCP Endpoint URL (for example https://cloud.getdbt.com/api/ai/v1/mcp/).
- Remote OAuth is in public beta for Starter, Enterprise and Enterprise+ accounts and needs a static subdomain; token auth on remote needs a token with Developer permission (service tokens with that set only on Enterprise plans), and execute_sql requires a PAT.
- Remote server does not support dbt CLI commands or Codegen; tool availability depends on plan.
- Snippets shown are the remote OAuth configs; the generic snippet is the self-hosted uvx config (OAuth via dbt platform).
- Codex is not documented (docs say to consult the client's docs).
- An experimental .mcpb bundle ships with each release.
- Latest changelog entry v2.8.0 dated 2026-10-12.
More MCP servers for data and BI
- AdobeStatus: Beta
Adobe Real-Time CDP MCP server
Adobe-hosted MCP server for querying Real-Time CDP audiences, audience evaluation and export jobs, destinations, sources and flow run history in natural language.
Transport: Streamable HTTPAuth: OAuth - Airbyte
Airbyte Agent MCP server
Hosted MCP server for Airbyte Agents that gives AI agents authenticated read and write access to business apps such as CRMs, support desks and billing tools through Airbyte agent connectors.
Transport: Streamable HTTPAuth: OAuth - AirbyteStatus: Beta
Airbyte MCP server
Hosted MCP server that connects AI agents to an Airbyte Cloud organization to build, monitor and troubleshoot data pipelines, and (with the context layer enabled) read live data directly from supported sources and destinations. A local version runs against self-managed Airbyte Core via the PyAirbyte package.
Transport: Streamable HTTP, stdioAuth: OAuth or API key - AtlanStatus: GA
Atlan MCP server
Hosted MCP server that lets AI clients search the Atlan catalog, traverse lineage, read and update governed metadata, glossaries and data quality rules, and run read-only SQL against connected warehouses. Calls run with the signed-in user's Atlan permissions.
Transport: Streamable HTTPAuth: OAuth or API key - DatabricksStatus: GA
Genie One MCP server
A Databricks-provided MCP (system.ai.genie_one_mcp) governed through Unity Gateway that sends natural-language data questions to Genie One, which writes SQL and returns answers grounded in Genie Ontology with links back to Databricks sources. Unity Catalog permissions are enforced on every request.
Transport: Streamable HTTPAuth: OAuth or API key - ElasticStatus: GA
Elastic Agent Builder MCP server
MCP endpoint built into Kibana that exposes Elastic Agent Builder's built-in and custom tools to outside MCP hosts, for example running ES|QL queries, searching indices or querying observability and security data. It replaces the standalone Elasticsearch MCP Server.
Transport: Streamable HTTPAuth: OAuth or API key
Related reading
- Claude Code MCP Tasks: Long-Running Tools That Ask You ThingsClaude Code supports MCP Tasks and elicitations. What a tool call needs to become a task, what v2.1.319 changed for Bedrock and gateways, and what server authors change.
- Claude Security Continuous Scanning: Fix Tracking, API and MCPClaude Security now rescans repos as commits land, marks findings fixed when the fix ships, and adds an API, MCP connector and webhooks. Setup, limits and cost.
- MCP Client Features: Sampling, Elicitation and Roots ExplainedMCP sampling, elicitation and roots explained against the 2026-07-28 spec, with JSON-RPC examples and which of 24 clients support each one.
- REA vs leanrea: Skill or MCP for Reverse Engineering Agents?leanrea is an 8 KB skill pitched as a replacement for the REA (Reverse Engineer Anything) MCP server. What its benchmark shows, what it skips, and which to install.
- How to Publish a Plugin to the Claude Directory (Developer Portal Guide)Submit a plugin to the Claude directory: validate it, clear the security scan, publish, and read 90 days of usage analytics. Needs a paid plan.
- ChatGPT Plugin Extensions: Sidebar Apps, Panels and File EditorsChatGPT plugins can now add sidebar apps, side panels, file editors and native forms. How openai/ui entrypoints work, with type-checked code.
FAQ
What does the dbt MCP server do?
MCP server that gives AI clients access to dbt project metadata, the Semantic Layer, Discovery and Admin APIs, SQL execution and text-to-SQL, plus dbt CLI commands when self-hosted. Available as a self-hosted Python package (uvx dbt-mcp) or a remote server hosted on the dbt platform. The vendor documents 15 tools, including execute_sql, text_to_sql, list_metrics and query_metrics.
How do I add the dbt MCP server to Claude Code?
Run claude mcp add --transport http dbt https://YOUR_DBT_HOST_URL/api/ai/v1/mcp/, copied from dbt Labs's docs. This page also has snippets for Cursor, VS Code and Generic.
Does the dbt MCP server need authentication?
Yes, OAuth or API key. Transport: Streamable HTTP, stdio. Status: GA, last checked October 17, 2026.
Sources
Last verified against 7 dbt Labs pages, then re-checked independently.
- docs.getdbt.comhttps://docs.getdbt.com/docs/dbt-ai/about-mcp
- docs.getdbt.comhttps://docs.getdbt.com/docs/dbt-ai/setup-remote-mcp.md
- docs.getdbt.comhttps://docs.getdbt.com/docs/dbt-ai/integrate-mcp-claude.md
- docs.getdbt.comhttps://docs.getdbt.com/docs/dbt-ai/integrate-mcp-vscode.md
- raw.githubusercontent.comhttps://raw.githubusercontent.com/dbt-labs/dbt-mcp/main/README.md
- raw.githubusercontent.comhttps://raw.githubusercontent.com/dbt-labs/dbt-mcp/main/CHANGELOG.md
- raw.githubusercontent.comhttps://raw.githubusercontent.com/dbt-labs/dbt-mcp/main/LICENSE
Newsletter
New MCP servers, the week they ship
One email per week. New official MCP servers, the coding tools that support them and how developers wire them up.