dbt-mcpA MCP (Model Context Protocol) server for interacting with dbt.

— (0)

Reviewed by Daniel Nikulshyn·Updated July 2026

Overview

The dbt MCP (Model Context Protocol) server is a tool that provides various interfaces to interact with dbt, allowing AI agents to access context about a dbt project. It supports dbt Core, dbt Fusion, and dbt Platform. The server offers features such as executing SQL, generating SQL from natural language, and accessing semantic layer data. It also provides discovery APIs for retrieving information about dbt models, macros, sources, and exposures.

Key features

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
get_metrics_compiled_sql: Returns compiled SQL for metrics without executing the query
get_all_macros: Retrieves macros; option to filter by package or return package names only

Pricing

Model: Free
Category: MCP Servers
Rating: No reviews yet

Use cases

AI-powered data analysis

Use the dbt MCP server to provide AI agents with context about a dbt project, enabling them to perform data analysis and generate insights.

Automated SQL generation

Utilize the dbt MCP server's text_to_sql feature to generate SQL queries from natural language, streamlining data analysis and reducing manual effort.

Pros & Cons

Pros

Provides a standardized protocol for interacting with dbt projects
Supports various dbt platforms, including Core, Fusion, and Platform
Offers a range of tools for executing and generating SQL, as well as accessing semantic layer data