dbt

Indexed by io.github.us-all

About

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

Use this server

Add it to your MCP client. The catalogue lists this config verbatim from its source — it does not run, download, or vouch for the server. Review the command before you run it.

Transportstdio (runs a local command)

Env varsDBT_PROJECT_DIR DBT_TARGET_DIR DBT_RUN_HISTORY_DIR DQ_BACKEND DQ_RESULTS_TABLE DQ_SCORE_TABLE GOOGLE_APPLICATION_CREDENTIALS BQ_PROJECT_ID PG_CONNECTION_STRING DBT_ALLOW_WRITE DQ_SCHEMA DQ_COL_RUN_AT DQ_COL_CHECK_TYPE DQ_COL_STATUS DQ_COL_DATASET DQ_COL_TABLE_NAME DQ_COL_SEVERITY DQ_COL_FAILURE_COUNT DQ_COL_MESSAGE DQ_COL_CHECK_NAME DQ_COL_SCORE_DATE DQ_COL_SCOPE DQ_COL_TIER DQ_TIER1_TARGET_PCT DBT_SLA_CONFIG_PATH DBT_TOOLS DBT_DISABLE

Claude Code

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

Cursor

Add to Cursor

If the button doesn't open Cursor, use the JSON below — Cursor accepts the same mcpServers config.

VS Code

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

JSON

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

Environment variables are listed by name only — fill in your own values. Entries never carry secrets.