dbt MCP
Official dbt Labs MCP server covering SQL execution, Semantic Layer queries, Discovery API, dbt CLI, Admin API, dbt Codegen, dbt LSP, and Product Docs. 41 commits on main in the last 30 days, joint top cadence in this batch.
“Official dbt Labs MCP server covering SQL execution, Semantic Layer queries, Discovery API, dbt CLI, Admin API, dbt Codegen, dbt LSP, and Product Docs. 41 commits on main in the last 30 days, joint top cadence in this batch with Azure DevOps and Canvas LMS.”
INSTALL THIS SERVER
{
"mcpServers": {
"dbt": {
"command": "uvx",
"args": [
"dbt-mcp"
],
"env": {
"DBT_CLOUD_API_TOKEN": "<your-dbt-cloud-token>",
"DBT_CLOUD_ACCOUNT_ID": "<your-account-id>",
"DBT_PROJECT_DIR": "/path/to/dbt/project"
}
}
}
}
{
"mcpServers": {
"dbt": {
"command": "uvx",
"args": [
"dbt-mcp"
],
"env": {
"DBT_CLOUD_API_TOKEN": "<your-dbt-cloud-token>",
"DBT_CLOUD_ACCOUNT_ID": "<your-account-id>",
"DBT_PROJECT_DIR": "/path/to/dbt/project"
}
}
}
}
{
"mcpServers": {
"dbt": {
"command": "uvx",
"args": [
"dbt-mcp"
],
"env": {
"DBT_CLOUD_API_TOKEN": "<your-dbt-cloud-token>",
"DBT_CLOUD_ACCOUNT_ID": "<your-account-id>",
"DBT_PROJECT_DIR": "/path/to/dbt/project"
}
}
}
}
{
"mcpServers": {
"dbt": {
"command": "uvx",
"args": [
"dbt-mcp"
],
"env": {
"DBT_CLOUD_API_TOKEN": "<your-dbt-cloud-token>",
"DBT_CLOUD_ACCOUNT_ID": "<your-account-id>",
"DBT_PROJECT_DIR": "/path/to/dbt/project"
}
}
}
}
{
"mcpServers": {
"dbt": {
"command": "uvx",
"args": [
"dbt-mcp"
],
"env": {
"DBT_CLOUD_API_TOKEN": "<your-dbt-cloud-token>",
"DBT_CLOUD_ACCOUNT_ID": "<your-account-id>",
"DBT_PROJECT_DIR": "/path/to/dbt/project"
}
}
}
}
9 TOOLS AVAILABLE
OUR ASSESSMENT
- Official dbt Labs maintenance.
- 551 GitHub stars and Apache-2.0 licence.
- 41 commits on main in the last 30 days.
- Eight tool families cover the full dbt workflow: SQL, Semantic Layer, Discovery, CLI, Admin API, Codegen, LSP, Docs.
- Experimental MCP Bundle support flagged in the README for early-access features.
- Architecture documented in the README: clear separation between local dbt project tools and dbt Cloud Admin API.
- Setup complexity: requires a dbt project on disk plus optional dbt Cloud credentials for Admin API and Discovery surfaces.
- Semantic Layer and Discovery require dbt Cloud subscription; CLI and SQL work against any dbt project.
- The MCP Bundle feature is marked experimental; behaviour may evolve.
The MCP carries dbt Cloud API tokens (when configured) plus warehouse credentials from the dbt project profile. Scope dbt Cloud tokens to read-only when the agent does diagnostic work; the Admin API token grants full job management. The warehouse connection uses the credentials in the dbt project profile; for production agents, run the MCP under a dedicated read-only warehouse role.
Data teams using dbt for analytics engineering who want agents to execute SQL, query the Semantic Layer, inspect model lineage, and trigger dbt Cloud jobs from inside the editor; analytics engineers who want CLI run/test/build flows accessible from agent prompts; teams scaffolding new dbt models via Codegen.
TECHNICAL DETAILS
ADOPTION METRICS
// Reading this551 stars on the dbt-labs/dbt-mcp repo. 41 commits on main in the last 30 days, joint top cadence in this batch.
// Reading thisHighest-quality data MCP at time of review for analytics-engineering workflows.
SOURCES & VERIFICATION
We don't take any single directory's word for it. Before scoring, we cross-reference 5 public MCP sources, install the server ourselves against the clients we cover, and record when we last re-verified.
The same server, 5 different lenses. We reconcile these signals into our editorial score, which is why our number sometimes diverges from a directory-aggregate star count.
| Source | Their rating | Their star count | Their downloads | Last synced |
|---|---|---|---|---|
| AutomationSwitch This page | 4.5editorial | 551 | — | MAY 3, 2026 |
| PulseMCP | — unrated | unavailable | unavailable | MAY 3, 2026 |
| MCP.so | — unrated | unavailable | unavailable | MAY 3, 2026 |
| Glama | — unrated | unavailable | unavailable | MAY 3, 2026 |
| Smithery | — unrated | unavailable | unavailable | MAY 3, 2026 |
| Official MCP Registry | — unrated | unavailable | unavailable | MAY 3, 2026 |
// Counts are directory-reported; we don't adjust them. Discrepancies usually come from different snapshot times or star-caching.
OTHER DATA / ANALYTICS MCP SERVERS
Firecrawl
Web intelligence layer that turns any URL into LLM-optimised markdown. Handles JavaScript rendering, pagination, and structured extraction so your agent reads the live web instead of stale training data.
Apify Actors MCP
Apify Actors as MCP tools: 6,000+ web scrapers, automation actors, and AI agents callable from Claude, Cursor, or any MCP client. Hosted streamable transport at https://mcp.apify.com plus stdio via npx. Dynamic actor discovery at runtime.
Bright Data MCP
Web data extraction over the Bright Data network with two operating modes: Rapid Mode (free, basic search and scrape) and Pro Mode (60+ structured-dataset tools targeting Amazon, LinkedIn, Walmart, Instagram, and more).
DISCUSS YOUR
MCP REQUIREMENTS.
Evaluating a server, scoping an internal deployment, or working out whether MCP is the right fit at all. Start the conversation and we will point you at the right piece of the ecosystem.