dbt

Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.

GitHub

dbt MCP Server

OpenSSF Best Practices

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.

Read our documentation here to learn more. This blog post provides more details for what is possible with the dbt MCP server.

Experimental MCP Bundle

We publish an experimental Model Context Protocol Bundle (dbt-mcp.mcpb) with each release so that MCPB-aware clients can import this server without additional setup. Download the bundle from the latest release assets and follow Anthropic's mcpb CLI docs to install or inspect it.

Feedback

If you have comments or questions, create a GitHub Issue or join us in the community Slack in the #tools-dbt-mcp channel.

Architecture

The dbt MCP server architecture allows for your agent to connect to a variety of tools.

architecture diagram of the dbt MCP server

Tools

SQL

  • execute_sql
  • text_to_sql

Semantic Layer

  • get_dimensions
  • get_entities
  • get_metrics_compiled_sql
  • list_metrics
  • list_saved_queries
  • query_metrics

Discovery

  • get_all_macros
  • get_all_models
  • get_all_sources
  • get_exposure_details
  • get_exposures
  • get_lineage
  • get_macro_details
  • get_mart_models
  • get_model_children
  • get_model_details
  • get_model_health
  • get_model_parents
  • get_model_performance
  • get_related_models
  • get_seed_details
  • get_semantic_model_details
  • get_snapshot_details
  • get_source_details
  • get_test_details
  • search

dbt CLI

  • build
  • compile
  • docs
  • get_lineage_dev
  • get_node_details_dev
  • list
  • parse
  • run
  • show
  • test

Admin API

  • cancel_job_run
  • get_job_details
  • get_job_run_artifact
  • get_job_run_details
  • get_job_run_error
  • get_project_details
  • list_job_run_artifacts
  • list_jobs
  • list_jobs_runs
  • retry_job_run
  • trigger_job_run

dbt Codegen

  • generate_model_yaml
  • generate_source
  • generate_staging_model

dbt LSP

  • fusion.compile_sql
  • fusion.get_column_lineage
  • get_column_lineage

MCP Server Metadata

  • get_mcp_server_version

Examples

Commonly, you will connect the dbt MCP server to an agent product like Claude or Cursor. However, if you are interested in creating your own agent, check out the examples directory for how to get started.

Contributing

Read CONTRIBUTING.md for instructions on how to get involved!

Related Servers