io.github.us-all/dbt

io.github.us-all/dbt·v1.0.7·Databases

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

Trust verdict · v1 advisory · method

NOT YET SCREENEDno verdict on file

Verdict not yet evaluated for this tool. The semantic screen takes adversarial cases first; coverage rolls out as the corpus expands (15/150 labels to graduation). The deterministic conformance probe is built but has not yet run on the public corpus, so a recorded verdict here is REVIEW or UNVERIFIED, never a clearing ALLOW. Until a verdict is recorded, an agent should treat this tool as not-yet-cleared and fall back to its own checks. Method: the eval, four-state verdict, honest limits.

Own this server? Screen its description →

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 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.

DQ_COL_CHECK_TYPE

Override for the check-type column on the DQ checks table. Default 'check_type'.

DQ_COL_STATUS

Override for the status column on the DQ checks table. Default 'status'.

DQ_COL_DATASET

Override for the dataset/source column on the DQ checks table. Default depends on preset.

DQ_COL_TABLE_NAME

Override for the table/target-name column on the DQ checks table. Default depends on preset.

DQ_COL_SEVERITY

Override for the severity/dimension column on the DQ checks table. Default depends on preset.

DQ_COL_FAILURE_COUNT

Override for the numeric failure-count column on the DQ checks table. Default depends on preset.

DQ_COL_MESSAGE

Override for the message column on the DQ checks table. Default depends on preset.

DQ_COL_CHECK_NAME

Override for the check_name column on the DQ checks table. Set to 'none'/'null'/'-' to synthesize check_name from check_type and table_name.

DQ_COL_SCORE_DATE

Override for the date column on the DQ score-daily table. Default depends on preset.

DQ_COL_SCOPE

Override for the scope column on the DQ score-daily table. Set to 'none'/'null'/'-' if the table has no per-scope rollup.

DQ_COL_TIER

Override for the tier column on the DQ score-daily table. Set to 'none'/'null'/'-' if the table has no tier dimension.

DQ_TIER1_TARGET_PCT

When no tier column is configured (us-all preset or DQ_COL_TIER=none), the overall_score threshold dq-tier-status compares against (default 99.5). Superseded by DBT_SLA_CONFIG_PATH tier_sla.1 if both are set.

DBT_SLA_CONFIG_PATH

Optional path to a YAML file that defines tier_sla (per-tier overall_score targets) and dbt_sla (test/freshness pass rates). When set, dq-tier-status and dq-tier-by-source read tier targets from this file, and dbt-sla-status compares run_results / sources pass rates against dbt_sla.test_pass_pct / freshness_pass_pct. Mtime cached.

DBT_TOOLS

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

DBT_DISABLE

Comma-separated category disablelist.

MCP quality score · maturity, not trust · methodology

freshness

completeness

installability

documentation

stability

Alternatives in Databases

ai.haymon/dbmcp

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite with PII redaction and write-prevention

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…

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_COL_RUN_AT": "<dq_col_run_at>",
        "DQ_COL_CHECK_TYPE": "<dq_col_check_type>",
        "DQ_COL_STATUS": "<dq_col_status>",
        "DQ_COL_DATASET": "<dq_col_dataset>",
        "DQ_COL_TABLE_NAME": "<dq_col_table_name>",
        "DQ_COL_SEVERITY": "<dq_col_severity>",
        "DQ_COL_FAILURE_COUNT": "<dq_col_failure_count>",
        "DQ_COL_MESSAGE": "<dq_col_message>",
        "DQ_COL_CHECK_NAME": "<dq_col_check_name>",
        "DQ_COL_SCORE_DATE": "<dq_col_score_date>",
        "DQ_COL_SCOPE": "<dq_col_scope>",
        "DQ_COL_TIER": "<dq_col_tier>",
        "DQ_TIER1_TARGET_PCT": "<dq_tier1_target_pct>",
        "DBT_SLA_CONFIG_PATH": "<dbt_sla_config_path>",
        "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_COL_RUN_AT": "<dq_col_run_at>",
        "DQ_COL_CHECK_TYPE": "<dq_col_check_type>",
        "DQ_COL_STATUS": "<dq_col_status>",
        "DQ_COL_DATASET": "<dq_col_dataset>",
        "DQ_COL_TABLE_NAME": "<dq_col_table_name>",
        "DQ_COL_SEVERITY": "<dq_col_severity>",
        "DQ_COL_FAILURE_COUNT": "<dq_col_failure_count>",
        "DQ_COL_MESSAGE": "<dq_col_message>",
        "DQ_COL_CHECK_NAME": "<dq_col_check_name>",
        "DQ_COL_SCORE_DATE": "<dq_col_score_date>",
        "DQ_COL_SCOPE": "<dq_col_scope>",
        "DQ_COL_TIER": "<dq_col_tier>",
        "DQ_TIER1_TARGET_PCT": "<dq_tier1_target_pct>",
        "DBT_SLA_CONFIG_PATH": "<dbt_sla_config_path>",
        "DBT_TOOLS": "<dbt_tools>",
        "DBT_DISABLE": "<dbt_disable>"
      }
    }
  }
}

Cline (cline_mcp_settings.json)

npx -y @us-all/dbt-mcp

Verdict API

curl -s mcpindex.ai/api/v1/trust/server/io-github-us-all-dbt

Free-tier verdict as JSON: decision + dimensions + severity. Call it from your agent before it invokes a tool it just discovered.

Details

version: v1.0.7
category: Databases
quality: 85 / 100
operator: us-all

Provenance

Verdict history is anchored to Bitcoin via OpenTimestamps. The free tier returns the current verdict only; the anchored record is served on the authenticated tier.

Links

Repository →