Claude MarketplacesSubmit

Dbt

us-all/dbt-mcp-server

Gives Claude read-only access to your dbt project's generated artifacts: manifest.json, run_results.json, sources.json, and catalog.json. Exposes 27 tools across three categories to query model metadata, test results, source freshness, lineage, and column-level test coverage. The quality category taps custom DQ result tables in BigQuery or Postgres to surface historical check trends and tier-based SLA rollups. Ships with four prompts for common triage workflows like investigating failed tests or diagnosing stale sources. Supports schema presets for generic and us-all table structures, with per-column overrides via environment variables. Deliberately excludes dbt run triggering; pair it with the companion Airflow MCP if you need orchestration control.

tools: 26
auth: Secret needed
transport: STDIO
env vars: 24
last updated: Jun 19, 2026

Tools

26 tools

Public tool metadata for what this MCP can expose to an agent.

dbt-list-models

No parameter schema in public metadata yet.

dbt-get-model

No parameter schema in public metadata yet.

dbt-list-tests

No parameter schema in public metadata yet.

dbt-get-test

No parameter schema in public metadata yet.

dbt-list-sources

No parameter schema in public metadata yet.

dbt-get-source

No parameter schema in public metadata yet.

dbt-list-exposures

No parameter schema in public metadata yet.

dbt-list-macros

No parameter schema in public metadata yet.

dbt-get-macro

No parameter schema in public metadata yet.

dbt-list-runs

No parameter schema in public metadata yet.

dbt-get-run-results

No parameter schema in public metadata yet.

dbt-failed-tests

No parameter schema in public metadata yet.

dbt-slow-models

No parameter schema in public metadata yet.

dbt-coverage

No parameter schema in public metadata yet.

dbt-graph

No parameter schema in public metadata yet.

freshness-status

No parameter schema in public metadata yet.

incident-context

No parameter schema in public metadata yet.

dbt-sla-status

No parameter schema in public metadata yet.

dq-list-checks

No parameter schema in public metadata yet.

dq-get-check-history

No parameter schema in public metadata yet.

dq-failed-checks-by-dataset

No parameter schema in public metadata yet.

dq-score-trend

No parameter schema in public metadata yet.

dq-tier-status

No parameter schema in public metadata yet.

dq-tier-by-source

No parameter schema in public metadata yet.

failed-tests-summary

No parameter schema in public metadata yet.

dq-score-snapshot

No parameter schema in public metadata yet.

Sponsors

Promote your product hereReach 125k+ visitors monthly Promote your product hereReach 125k+ visitors monthly

Agent CaffeineSponsoredClose your lid, come back to finished work

SnugSponsoredThe clipboard manager for the AI era Promote your product hereReach 125k+ visitors monthly

WaxSponsoredBlock anything with supervision, without erasing your iPhone Promote your product hereReach 125k+ visitors monthly

knobsSponsoredSee your site on any phone, any day, in any language

Configuration

DBT_PROJECT_DIR*

Path to dbt project root (where dbt_project.yml lives).

DBT_TARGET_DIR

dbt target dir for manifest.json/run_results.json (default: $DBT_PROJECT_DIR/target).

DBT_RUN_HISTORY_DIR

Optional dir for archived run_results.json history (glob-scanned).

DQ_BACKEND

DQ result table backend: 'bigquery' (default) or 'postgres'.

DQ_RESULTS_TABLE

Fully qualified DQ checks table, e.g. 'project.data_ops.quality_checks'.

DQ_SCORE_TABLE

Fully qualified DQ score-daily table, e.g. 'project.data_ops.quality_score_daily'.

GOOGLE_APPLICATION_CREDENTIALS

Service account key path for BigQuery (ADC fallback supported).

BQ_PROJECT_ID

Explicit BigQuery project ID for DQ queries.

PG_CONNECTION_STRINGsecret

Postgres connection string when DQ_BACKEND=postgres.

DBT_ALLOW_WRITEdefault: false

Reserved for future write tools. Default read-only.

DQ_SCHEMAdefault: generic

DQ result-table schema preset: 'generic' (default) or 'us-all'. Use DQ_COL_* env vars to override individual columns on top of the preset.

DQ_COL_RUN_AT

Override for the timestamp/date column on the DQ checks table. Default depends on DQ_SCHEMA preset.

DQ_COL_CHECK_TYPE

Override for the check-type column on the DQ checks table. Default 'check_type'.

DQ_COL_STATUS

Override for the status column on the DQ checks table. Default 'status'.

DQ_COL_DATASET

Override for the dataset/source column on the DQ checks table. Default depends on preset.

DQ_COL_TABLE_NAME

Override for the table/target-name column on the DQ checks table. Default depends on preset.

DQ_COL_SEVERITY

Override for the severity/dimension column on the DQ checks table. Default depends on preset.

DQ_COL_FAILURE_COUNT

Override for the numeric failure-count column on the DQ checks table. Default depends on preset.

DQ_COL_MESSAGE

Override for the message column on the DQ checks table. Default depends on preset.

DQ_COL_CHECK_NAME

Override for the check_name column on the DQ checks table. Set to 'none'/'null'/'-' to synthesize check_name from check_type and table_name.

DQ_COL_SCORE_DATE

Override for the date column on the DQ score-daily table. Default depends on preset.

DQ_COL_SCOPE

Override for the scope column on the DQ score-daily table. Set to 'none'/'null'/'-' if the table has no per-scope rollup.

DQ_COL_TIER

Override for the tier column on the DQ score-daily table. Set to 'none'/'null'/'-' if the table has no tier dimension.

DQ_TIER1_TARGET_PCT

When no tier column is configured (us-all preset or DQ_COL_TIER=none), the overall_score threshold dq-tier-status compares against (default 99.5). Superseded by DBT_SLA_CONFIG_PATH tier_sla.1 if both are set.

Readme

@us-all/dbt-mcp

dbt MCP server — manifest.json, run_results.json, sources.json, catalog.json, plus DQ result tables (BigQuery / Postgres) behind one stdio MCP. Built on @us-all/mcp-toolkit.

A read-only window into your dbt project for LLM clients. No dbt run triggering — just deep introspection, run-history analysis, source freshness, per-column test coverage, lineage walks, and (if you have a custom DQ result table) historical check trends and Tier SLA status.

For DAG triggering / run history / log tails, install the companion @us-all/airflow-mcp alongside.

27 tools across 3 categories (dbt, quality, meta) — 21 primitive tools + 5 aggregations + 1 meta
4 MCP Prompts for triage workflows
5 aggregation tools that replace 3-5 round-trips of "list / get / list"
extractFields response projection on high-volume reads
Read-only by default
Hybrid backend: BigQuery (default) or Postgres for DQ result tables — both peer-imported lazily

Install

View the full README on GitHub

Details

Repository: github.com/us-all/dbt-mcp-server
Categories: Databases, Data & Analytics
Package: @us-all/dbt-mcp
Transport: STDIO
Auth: Required
Registry: MCP registry, active

More from us-all

Related Databases MCP servers

1

Memory MCP Serverj0hanz/memory-mcpSQLite-backed MCP server for persistent memory, full-text retrieval, and graph traversal.0stars

2

Arm Code Mcpjean-johnson-zwix/arm-code-mcpMCP server for Arm64 Linux performance: parse perf output, suggest NEON intrinsics, audit deps.0stars

3

Kibana Mcpmshegolev/kibana-mcpKibana/Elasticsearch MCP — log search, aggregations, index discovery, dashboards.0stars

4

Junglescout Mcppurahmanian/junglescout-mcpJungle Scout MCP server: keyword volumes, product database, sales estimates, share of voice0stars

5

GrindFree Agent Securityronin93/grindfree-agent-securityPay-per-call agent security (x402): injection, tools, shell/SQL, memory, leaks, docs, safe web reads0stars

6

Toolssite.jiebang.www/tools20 free dev tools: JSON/YAML, XML/SQL, Cron, SEO, QR code, URL shortener, cron tasks, files0stars