Dbt MCP

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

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

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

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

Config formats checked against the official docs on Oct 7, 2026: modelcontextprotocol.io (opens in a new tab), code.claude.com (opens in a new tab), cursor.com (opens in a new tab), code.visualstudio.com (opens in a new tab).

• 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.

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.

• data-analytics
• data-engineering
• llm
• mcp
• mcp-server
• model-context-protocol
• dbt