Skip to content
mcp/harbor
Claude Desktop

dbt for Claude Desktop

io.github.us-all/dbt

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

client:Claude Desktop transport:stdio runtime:npm

Install dbt in Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json · windows: %APPDATA%\Claude\claude_desktop_config.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen. 

{
  "mcpServers": {
    "dbt": {
      "command": "npx",
      "args": [
        "-y",
        "@us-all/dbt-mcp"
      ],
      "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>"
      }
    }
  }
}

Settings → Developer → Edit Config opens this file. Restart the app after saving. Claude Desktop docs

dbt in other clients

dbt MCP server