# Dbt MCP (MCP server)

> Dbt MCP is an MCP server that adds data and analytics tools to AI assistants such as Claude Desktop, Claude Code and Cursor. A MCP (Model Context Protocol) server for interacting with dbt. It has 607 GitHub stars, is released under the Apache-2.0 license and runs locally with uvx dbt-mcp.

This MCP (Model Context Protocol) server provides various tools to interact with dbt. You can use this MCP server to provide AI agents with context of your project in dbt Core, dbt Fusion, and dbt Platform.

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/dbt-labs/dbt-mcp |
| GitHub stars | 607 |
| License | Apache-2.0 |
| Language | Python |
| Transport | stdio |
| Packages | pypi: dbt-mcp |
| Remote URL | none |
| Needs API key | no |
| Official | yes |
| Works with | Claude Desktop, Claude Code, Cursor, VS Code |
| Category | Data & analytics |
| Latest release | v2.6.0 (Oct 6, 2026) |
| Last commit | Oct 6, 2026 |

## Install

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "dbt-mcp": {
      "command": "uvx",
      "args": [
        "dbt-mcp"
      ]
    }
  }
}
```

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

### Claude Code

```sh
claude mcp add --transport stdio dbt-mcp -- uvx dbt-mcp
```

### Cursor (.cursor/mcp.json)

```json
{
  "mcpServers": {
    "dbt-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "dbt-mcp"
      ]
    }
  }
}
```

Project file; use ~/.cursor/mcp.json to enable it in every project.

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "dbt-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "dbt-mcp"
      ]
    }
  }
}
```

Config formats checked against the official docs on 2026-10-07.

## Tools

- `execute_sql`: Executes SQL on dbt Platform infrastructure with Semantic Layer support.
- `text_to_sql`: Generates SQL from natural language using project context.
- `get_dimension_values`: Gets distinct values for a dimension; option to scope to specific metrics.
- `get_dimensions`: Gets dimensions for specified metrics.
- `get_entities`: Gets entities for specified metrics.
- `get_metrics_compiled_sql`: Returns compiled SQL for metrics without executing the query.
- `list_metrics`: Retrieves all defined metrics.
- `list_saved_queries`: Retrieves all saved queries.
- `query_metrics`: Executes metric queries with filtering and grouping options.
- `get_all_macros`: Retrieves macros; option to filter by package or return package names only.
- `get_all_models`: Retrieves name and description of all models.
- `get_all_sources`: Gets all sources with freshness status; option to filter by source name.
- `get_exposure_details`: (deprecated — use getnodedetails instead)*
- `get_exposures`: Gets all exposures (downstream dashboards, apps, or analyses).
- `get_lineage`: Gets a bounded lineage graph with type, depth, and direction filtering.
- `get_macro_details`: (deprecated — use getnodedetails instead)*
- `get_mart_models`: Retrieves all mart models.
- `get_model_children`: (deprecated — use getlineage instead)*
- `get_model_details`: (deprecated — use getnodedetails instead)*
- `get_model_health`: Gets health signals: run status, test results, and upstream source freshness.
- `get_model_parents`: (deprecated — use getlineage instead)*
- `get_model_performance`: Gets execution history for a model; option to include test results.
- `get_node_details`: Gets full details for any dbt resource type (model, source, exposure, test, seed, snapshot, macro, semantic_model).
- `get_related_models`: Finds similar models using semantic search.
- `get_seed_details`: (deprecated — use getnodedetails instead)*
- `get_semantic_model_details`: (deprecated — use getnodedetails instead)*
- `get_snapshot_details`: (deprecated — use getnodedetails instead)*
- `get_source_details`: (deprecated — use getnodedetails instead)*
- `get_test_details`: (deprecated — use getnodedetails instead)*
- `search`: [Alpha] Searches for resources across the dbt project (not generally available).
- `build`: Executes models, tests, snapshots, and seeds in DAG order.
- `clone`: Clones selected nodes from the specified state to the target schema(s).
- `compile`: Generates executable SQL from models/tests/analyses; useful for validating Jinja logic.
- `docs`: Generates documentation for the dbt project.
- `get_lineage_dev`: Retrieves lineage from local manifest.json with type and depth filtering.
- `get_node_details_dev`: Retrieves node details from local manifest.json (models, seeds, snapshots, sources).
- `list`: Lists resources in the dbt project by type with selector support.
- `parse`: Parses and validates project files for syntax correctness.
- `show`: Executes SQL against the database and returns results.
- `test`: Runs tests to validate data and model integrity.

## Similar MCP servers

- [Ida Pro MCP](https://appsgit.com/mcp-servers/ida-pro-mcp): AI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP. (12,497 stars, MIT)
- [Ask Jev](https://appsgit.com/mcp-servers/ask-jev): Evaluate state with typed choice, score, and probability questions. (5,174 stars, MIT, needs API key)
- [Jitsu](https://appsgit.com/mcp-servers/jitsu): Manage Jitsu data pipelines: destinations, streams, connections, functions, live events. (5,101 stars, MIT, official)
- [Google Ads + Meta Ads + SEO/GEO MCP](https://appsgit.com/mcp-servers/google-ads-meta-ads-seo-geo-mcp): Google Ads, Meta Ads, SEO, GEO & GA4 MCP by Ryze AI - audits, reports, keywords, Search Console. (4,107 stars, MIT)
- [Blitz](https://appsgit.com/mcp-servers/blitz): Give AI agents full control over iOS/macOS development via a native macOS app with 30+ MCP tools. (1,754 stars, Apache-2.0)
- [Chunkhound](https://appsgit.com/mcp-servers/chunkhound): Your entire engineering context, deeply understood. (1,445 stars, MIT, official)

---

Canonical page: https://appsgit.com/mcp-servers/dbt-mcp
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.