dbt MCP Server (Official)
Official dbt Labs MCP server for data transformation, semantic layer, and model discovery.
Installation
pip install dbt-mcp About this Tool
Official MCP server from dbt Labs exposing dbt Core/Cloud functionality. Run CLI commands, query the Semantic Layer, discover models, and execute SQL. 433+ GitHub stars. Essential for marketing analytics teams using dbt for data transformation and building reliable marketing dashboards from raw data.
Use Case Examples
- Query marketing semantic models using natural language
- Run dbt transformations to build campaign attribution models
- Discover and explore marketing data models in your dbt project
MarketCore Editorial Review
MarketCore Editorial Review
For marketing analysts running dbt on top of their data warehouse, this MCP server connects Claude directly to their transformation models. Marketing teams can query compiled dbt models — including attribution, campaign performance, and customer cohort tables — without writing SQL or waiting for analysts to run reports.
Best For
- Query dbt models for campaign attribution analysis in natural language without SQL
- Inspect model lineage to understand how marketing metrics are calculated and sourced
- Run and test dbt models for marketing data pipelines from Claude during development
Code Quality
Well-maintained official MCP server from the dbt Labs ecosystem. TypeScript implementation is clean and correctly handles dbt Cloud and Core configurations. Active community and good documentation.
Limitations
Requires dbt setup (Cloud or Core) — not appropriate for teams without existing dbt infrastructure. Limited to data already modeled in dbt; ad hoc data exploration requires dbt model development. Advanced users only.
Reviewed 2026-04-01
Related Tools
Snowflake MCP Server (Official)
Official Snowflake MCP server with Cortex AI, SQL orchestration, and semantic views.
BigQuery MCP Server
MCP server for querying and analyzing BigQuery datasets through AI assistants with secure read-only access.
Looker MCP Server
MCP server for querying Looker data with natural language using Google's Conversational Analytics API.
Compare dbt MCP Server (Official)
Score Breakdown
Overall Score
Based on 5 dimensions
Get weekly updates on new marketing AI tools
New tools reviewed every week. No spam.