Dbt

stdio

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

Getting Started

npx @getmcp/cli add io.github.us-all/dbt

Requires Node.js 18+. Community-contributed server. Review source before installing.

Claude Desktopguide →Vscodeguide →Cursorguide →Windsurfguide →

Required Environment Variables

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

Configuration

Config file: ~/Library/Application Support/Claude/claude_desktop_config.json

JSON

{
  "mcpServers": {
    "io.github.us-all/dbt": {
      "command": "npx",
      "args": [
        "-y",
        "@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": "false",
        "DQ_SCHEMA": "generic",
        "DQ_TIER1_TARGET_PCT": "",
        "DBT_TOOLS": "",
        "DBT_DISABLE": ""
      }
    }
  }
}

Claude Desktop MCP documentation

Dbt