dbt-labs/dbt-mcp

Overview

dbt-mcp is a Model Context Protocol server that enables AI assistants to interact with dbt projects. It exposes dbt commands and metadata through a standardized interface, allowing tools like Claude or Copilot to run dbt operations, inspect models, and retrieve project information.

Best for

Best for
Data engineers and analysts who want to control dbt workflows from AI assistants without leaving their chat interface.

Use cases

• Run dbt run, test, or build commands from an AI chat interface
• Query dbt project metadata like model dependencies and freshness
• Automate dbt workflows by integrating with AI-powered development tools

How to use

Tools exposed

• execute_sql
• text_to_sql
• get_dimension_values
• get_dimensions
• get_entities
• get_metrics_compiled_sql
• list_metrics
• list_saved_queries
• query_metrics
• 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

Tested with

Claude, Cursor

Notes

dbt-mcp is a Model Context Protocol server that enables AI assistants to interact with dbt projects. It exposes dbt commands and metadata through a standardized interface, allowing tools like Claude or Copilot to run dbt operations, inspect models, and retrieve project information.

574 stars on GitHub. Last updated 2026-06-01. Licensed Apache-2.0.

Use cases

• Run dbt run, test, or build commands from an AI chat interface
• Query dbt project metadata like model dependencies and freshness
• Automate dbt workflows by integrating with AI-powered development tools

Pros

• Official dbt Labs project with active maintenance and community support
• Standard MCP protocol enables compatibility with multiple AI assistants
• Reduces context switching by letting developers interact with dbt through natural language

Cons

• Requires a running MCP-compatible client, adding setup overhead
• Limited to dbt operations exposed by the server; not a full CLI replacement
• Dependency on Python and dbt environment may conflict with existing setups

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.