Best fit
Audit your dbt project for the test and documentation gaps that let bad data ship. Flags models with no unique or not_null tests, sources missing freshness config or tests, likely keys without a not_null test, models missing descriptions,…
// data engineering
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.
// choose with context
Is dbt Test & Quality Auditor the right skill?
It returns
Audit your dbt project for the test and documentation gaps that let bad data ship. Flags models with no unique or not_null tests, sources missing freshness config or tests, likely keys without a not_null test,….
Do not use it as
Do not treat a successful run as proof beyond the supplied files, declared scope, and evidence the skill actually checked.
Compatibility, access, version, and licence
- Reads or accesses
- Only the files or context you deliberately provide; review the listing before granting additional access.
- Compatibility
- Agents that read the open SKILL.md format. Verify runtime and service requirements at the purchase or install destination.
- Version
- Verify the current package version at the linked destination.
- Licence
- Review the package licence and seller terms at the linked destination.
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