Dbt

io.github.us-all/dbt · v1.0.7

dbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres)

Source code Set it up

Connect Runs on your machine

Terminal

claude mcp add dbt -e DBT_PROJECT_DIR=<DBT_PROJECT_DIR> -e DBT_TARGET_DIR=<DBT_TARGET_DIR> -e DBT_RUN_HISTORY_DIR=<DBT_RUN_HISTORY_DIR> -e DQ_BACKEND=<DQ_BACKEND> -e DQ_RESULTS_TABLE=<DQ_RESULTS_TABLE> -e DQ_SCORE_TABLE=<DQ_SCORE_TABLE> -e GOOGLE_APPLICATION_CREDENTIALS=<GOOGLE_APPLICATION_CREDENTIALS> -e BQ_PROJECT_ID=<BQ_PROJECT_ID> -e PG_CONNECTION_STRING=<PG_CONNECTION_STRING> -e DBT_ALLOW_WRITE=<DBT_ALLOW_WRITE> -e DQ_SCHEMA=<DQ_SCHEMA> -e DQ_COL_RUN_AT=<DQ_COL_RUN_AT> -e DQ_COL_CHECK_TYPE=<DQ_COL_CHECK_TYPE> -e DQ_COL_STATUS=<DQ_COL_STATUS> -e DQ_COL_DATASET=<DQ_COL_DATASET> -e DQ_COL_TABLE_NAME=<DQ_COL_TABLE_NAME> -e DQ_COL_SEVERITY=<DQ_COL_SEVERITY> -e DQ_COL_FAILURE_COUNT=<DQ_COL_FAILURE_COUNT> -e DQ_COL_MESSAGE=<DQ_COL_MESSAGE> -e DQ_COL_CHECK_NAME=<DQ_COL_CHECK_NAME> -e DQ_COL_SCORE_DATE=<DQ_COL_SCORE_DATE> -e DQ_COL_SCOPE=<DQ_COL_SCOPE> -e DQ_COL_TIER=<DQ_COL_TIER> -e DQ_TIER1_TARGET_PCT=<DQ_TIER1_TARGET_PCT> -e DBT_SLA_CONFIG_PATH=<DBT_SLA_CONFIG_PATH> -e DBT_TOOLS=<DBT_TOOLS> -e DBT_DISABLE=<DBT_DISABLE> -- npx -y @us-all/[email protected]

claude_desktop_config.json

{
  "mcpServers": {
    "dbt": {
      "command": "npx",
      "args": [
        "-y",
        "@us-all/[email protected]"
      ],
      "env": {
        "DBT_PROJECT_DIR": "<DBT_PROJECT_DIR>",
        "DBT_TARGET_DIR": "<DBT_TARGET_DIR>",
        "DBT_RUN_HISTORY_DIR": "<DBT_RUN_HISTORY_DIR>",
        "DQ_BACKEND": "<DQ_BACKEND>",
        "DQ_RESULTS_TABLE": "<DQ_RESULTS_TABLE>",
        "DQ_SCORE_TABLE": "<DQ_SCORE_TABLE>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
        "BQ_PROJECT_ID": "<BQ_PROJECT_ID>",
        "PG_CONNECTION_STRING": "<PG_CONNECTION_STRING>",
        "DBT_ALLOW_WRITE": "<DBT_ALLOW_WRITE>",
        "DQ_SCHEMA": "<DQ_SCHEMA>",
        "DQ_COL_RUN_AT": "<DQ_COL_RUN_AT>",
        "DQ_COL_CHECK_TYPE": "<DQ_COL_CHECK_TYPE>",
        "DQ_COL_STATUS": "<DQ_COL_STATUS>",
        "DQ_COL_DATASET": "<DQ_COL_DATASET>",
        "DQ_COL_TABLE_NAME": "<DQ_COL_TABLE_NAME>",
        "DQ_COL_SEVERITY": "<DQ_COL_SEVERITY>",
        "DQ_COL_FAILURE_COUNT": "<DQ_COL_FAILURE_COUNT>",
        "DQ_COL_MESSAGE": "<DQ_COL_MESSAGE>",
        "DQ_COL_CHECK_NAME": "<DQ_COL_CHECK_NAME>",
        "DQ_COL_SCORE_DATE": "<DQ_COL_SCORE_DATE>",
        "DQ_COL_SCOPE": "<DQ_COL_SCOPE>",
        "DQ_COL_TIER": "<DQ_COL_TIER>",
        "DQ_TIER1_TARGET_PCT": "<DQ_TIER1_TARGET_PCT>",
        "DBT_SLA_CONFIG_PATH": "<DBT_SLA_CONFIG_PATH>",
        "DBT_TOOLS": "<DBT_TOOLS>",
        "DBT_DISABLE": "<DBT_DISABLE>"
      }
    }
  }
}

~/.cursor/mcp.json

{
  "mcpServers": {
    "dbt": {
      "command": "npx",
      "args": [
        "-y",
        "@us-all/[email protected]"
      ],
      "env": {
        "DBT_PROJECT_DIR": "<DBT_PROJECT_DIR>",
        "DBT_TARGET_DIR": "<DBT_TARGET_DIR>",
        "DBT_RUN_HISTORY_DIR": "<DBT_RUN_HISTORY_DIR>",
        "DQ_BACKEND": "<DQ_BACKEND>",
        "DQ_RESULTS_TABLE": "<DQ_RESULTS_TABLE>",
        "DQ_SCORE_TABLE": "<DQ_SCORE_TABLE>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
        "BQ_PROJECT_ID": "<BQ_PROJECT_ID>",
        "PG_CONNECTION_STRING": "<PG_CONNECTION_STRING>",
        "DBT_ALLOW_WRITE": "<DBT_ALLOW_WRITE>",
        "DQ_SCHEMA": "<DQ_SCHEMA>",
        "DQ_COL_RUN_AT": "<DQ_COL_RUN_AT>",
        "DQ_COL_CHECK_TYPE": "<DQ_COL_CHECK_TYPE>",
        "DQ_COL_STATUS": "<DQ_COL_STATUS>",
        "DQ_COL_DATASET": "<DQ_COL_DATASET>",
        "DQ_COL_TABLE_NAME": "<DQ_COL_TABLE_NAME>",
        "DQ_COL_SEVERITY": "<DQ_COL_SEVERITY>",
        "DQ_COL_FAILURE_COUNT": "<DQ_COL_FAILURE_COUNT>",
        "DQ_COL_MESSAGE": "<DQ_COL_MESSAGE>",
        "DQ_COL_CHECK_NAME": "<DQ_COL_CHECK_NAME>",
        "DQ_COL_SCORE_DATE": "<DQ_COL_SCORE_DATE>",
        "DQ_COL_SCOPE": "<DQ_COL_SCOPE>",
        "DQ_COL_TIER": "<DQ_COL_TIER>",
        "DQ_TIER1_TARGET_PCT": "<DQ_TIER1_TARGET_PCT>",
        "DBT_SLA_CONFIG_PATH": "<DBT_SLA_CONFIG_PATH>",
        "DBT_TOOLS": "<DBT_TOOLS>",
        "DBT_DISABLE": "<DBT_DISABLE>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "dbt": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@us-all/[email protected]"
      ],
      "env": {
        "DBT_PROJECT_DIR": "<DBT_PROJECT_DIR>",
        "DBT_TARGET_DIR": "<DBT_TARGET_DIR>",
        "DBT_RUN_HISTORY_DIR": "<DBT_RUN_HISTORY_DIR>",
        "DQ_BACKEND": "<DQ_BACKEND>",
        "DQ_RESULTS_TABLE": "<DQ_RESULTS_TABLE>",
        "DQ_SCORE_TABLE": "<DQ_SCORE_TABLE>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
        "BQ_PROJECT_ID": "<BQ_PROJECT_ID>",
        "PG_CONNECTION_STRING": "<PG_CONNECTION_STRING>",
        "DBT_ALLOW_WRITE": "<DBT_ALLOW_WRITE>",
        "DQ_SCHEMA": "<DQ_SCHEMA>",
        "DQ_COL_RUN_AT": "<DQ_COL_RUN_AT>",
        "DQ_COL_CHECK_TYPE": "<DQ_COL_CHECK_TYPE>",
        "DQ_COL_STATUS": "<DQ_COL_STATUS>",
        "DQ_COL_DATASET": "<DQ_COL_DATASET>",
        "DQ_COL_TABLE_NAME": "<DQ_COL_TABLE_NAME>",
        "DQ_COL_SEVERITY": "<DQ_COL_SEVERITY>",
        "DQ_COL_FAILURE_COUNT": "<DQ_COL_FAILURE_COUNT>",
        "DQ_COL_MESSAGE": "<DQ_COL_MESSAGE>",
        "DQ_COL_CHECK_NAME": "<DQ_COL_CHECK_NAME>",
        "DQ_COL_SCORE_DATE": "<DQ_COL_SCORE_DATE>",
        "DQ_COL_SCOPE": "<DQ_COL_SCOPE>",
        "DQ_COL_TIER": "<DQ_COL_TIER>",
        "DQ_TIER1_TARGET_PCT": "<DQ_TIER1_TARGET_PCT>",
        "DBT_SLA_CONFIG_PATH": "<DBT_SLA_CONFIG_PATH>",
        "DBT_TOOLS": "<DBT_TOOLS>",
        "DBT_DISABLE": "<DBT_DISABLE>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

Name	Description
`DBT_PROJECT_DIR` Required	Path to dbt project root (where dbt_project.yml lives).
`DBT_TARGET_DIR` Optional	dbt target dir for manifest.json/run_results.json (default: $DBT_PROJECT_DIR/target).
`DBT_RUN_HISTORY_DIR` Optional	Optional dir for archived run_results.json history (glob-scanned).
`DQ_BACKEND` Optional	DQ result table backend: 'bigquery' (default) or 'postgres'.
`DQ_RESULTS_TABLE` Optional	Fully qualified DQ checks table, e.g. 'project.data_ops.quality_checks'.
`DQ_SCORE_TABLE` Optional	Fully qualified DQ score-daily table, e.g. 'project.data_ops.quality_score_daily'.
`GOOGLE_APPLICATION_CREDENTIALS` Optional	Service account key path for BigQuery (ADC fallback supported).
`BQ_PROJECT_ID` Optional	Explicit BigQuery project ID for DQ queries.
`PG_CONNECTION_STRING` Optional, secret	Postgres connection string when DQ_BACKEND=postgres.
`DBT_ALLOW_WRITE` Optional	Reserved for future write tools. Default read-only.
`DQ_SCHEMA` Optional	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` Optional	Override for the timestamp/date column on the DQ checks table. Default depends on DQ_SCHEMA preset.
`DQ_COL_CHECK_TYPE` Optional	Override for the check-type column on the DQ checks table. Default 'check_type'.
`DQ_COL_STATUS` Optional	Override for the status column on the DQ checks table. Default 'status'.
`DQ_COL_DATASET` Optional	Override for the dataset/source column on the DQ checks table. Default depends on preset.
`DQ_COL_TABLE_NAME` Optional	Override for the table/target-name column on the DQ checks table. Default depends on preset.
`DQ_COL_SEVERITY` Optional	Override for the severity/dimension column on the DQ checks table. Default depends on preset.
`DQ_COL_FAILURE_COUNT` Optional	Override for the numeric failure-count column on the DQ checks table. Default depends on preset.
`DQ_COL_MESSAGE` Optional	Override for the message column on the DQ checks table. Default depends on preset.
`DQ_COL_CHECK_NAME` Optional	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` Optional	Override for the date column on the DQ score-daily table. Default depends on preset.
`DQ_COL_SCOPE` Optional	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` Optional	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` Optional	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.
`DBT_SLA_CONFIG_PATH` Optional	Optional path to a YAML file that defines tier_sla (per-tier overall_score targets) and dbt_sla (test/freshness pass rates). When set, dq-tier-status and dq-tier-by-source read tier targets from this file, and dbt-sla-status compares run_results / sources pass rates against dbt_sla.test_pass_pct /…
`DBT_TOOLS` Optional	Comma-separated category allowlist (dbt,quality,meta).
`DBT_DISABLE` Optional	Comma-separated category disablelist.

Details

Package	`@us-all/[email protected]` (NPM, stdio)
First published	19 Jun 2026
Last updated	19 Jun 2026
Registry name	`io.github.us-all/dbt`

More databases servers See all

Live status

Local install

Installed and run on your own machine, so there is no public endpoint to check.

Pair it with live search

Agents that use Dbt often also need current facts. NestDaddy MCP gives your AI today's internet: web search, real-time breaking news and full page reading in one connector.

See NestDaddy MCP

For maintainers

[![NestDaddy MCP](https://nestdaddy.com/mcp/servers/io-github-us-all-dbt/badge.svg)](https://nestdaddy.com/mcp/servers/io-github-us-all-dbt)

Add the badge to your README. It turns green while your server passes our daily check. Listing details come from the official MCP registry; update them there.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.