dbt Core MCP Server

Name: dbt Core MCP Server Review
Item: dbt Core MCP Server
Rating: 2.8
Author: Aaron Matthews

Connector Data & Analytics Usable

Works inClaude Code Claude Cowork Claude Chat

Usable Scanned — metadata only

Enables AI pair programming for dbt developers across Snowflake, BigQuery, Databricks, Redshift, and PostgreSQL.

MCP server for dbt projects enabling AI to query project metadata, execute SQL with Jinja templating, analyze lineage, trace column-level dependencies, and run dbt commands. Adapter-agnostic.

Analyze data model lineage and trace column dependencies
Run data transformation commands from your coding environment
Query project metadata and explore model relationships directly

15 starsMIT (commercial OK)FreeNo code needed

Usable rating — This tool is functional but has notable gaps. Review the evaluation notes below before deploying.

Why it matters

Enables AI pair programming for dbt developers across Snowflake, BigQuery, Databricks, Redshift, and PostgreSQL. 181 commits shows sustained community maintenance.

Best for

Data engineering consulting engagements where the client uses dbt and wants AI to assist with model development, lineage analysis, and dependency tracing.

Works in

Claude Code Claude Cowork Claude Chat

Source

https://github.com/NiclasOlofsson/dbt-core-mcp

By NiclasOlofsson

How to Get It

Option 1: Claude Desktop AppOpen the Customize panel in the sidebar → browse connectors → search and add. Works in Claude Code, Claude Cowork, and Claude Chat.

Option 2: Paste into Claude CodeCopy the command below and paste it into a Claude Code conversation. Claude will run it for you.

Command

uvx dbt-core-mcp

Tip: Paste this into a Claude Code conversation. Verify command matches your Claude Code version.

First thing to try

Once it’s connected, paste this into Claude:

Help me analyze data model lineage and trace column dependencies

PrerequisitesPython 3.9+ and uv (or pipx). A dbt Core 1.9.0+ project with your adapter (dbt-duckdb, dbt-postgres, dbt-snowflake, dbt-databricks, etc.) installed in your own environment — the server detects and uses YOUR dbt installation via bridge execution.CostFree

Trust Signals Auto-scanned

Stars15Contributors2Last updated2026-04-27LicenseMIT (OK for commercial use)Known CVEsNone foundSources: GitHub Advisory Database + OSV.dev · Scanned 2026-08-18 · scanner v1

Data & Access

Data processingPrompts sent to Anthropic API. Enterprise/Team plans exclude training.

Community Pulse Growing

Discussed on Reddit

[AMA] We’re dbt Labs, ask us anything! — Reddit · 139 pts
I built an open source tool to replace standard dbt docs — Reddit · 77 pts
I built an open source tool to replace standard dbt docs — Reddit · 17 pts

3 mentions across 1 sources

Reviewer notes

Auto-scanned review. These are observations, not a security certification.

catalog_hygiene stale-eval refresh: Scored from trust signals (evidence-eval-v1): 15 GitHub stars; 2 contributors; last commit 113d ago; license MIT.

Things to check

Python models are not supported — only SQL-based dbt models. Requires dbt Core 1.9.0 or higher. Needs a local or accessible dbt project with database credentials configured in dbt profiles; large projects and lineage graphs slow analysis.

How to evaluate tools before deploying →

Data shown here comes from public APIs and automated scanning. Reviewer notes reflect one person's experience. This is not a security certification or legal recommendation. Always evaluate tools according to your own organization's policies.

Evaluation Scores

Evaluation

Ease of Use

3/5

Versatility

2/5

Reliability

3/5

Security

3/5

Overall score2.75 / 5.00 UsableEvaluatedAug 2026

catalog_hygiene stale-eval refresh: Scored from trust signals (evidence-eval-v1): 15 GitHub stars; 2 contributors; last commit 113d ago; license MIT.

← Back to the Claude Observatory