dbt Test & Quality Auditor
Find the test and documentation gaps that let bad data ship—without running dbt or querying your warehouse.
What it does
- Flag models with no schema entry or unique/not_null tests.
- Find sources missing freshness configuration or tests.
- Review likely ID columns for missing unique or not_null coverage.
- Surface missing model descriptions and SELECT * usage.
- Catch raw table references that may need ref() or source().
- Produce severity-ranked findings and starter tests YAML for model and key-test gaps.
The scanner reads matching local dbt SQL and YAML files and reports heuristic findings with remediation guidance. Starter YAML is included only for missing model tests and likely-key test gaps; it is a reviewable template, not an automatic edit.
How to run
Get it on Agensi, point a SKILL.md-compatible agent at the dbt project directory, and run the bundled Python 3 standard-library scanner. No PyYAML install, dbt invocation, warehouse credentials, or network access is required.
Good to know
The scan is local, read-only, and heuristic. It can miss unusual YAML layouts, and YAML findings may use a general schema.yml location. Confirm every finding in project context before changing tests or model references.
Questions
What does dbt Test & Quality Auditor do?
It scans local dbt SQL and YAML for missing model tests, source freshness and test gaps, likely-key coverage, missing model descriptions, SELECT *, and raw table references.
What does it need to run?
A SKILL.md-compatible agent, local read access to the target dbt files, and Python 3 for the bundled scanner. It does not run dbt or connect to a warehouse.
Add dbt Test & Quality Auditor to your toolkit.
Current price and purchase option are shown on Agensi. Instant download. Works with any agent that reads SKILL.md.
Get dbt Test & Quality Auditor on Agensi