data-quality-test-generator

Generate dbt 1.10+ test suites for staging, fact, and dimension models.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/zazu-22/ff_data_analytics --skill data-quality-test-generator
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-quality-test-generator
Source: https://github.com/zazu-22/ff_data_analytics/tree/main/.claude/_archive_skills/data-quality-test-generator
Command: npx skills add https://github.com/zazu-22/ff_data_analytics --skill data-quality-test-generator

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and assets (resource) components.

What problem does it solve?

This Skill automates the creation of exhaustive dbt test suites that enforce data quality standards following FF Analytics guidelines and dbt 1.10+ syntax. It saves data engineers and analysts hours by standardizing test coverage and reducing manual scripting.

Core Features & Use Cases

  • Automated test generation: Produce dbt 1.10+ data_tests for staging, fact, and dimension models.
  • Quality gates: Include grain uniqueness, FK relationships, enum validation, and freshness checks.
  • Template-driven: Leverages predefined templates to ensure consistency across projects.

Quick Start

Use this skill to generate a complete test suite for a new or existing dbt model, then integrate the produced tests into your dbt project.

Frequently Asked Questions about data-quality-test-generator

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

FAQPage Schema
How do I auto-generate dbt data quality tests for my models?

This Skill auto-generates comprehensive dbt test suites enforcing data quality standards. It produces dbt 1.10+ data_tests for staging, fact, and dimension models, including grain uniqueness, FK relationships, enum validation, and freshness checks, eliminating manual test scripting.

What dbt versions and test types does this support?

The Skill requires dbt 1.10+ syntax with data_tests, arguments, and config blocks. It generates tests including not_null, unique_combination_of_columns, relationships, accepted_values, and expression checks across staging, fact, and dimension models.

Can I use this to expand test coverage on existing dbt models?

Yes. The Skill applies to new model creation, test coverage expansion, and data quality gates. It analyzes existing models and generates additional tests to meet data quality standards under dbt 1.10+ syntax.

How does this enforce data quality gates in dbt projects?

The Skill enforces data quality gates by automatically generating standardized tests that validate grain uniqueness, foreign key relationships, enum constraints, and freshness across your dbt models, reducing manual quality assurance work.

Does this work with Fantasy Football Analytics models specifically?

The Skill is designed for Fantasy Football Analytics models but applies template-driven test generation to any dbt staging, fact, or dimension models following dbt 1.10+ syntax conventions.