dbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres)
Use this profile to copy client config, check auth requirements, review tools and resources, and compare related MCP servers before adding it to an AI client.
Get practical integration notes and launch examples for MCP servers like dbt.
npx -y @us-all/dbt-mcp{
"DBT_PROJECT_DIR": "YOUR_VALUE_HERE",
"DBT_TARGET_DIR": "YOUR_VALUE_HERE",
"DBT_RUN_HISTORY_DIR": "YOUR_VALUE_HERE",
"DQ_BACKEND": "YOUR_VALUE_HERE",
"DQ_RESULTS_TABLE": "YOUR_VALUE_HERE",
"DQ_SCORE_TABLE": "YOUR_VALUE_HERE",
"GOOGLE_APPLICATION_CREDENTIALS": "YOUR_VALUE_HERE",
"BQ_PROJECT_ID": "YOUR_VALUE_HERE",
"PG_CONNECTION_STRING": "YOUR_SECRET_VALUE",
"DBT_ALLOW_WRITE": "false",
"DQ_SCHEMA": "generic",
"DQ_COL_RUN_AT": "YOUR_VALUE_HERE",
"DQ_COL_CHECK_TYPE": "YOUR_VALUE_HERE",
"DQ_COL_STATUS": "YOUR_VALUE_HERE",
"DQ_COL_DATASET": "YOUR_VALUE_HERE",
"DQ_COL_TABLE_NAME": "YOUR_VALUE_HERE",
"DQ_COL_SEVERITY": "YOUR_VALUE_HERE",
"DQ_COL_FAILURE_COUNT": "YOUR_VALUE_HERE",
"DQ_COL_MESSAGE": "YOUR_VALUE_HERE",
"DQ_COL_CHECK_NAME": "YOUR_VALUE_HERE",
"DQ_COL_SCORE_DATE": "YOUR_VALUE_HERE",
"DQ_COL_SCOPE": "YOUR_VALUE_HERE",
"DQ_COL_TIER": "YOUR_VALUE_HERE",
"DQ_TIER1_TARGET_PCT": "YOUR_VALUE_HERE",
"DBT_SLA_CONFIG_PATH": "YOUR_VALUE_HERE",
"DBT_TOOLS": "YOUR_VALUE_HERE",
"DBT_DISABLE": "YOUR_VALUE_HERE"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-us-all-dbt": {
"command": "npx",
"args": [
"-y",
"@us-all/dbt-mcp"
],
"env": {
"DBT_PROJECT_DIR": "YOUR_VALUE_HERE",
"DBT_TARGET_DIR": "YOUR_VALUE_HERE",
"DBT_RUN_HISTORY_DIR": "YOUR_VALUE_HERE",
"DQ_BACKEND": "YOUR_VALUE_HERE",
"DQ_RESULTS_TABLE": "YOUR_VALUE_HERE",
"DQ_SCORE_TABLE": "YOUR_VALUE_HERE",
"GOOGLE_APPLICATION_CREDENTIALS": "YOUR_VALUE_HERE",
"BQ_PROJECT_ID": "YOUR_VALUE_HERE",
"PG_CONNECTION_STRING": "YOUR_SECRET_VALUE",
"DBT_ALLOW_WRITE": "false",
"DQ_SCHEMA": "generic",
"DQ_COL_RUN_AT": "YOUR_VALUE_HERE",
"DQ_COL_CHECK_TYPE": "YOUR_VALUE_HERE",
"DQ_COL_STATUS": "YOUR_VALUE_HERE",
"DQ_COL_DATASET": "YOUR_VALUE_HERE",
"DQ_COL_TABLE_NAME": "YOUR_VALUE_HERE",
"DQ_COL_SEVERITY": "YOUR_VALUE_HERE",
"DQ_COL_FAILURE_COUNT": "YOUR_VALUE_HERE",
"DQ_COL_MESSAGE": "YOUR_VALUE_HERE",
"DQ_COL_CHECK_NAME": "YOUR_VALUE_HERE",
"DQ_COL_SCORE_DATE": "YOUR_VALUE_HERE",
"DQ_COL_SCOPE": "YOUR_VALUE_HERE",
"DQ_COL_TIER": "YOUR_VALUE_HERE",
"DQ_TIER1_TARGET_PCT": "YOUR_VALUE_HERE",
"DBT_SLA_CONFIG_PATH": "YOUR_VALUE_HERE",
"DBT_TOOLS": "YOUR_VALUE_HERE",
"DBT_DISABLE": "YOUR_VALUE_HERE"
}
}
}
}~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.jsonNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
dbt is an MCP server for dbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres). It supports STDIO transport.
Use the generated config in Install. This server runs with npx -y @us-all/dbt-mcp; add any required environment variables before starting your client.
Choose the Claude Desktop tab in Install and copy the config for npx -y @us-all/dbt-mcp. Add required environment variables before starting Claude Desktop.
Choose the Claude Code tab in Install and copy the config for npx -y @us-all/dbt-mcp. Add required environment variables before starting Claude Code.
Choose the Codex tab in Install and copy the config for npx -y @us-all/dbt-mcp. Add required environment variables before starting Codex.
Choose the Cursor or VS Code tab in Install and copy the config for npx -y @us-all/dbt-mcp. Add required environment variables before starting Cursor or VS Code.
dbt uses STDIO transport. Use the package or command config in Install.
dbt inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
dbt is marked with Auth required by registry metadata auth. You may need provider login, an API key, a bearer token, or a session header.
| Package | Registry | Version | Inputs |
|---|---|---|---|
@us-all/dbt-mcpstdio | npm | 1.0.3 | Env: DBT_PROJECT_DIR required 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 secret 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 |