dbt MCP Server
Supports UIby dbt-labs
Connect AI agents to dbt Core, Fusion, and Platform for SQL execution, semantic layer queries, and lineage analysis.
What it does
The dbt MCP server allows AI agents to interact directly with dbt projects. It provides deep visibility into data models, semantic layers, and project lineage, enabling agents to generate SQL, query metrics, and manage dbt project health without manual intervention.
Tools
execute_sql: Runs SQL on dbt Platform infrastructure with Semantic Layer support.text_to_sql: Converts natural language to SQL using the project's context.query_metrics: Executes metric queries with filtering and grouping.get_lineage: Retrieves the full lineage graph of ancestors and descendants.get_model_details: Fetches compiled SQL, columns, and schema for a specific model.build: Executes models, tests, snapshots, and seeds in DAG order.run: Materializes models in the database.test: Validates data and model integrity.
Installation
Add the following to your claude_desktop_config.json:
{
"mcpServers": {
"dbt-mcp": {
"command": "npx",
"args": ["-y", "dbt-mcp"]
}
}
}
Supported hosts
- Claude Desktop
Quick install
npx -y dbt-mcpInformation
- Pricing
- free
- Published
- 4/16/2026
- stars






