dbt MCP Server
Official MCP server from dbt Labs that bridges AI agents with dbt projects. Provides tools for SQL execution, natural language to SQL conversion, semantic layer querying, project discovery (models, macros, sources, lineage), CLI operations (build, test, compile), dbt Cloud admin API access, and YAML/SQL code generation for dbt models.
Score Breakdown
⚙ Agent Friendliness
🔒 Security
dbt Cloud MCP. Service tokens with project-level scopes. Data warehouse credentials in profiles.yml — use secrets manager. Admin tokens can trigger production runs.
⚡ Reliability
Best When
You have an existing dbt project (Core or Cloud) and want AI agents to explore, query, build, and generate code within the dbt ecosystem.
Avoid When
You don't use dbt, or you need general-purpose database access unrelated to dbt projects.
Use Cases
- • Natural language querying of dbt-managed data warehouses
- • Exploring dbt project structure, lineage, and health from AI tools
- • Generating dbt model YAML and staging SQL via AI
- • Running dbt builds, tests, and compilation through AI agents
- • Semantic layer metric querying and discovery
- • Cross-project resource search in dbt Platform environments
Not For
- • General database access without dbt (use dbhub or db-mcp-server instead)
- • Non-dbt data transformation workflows
- • Production job orchestration (use dbt Cloud scheduler for that)
Interface
Authentication
dbt Platform features require dbt Cloud credentials and API tokens. Local dbt Core features use local project config. Admin API access requires separate API keys.
Pricing
Apache-2.0 license. The MCP server is free but dbt Cloud features require a dbt Cloud account (which has its own pricing tiers).
Agent Metadata
Known Gotchas
- ⚠ Feature availability depends on whether using dbt Core, Fusion, or Cloud - agents may call unavailable tools
- ⚠ MCPB distribution format requires MCPB-aware clients for zero-config setup
- ⚠ text_to_sql quality depends heavily on project context and model documentation
- ⚠ Cross-project search is alpha-stage and may be unreliable
- ⚠ Admin API operations (job triggers) have real side effects in production
Alternatives
Full Evaluation Report
Comprehensive deep-dive: security analysis, reliability audit, agent experience review, cost modeling, competitive positioning, and improvement roadmap for dbt MCP Server.
AI-powered analysis · PDF + markdown · Delivered within 30 minutes
Package Brief
Quick verdict, integration guide, cost projections, gotchas with workarounds, and alternatives comparison.
Delivered within 10 minutes
Score Monitoring
Get alerted when this package's AF, security, or reliability scores change significantly. Stay ahead of regressions.
Continuous monitoring
Scores are editorial opinions as of 2026-03-07.