dbt
dbt MCP — manifest/run_results/sources/catalog parsing + DQ result tables (BigQuery/Postgres)
Open the source (opens github.com) https://github.com/us-all/dbt-mcp-server
Before you use it
- Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
- Needs credentials: PG_CONNECTION_STRING. Use a key with the least access you can.
What it is
MCP servers from io.github.us-all.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
How to get it
npm package (stdio)
@us-all/dbt-mcp@1.0.7
From the server's entry in the official MCP Registry
Settings it asks for
DBT_PROJECT_DIRrequired · 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_STRINGsecret · Postgres connection string when DQ_BACKEND=postgres.DBT_ALLOW_WRITE· Reserved for future write tools. Default read-only.DQ_SCHEMA· DQ result-table schema preset: 'generic' (default) or 'us-all'. Use DQ_COL_* env vars to override individual columns on top of the preset.DQ_COL_RUN_AT· Override for the timestamp/date column on the DQ checks table. Default depends on DQ_SCHEMA preset.
Related
-
dbt-mcp
MCP serversA MCP (Model Context Protocol) server for interacting with dbt.
git clone https://github.com/dbt-labs/dbt-mcp.git -
dbt-lineage
MCP serversdbt model and column lineage, downstream impact and test proposals; no warehouse or dbt compile
dbt-lineage@0.19.0 -
dbtrail
MCP serversMySQL change tracking with instant row-level recovery and forensic attribution for compliance.
-
dbt-plan
MCP serversPredicts the DDL a dbt change will execute, before you run it. Reads files, not the warehouse.
dbt-plan@0.18.6 -
MC-Data Monitor
MCP serversSQL pipeline observability and DBT integration monitor.
-
Therapy for Teens
MCP serversTeen-first library on CBT, DBT, and finding the right therapist.