An automated analytics engineer that audits dbt projects for quality, test coverage, documentation, and SQL best practices.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install dbt-model-auditor
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install dbt-model-auditor using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is dbt Model Auditor?
The dbt Model Auditor is a powerful diagnostic tool within the Openclaw Skills library designed to evaluate the health and maintainability of dbt (data build tool) projects. It acts as an automated peer reviewer, scanning your entire project to identify suboptimal materialization strategies, missing tests, and undocumented models. By integrating this skill into your development workflow, you can ensure that your data warehouse follows industry-standard patterns for staging, intermediate, and marts layers.
This skill helps teams maintain high standards of data governance by checking for model contracts, PII classification, and source freshness. Whether you are prepping for a production release or cleaning up technical debt, using Openclaw Skills for dbt auditing provides a clear roadmap for improving your analytics engineering maturity.
dbt Model Auditor Use Cases
- Identifying critical gaps in dbt test coverage and primary key validation.
- Detecting hardcoded table references that break data lineage and DAG integrity.
- Reviewing materialization strategies to optimize compute costs in Snowflake, BigQuery, or Redshift.
- Auditing large dbt projects for naming convention consistency across different team members.
- Assessing SQL quality to find anti-patterns like SELECT * or inefficient UNION operations.
How dbt Model Auditor Works
- The agent discovers the project structure by locating the dbt_project.yml and mapping all models, sources, and macros.
- It performs a naming convention audit to ensure files follow the stg, int, and fct prefix standards.
- It validates the DAG by checking every SQL file for proper ref() and source() usage, flagging hardcoded references.
- The agent parses schema YAML files to calculate a test and documentation coverage percentage for every model.
- It analyzes SQL complexity and logic, looking for common performance bottlenecks and anti-patterns.
- Finally, the Openclaw Skills engine generates a comprehensive health report with an overall score and prioritized remediation steps.
dbt Model Auditor Setup
To audit your project using this skill, navigate to your dbt project root and ensure your profiles are configured. Use the following commands with Openclaw Skills:
# Navigate to your dbt project
cd /path/to/your/dbt_project
# Run a full project audit
openclaw run cm-dbt-model-auditor "Audit this dbt project"
You can also target specific layers:
openclaw run cm-dbt-model-auditor "Audit the staging layer models"
dbt Model Auditor Data Schema & Taxonomy
The skill organizes its audit findings into a structured taxonomy that evaluates the following components:
| Category | Metric | Focus |
|---|---|---|
| Naming | Convention Score | stg_, int_, fct_ prefixes and snake_case consistency |
| Lineage | ref() & source() | Detection of hardcoded table names and cross-layer skips |
| Quality | Test Coverage | Percentage of models with unique, not_null, and FK tests |
| Governance | Documentation | Model and column-level descriptions and exposure definitions |
| Performance | Materialization | Optimization of view vs table vs incremental strategies |
| SQL | Code Quality | Detection of SELECT *, UNION without ALL, and complex CTEs |
dbt Model Auditor Advanced Features
- Layer-specific auditing focusing only on staging, intermediate, or marts layers.
- Incremental model performance analysis, including unique_key and merge strategy validation.
- Integration with model contracts to enforce schema constraints in dbt 1.5+ projects.
- Git-aware audits via Openclaw Skills that only review models changed in the current feature branch.
- Detailed remediation examples providing the exact YAML or SQL needed to fix identified issues.
SKILL.md
Loading
Related Openclaw Skills
Video Editing Best AI Tool
A professional AI-driven video editor that automates cutting, transitions, and cloud-based rendering through simple natural language commands.
Dagster Pipeline Analyzer
A comprehensive diagnostic tool for auditing Dagster software-defined assets, partitioning strategies, and pipeline reliability.
Accessibility Scanner
An automated and manual auditing tool for ensuring web applications meet WCAG 2.2 accessibility standards and inclusive design principles.
Code Complexity Analyzer
A multi-language static analysis tool that measures cyclomatic, cognitive, and structural metrics to identify high-risk code.
Docker Compose Optimizer
A professional-grade auditing tool for Docker Compose files that identifies security risks, performance bottlenecks, and production-readiness gaps.
API Status Checker
An automated utility for AI agents to monitor API health, validate response codes, and track endpoint latency.
Featured*
