io.github.us-all/dbt

io.github.us-all/dbt·v0.1.1·Databases

Quality Score

/100

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

Repository →

§01 Install

Claude Desktop (claude_desktop_config.json)

{
  "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": "<your-pg_connection_string>",
        "DBT_ALLOW_WRITE": "false",
        "DQ_SCHEMA": "generic",
        "DQ_TIER1_TARGET_PCT": "<dq_tier1_target_pct>",
        "DBT_TOOLS": "<dbt_tools>",
        "DBT_DISABLE": "<dbt_disable>"
      }
    }
  }
}

Cursor (.cursor/mcp.json)

{
  "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": "<your-pg_connection_string>",
        "DBT_ALLOW_WRITE": "false",
        "DQ_SCHEMA": "generic",
        "DQ_TIER1_TARGET_PCT": "<dq_tier1_target_pct>",
        "DBT_TOOLS": "<dbt_tools>",
        "DBT_DISABLE": "<dbt_disable>"
      }
    }
  }
}

Cline (cline_mcp_settings.json)

npx -y @us-all/dbt-mcp

§02 Environment variables

DBT_PROJECT_DIR

required

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

DBT_TARGET_DIR

dbt target dir for manifest.json/run_results.json (default: $DBT_PROJECT_DIR/target).

DBT_RUN_HISTORY_DIR

Optional dir for archived run_results.json history (glob-scanned).

DQ_BACKEND

DQ result table backend: 'bigquery' (default) or 'postgres'.

DQ_RESULTS_TABLE

Fully qualified DQ checks table, e.g. 'project.data_ops.quality_checks'.

DQ_SCORE_TABLE

Fully qualified DQ score-daily table, e.g. 'project.data_ops.quality_score_daily'.

GOOGLE_APPLICATION_CREDENTIALS

Service account key path for BigQuery (ADC fallback supported).

BQ_PROJECT_ID

Explicit BigQuery project ID for DQ queries.

PG_CONNECTION_STRING

secret

Postgres connection string when DQ_BACKEND=postgres.

DBT_ALLOW_WRITE

Reserved for future write tools. Default read-only.

DQ_SCHEMA

DQ result-table schema flavor: 'generic' (default) or 'us-all'.

DQ_TIER1_TARGET_PCT

When DQ_SCHEMA=us-all, the overall_score threshold dq-tier-status compares against (default 99.5).

DBT_TOOLS

Comma-separated category allowlist (dbt,quality,meta).

DBT_DISABLE

Comma-separated category disablelist.

§03 MCP Quality Score · methodology

freshness

completeness

installability

documentation

stability

§04 Alternatives in Databases

ai.haymon/dbmcp

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite

ai.smithery/MisterSandFR-supabase-mcp-selfhosted

Manage Supabase projects end to end across database, auth, storage, realtime, and migrations. Moni…

ai.smithery/afgong-sqlite-mcp-server

Explore your Messages SQLite database to browse tables and inspect schemas with ease. Run flexible…