List dbt models from manifest.json with filters (package, tag, materialized, schema, name search)

Get a single dbt model: refs, sources, columns (with catalog types if available), attached tests, raw/compiled SQL

List dbt tests (generic or singular) optionally filtered to a specific model

Get a single dbt test: definition, parameters, attached models, latest run result

List dbt sources from manifest.json with optional source-group / name filters

Get a single dbt source: freshness criteria, columns, latest freshness result from sources.json

List dbt exposures (downstream BI/ML/application consumers declared in YAML)

List dbt macros from manifest.json with package / name filters

Get a dbt macro: signature, raw SQL, and reverse-lookup of nodes that call it

List recent dbt invocations from run_results.json files in target/ and DBT_RUN_HISTORY_DIR

Get per-node results from a specific dbt invocation (or the latest run if invocationId omitted)

Find tests that failed across the last N runs, grouped and ordered by chronic failure count

Top N slowest models in a dbt run by execution_time, with bytes_processed when available

Per-column test coverage for a dbt model (which columns have tests, table-level tests, coverage %)

Walk dbt parent_map / child_map to return upstream and downstream nodes (model/source/test) up to a given depth

Cross-reference dbt source freshness criteria with sources.json results in a single 'is anything stale right now?' answer.

Single asset deep-dive: dbt definition + recent test failures + DQ checks for the dataset. Designed to anchor an LLM-driven incident triage.

Compare latest dbt run test pass rate and source freshness pass rate against DBT_SLA_CONFIG_PATH thresholds (dbt_sla.test_pass_pct / freshness_pass_pct). Returns per-axis passPct/target/meeting plus caveats when SLA fields or artifacts are missing.

List recent rows from DQ_RESULTS_TABLE filtered by dataset / status / type / time window

Time-series of one check_name's status across the last N days

Group failing checks by dataset across a recent window with the latest 5 failures per dataset

Time-series of the 4-axis DQ score (completeness / freshness / validity / anomaly_free) plus overall_score from DQ_SCORE_TABLE

Compare today's overall_score per scope against Tier SLA targets (defaults Tier 1 99.5 / 2 99.0 / 3 95.0; override via DBT_SLA_CONFIG_PATH yaml or DQ_TIER1_TARGET_PCT) and report meeting vs missing counts

Per-tier rollup computed from quality_checks grouped by source. Reads source-to-tier mapping from dbt sources.yml meta.tier and tier targets from DBT_SLA_CONFIG_PATH (falls back to defaults). Reports per-source pass rate, meeting/missing per tier, and untiered sources as caveats.

Aggregated 24h-ish view: dbt failed tests + DQ checks failures grouped by dataset + most recent failing rows. Replaces 3+ tool calls (dbt-failed-tests + dq-failed-checks-by-dataset + dq-list-checks).

Aggregated 4-axis score trend + today's Tier compliance + most recent failing checks. Combines dq-score-trend + dq-tier-status + dq-list-checks(fail).

Discover available dbt MCP tools by natural language query across dbt / quality / meta categories.