dbt

io.github.us-all/dbt · version 1.0.7

Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.

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

https://github.com/us-all/dbt-mcp-server

Quick facts

Listing: Community
Published Jun 19, 03:59 UTC
Transport: stdio
Package: npm @us-all/dbt-mcp 1.0.7
Listed by cosmic-mcp: Nov 9, 04:27 UTC

Details

Repository: https://github.com/us-all/dbt-mcp-server
npm: https://www.npmjs.com/package/@us-all/dbt-mcp
Needs settings: 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

Data and analytics

Setup snippets

Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.

Run it locally (npm)

npx -y '@us-all/[email protected]'

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "dbt": {
      "args": [
        "-y",
        "@us-all/[email protected]"
      ],
      "command": "npx",
      "env": {
        "BQ_PROJECT_ID": "<your bq project id>",
        "DBT_ALLOW_WRITE": "<your dbt allow write>",
        "DBT_DISABLE": "<your dbt disable>",
        "DBT_PROJECT_DIR": "<your dbt project dir>",
        "DBT_RUN_HISTORY_DIR": "<your dbt run history dir>",
        "DBT_SLA_CONFIG_PATH": "<your dbt sla config path>",
        "DBT_TARGET_DIR": "<your dbt target dir>",
        "DBT_TOOLS": "<your dbt tools>",
        "DQ_BACKEND": "<your dq backend>",
        "DQ_COL_CHECK_NAME": "<your dq col check name>",
        "DQ_COL_CHECK_TYPE": "<your dq col check type>",
        "DQ_COL_DATASET": "<your dq col dataset>",
        "DQ_COL_FAILURE_COUNT": "<your dq col failure count>",
        "DQ_COL_MESSAGE": "<your dq col message>",
        "DQ_COL_RUN_AT": "<your dq col run at>",
        "DQ_COL_SCOPE": "<your dq col scope>",
        "DQ_COL_SCORE_DATE": "<your dq col score date>",
        "DQ_COL_SEVERITY": "<your dq col severity>",
        "DQ_COL_STATUS": "<your dq col status>",
        "DQ_COL_TABLE_NAME": "<your dq col table name>",
        "DQ_COL_TIER": "<your dq col tier>",
        "DQ_RESULTS_TABLE": "<your dq results table>",
        "DQ_SCHEMA": "<your dq schema>",
        "DQ_SCORE_TABLE": "<your dq score table>",
        "DQ_TIER1_TARGET_PCT": "<your dq tier1 target pct>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your google application credentials>",
        "PG_CONNECTION_STRING": "<your pg connection string>"
      }
    }
  }
}

Claude Code

claude mcp add 'dbt' -- npx -y '@us-all/[email protected]'

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "dbt": {
      "args": [
        "-y",
        "@us-all/[email protected]"
      ],
      "command": "npx",
      "env": {
        "BQ_PROJECT_ID": "<your bq project id>",
        "DBT_ALLOW_WRITE": "<your dbt allow write>",
        "DBT_DISABLE": "<your dbt disable>",
        "DBT_PROJECT_DIR": "<your dbt project dir>",
        "DBT_RUN_HISTORY_DIR": "<your dbt run history dir>",
        "DBT_SLA_CONFIG_PATH": "<your dbt sla config path>",
        "DBT_TARGET_DIR": "<your dbt target dir>",
        "DBT_TOOLS": "<your dbt tools>",
        "DQ_BACKEND": "<your dq backend>",
        "DQ_COL_CHECK_NAME": "<your dq col check name>",
        "DQ_COL_CHECK_TYPE": "<your dq col check type>",
        "DQ_COL_DATASET": "<your dq col dataset>",
        "DQ_COL_FAILURE_COUNT": "<your dq col failure count>",
        "DQ_COL_MESSAGE": "<your dq col message>",
        "DQ_COL_RUN_AT": "<your dq col run at>",
        "DQ_COL_SCOPE": "<your dq col scope>",
        "DQ_COL_SCORE_DATE": "<your dq col score date>",
        "DQ_COL_SEVERITY": "<your dq col severity>",
        "DQ_COL_STATUS": "<your dq col status>",
        "DQ_COL_TABLE_NAME": "<your dq col table name>",
        "DQ_COL_TIER": "<your dq col tier>",
        "DQ_RESULTS_TABLE": "<your dq results table>",
        "DQ_SCHEMA": "<your dq schema>",
        "DQ_SCORE_TABLE": "<your dq score table>",
        "DQ_TIER1_TARGET_PCT": "<your dq tier1 target pct>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your google application credentials>",
        "PG_CONNECTION_STRING": "<your pg connection string>"
      }
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "dbt": {
      "args": [
        "-y",
        "@us-all/[email protected]"
      ],
      "command": "npx",
      "env": {
        "BQ_PROJECT_ID": "<your bq project id>",
        "DBT_ALLOW_WRITE": "<your dbt allow write>",
        "DBT_DISABLE": "<your dbt disable>",
        "DBT_PROJECT_DIR": "<your dbt project dir>",
        "DBT_RUN_HISTORY_DIR": "<your dbt run history dir>",
        "DBT_SLA_CONFIG_PATH": "<your dbt sla config path>",
        "DBT_TARGET_DIR": "<your dbt target dir>",
        "DBT_TOOLS": "<your dbt tools>",
        "DQ_BACKEND": "<your dq backend>",
        "DQ_COL_CHECK_NAME": "<your dq col check name>",
        "DQ_COL_CHECK_TYPE": "<your dq col check type>",
        "DQ_COL_DATASET": "<your dq col dataset>",
        "DQ_COL_FAILURE_COUNT": "<your dq col failure count>",
        "DQ_COL_MESSAGE": "<your dq col message>",
        "DQ_COL_RUN_AT": "<your dq col run at>",
        "DQ_COL_SCOPE": "<your dq col scope>",
        "DQ_COL_SCORE_DATE": "<your dq col score date>",
        "DQ_COL_SEVERITY": "<your dq col severity>",
        "DQ_COL_STATUS": "<your dq col status>",
        "DQ_COL_TABLE_NAME": "<your dq col table name>",
        "DQ_COL_TIER": "<your dq col tier>",
        "DQ_RESULTS_TABLE": "<your dq results table>",
        "DQ_SCHEMA": "<your dq schema>",
        "DQ_SCORE_TABLE": "<your dq score table>",
        "DQ_TIER1_TARGET_PCT": "<your dq tier1 target pct>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your google application credentials>",
        "PG_CONNECTION_STRING": "<your pg connection string>"
      },
      "type": "stdio"
    }
  }
}

Related servers

Analytics Legends — SAP AI & Analytics MCP Server Verified domain
SAP AI & analytics market data for agents: SAP firms, day rates, jobs, Joule & BDC news
Ankra Verified domain
Deploy and operate Kubernetes: clusters, stacks, apps, logs, metrics and security, with OAuth.
AutoRFP.ai Verified domain
Search AutoRFP.ai projects, requirements, content library, and tags for Q&A and analytics.
Dubai Data — Dubai real estate statistics Verified domain
Dubai property prices, AED/sqft, sales, rents, yields and projects from DLD registered transactions.
100Trades Verified domain
Read your 100Trades day-trading simulator record: trades, R, stops, notes and analytics.
11agents Cloud MCP
Cloud MCP for project data, analytics, research, content planning, media generation, and growth.