dbt-tools-ts

Reload in-memory artifacts after dbt run or a known artifact change. Use on the same target without restarting MCP.

Establish the dbt artifact root for this session (local path, s3://, or gs://). Use before any other dbt-tools analysis primitive.

Check MCP session state—target, load time, stale flag, runs, warehouse type. Use as a gate before analysis primitives.

Establish the dbt artifact root for this session (local path, s3://, or gs://). Use before any other dbt-tools analysis primitive.

Check whether dbt artifacts exist, are fresh, and which readiness level applies. Use as a gate before manifest- or run_results-based analysis.

Return metadata and context for one dbt resource by unique_id. Use when explaining what a model, source, or test does.

Find dbt resources by name, type, tag, package, or path. Use to resolve unique_id before describe-resource, trace-dependencies, or query-executions.

Filter and sort run_results node executions by status, time, and warehouse metrics. Use for post-run triage and slow-node investigation.

Confirm artifacts are up to date after dbt run or a known artifact change. Use before re-running analysis on the same target.

Summarize a dbt run (status breakdown, bottlenecks, adapter totals) without listing every node execution. Use before drill-down with query-executions.

Trace upstream or downstream dependencies for a dbt resource. Use for lineage, build order, or downstream blast radius.

Return metadata for one dbt resource by uniqueId. Use when explaining what a model, source, or test does.

Find dbt resources by name, type, tag, package, or path. Use to resolve uniqueId before describe-resource, trace-dependencies, or query-executions.

Filter and sort node executions from run_results by status, time, and warehouse metrics. Use for post-run triage.

Summarize the loaded dbt run (status breakdown, bottlenecks, adapter totals) without per-node execution rows.

Trace upstream or downstream dependencies for a dbt resource. Use for lineage, build order, or downstream blast radius.

Author a new agent skill under plugins/dbt-tools-cli/skills for @dbt-tools/cli; layout, plugin README index, and structural verification.

Set up the development environment for the project. Use when starting work on the project, when dependencies are out of sync, or to fix environment setup failures.

Bump synchronized semver versions across the root and @dbt-tools workspace package.json files. Use when asked to "bump package version", "release patch", "set all packages to X.Y.Z", "sync semver across workspace", or "prepare npm publish version bump".

Build the project and automatically fix any build errors, compilation failures, or type mismatches. Use when the project fails to build, shows "broken" states, or after making significant changes.

Inspect repository layout with tree and find, compare to AGENTS.md conventions, and fix misplaced or overly flat generated files. Use when auditing folder structure, after scaffolding or bulk file generation, when output looks flat, or when asked where code/tests/docs should live. Supports inspecting the repository root or a specified subdirectory.

Run CodeQL security/quality analysis and fix findings. Use when the user asks to run CodeQL, security scan, static analysis, or fix CodeQL findings.

Run Playwright E2E for @dbt-tools/web and fix failures. Use when the user asks to run E2E tests, fix E2E, fix Playwright failures, green test:e2e, or debug failing web app E2E—not unit tests (Vitest).

Implement and extend deterministic Playwright E2E tests for @dbt-tools/web (packages/web). Use when adding or changing E2E specs, user-journey tests, analyze flow coverage, Playwright selectors, or fixtures aligned with the real UI—not autonomous browser LLM exploration.

Pack @dbt-tools/web to a tarball and smoke-test the published dbt-tools-web CLI via npx without npm publish. Use when verifying the npm distribution, pre-release checks, bin/dist-serve layout, or fixing pack/npx failures for the web package.

Initialize a new project from the TypeScript template by renaming packages, updating metadata, and cleaning up documentation. Use when starting a new project, "bootstrapping" from this template, or setting up a fresh repository.

Run unit tests and automatically fix code failures, regression bugs, or test mismatches. Use when tests are failing, after implementing new features, or to repair "broken" tests.

Lightweight verification for UI-only changes to @dbt-tools/web. Runs lint, unit tests, coverage, a fresh build, Playwright E2E, and a coverage gap report. Use instead of the full verifier when changes are confined to packages/web/src/ and/or packages/web/e2e/. Skips CodeQL and pack+npx smoke.