dbt

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

stdiocommunityapplication

Package Details

Transportstdio

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

Default:false

Reserved for future write tools. Default read-only.

DQ_SCHEMA

Default:generic

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.