data-quality

Generate schema YAML tests and custom checks for dbt models.

24|11|Updated Feb 19, 2026
One-click install
npx skills add https://github.com/clawdata/clawdata --skill data-quality-clawdata
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-quality
Source: https://github.com/clawdata/clawdata/tree/main/skills/data-quality
Command: npx skills add https://github.com/clawdata/clawdata --skill data-quality-clawdata

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Add data quality checks and tests to dbt models and pipelines to ensure data integrity and reliable analytics.

Core Features & Use Cases

  • Analyze dbt models to determine appropriate tests (unique, not_null, relationships, accepted_values, range checks) and generate schema YAML.
  • Create custom tests in tests/ or via macros when generic checks are insufficient.
  • Recommend using dbt_utils or dbt_expectations for advanced validations and add source freshness checks.

Quick Start

Run the data-quality workflow to analyze your dbt project and generate tests for staging models.

Frequently Asked Questions about data-quality

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I add data quality tests to dbt models?

To add data quality tests to dbt models, generate schema YAML files with built-in checks like unique, not_null, relationships, and accepted_values to validate data integrity across staging and marts.

What is the best way to automate dbt data validation for pipelines?

Automating dbt data validation involves applying generic tests in schema YAML and creating custom tests or macros for advanced checks, ensuring pipeline data integrity and trust in analytics.

Can I use dbt_utils and dbt_expectations for advanced dbt schema testing?

Yes, you can leverage dbt_utils and dbt_expectations for advanced dbt schema testing when generic checks are insufficient, enabling complex data validations and source freshness checks.

When do I need custom tests in dbt instead of generic schema YAML checks?

You need custom dbt tests when generic schema YAML checks cannot capture specific business rules, requiring you to write custom SQL queries in the tests directory or via macros.

Does dbt data quality testing support source freshness checks?

Yes, dbt data quality testing supports source freshness checks to validate that your source data is up to date, adding an essential layer of trust to your analytics pipelines.