Install dbt for Claude Desktop
Claude Desktop reads mcpServers from claude_desktop_config.json. Restart the app after saving.
- Open ~/Library/Application Support/Claude/claude_desktop_config.json on macOS, %APPDATA%\Claude\claude_desktop_config.json on Windows, or ~/.config/Claude/claude_desktop_config.json on Linux.
- Paste the JSON config below.
- Replace placeholder secrets, then restart the client if it does not reload on its own.
~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"us-all-dbt-mcp-server": {
"command": "npx",
"args": [
"-y",
"@us-all/dbt-mcp@1.0.7"
],
"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": "YOUR_PG_CONNECTION_STRING",
"DBT_ALLOW_WRITE": "false",
"DQ_SCHEMA": "generic",
"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": ""
}
}
}
}