Can I test only specific models or schemas?

Absolutely. You can instruct the skill to run tests for a single model, a specific staging area, or even focus exclusively on retrying previously failed tests using dbt selectors.

How does this skill interact with my dbt project?

It uses bash tools to execute standard dbt commands and filesystem tools to read project configurations and test result files like run_results.json and catalog.json.

Does it support the dbt-expectations package?

Yes, it is specifically optimized to recognize and analyze common test types from the dbt-expectations library, providing context-aware advice for regex matches, set inclusions, and range checks.

How does it provide fix recommendations?

By parsing the error messages and metadata in run_results.json, the skill uses AI to suggest specific SQL corrections, such as adding deduplication logic or handling null values with COALESCE.

DBT Data Quality Runner

Name: DBT Data Quality Runner
Author: nerver111

bynerver111

0•

数据库管理

Automates dbt data quality testing and provides intelligent analysis of test failures and remediation steps.

The DBT Data Quality Runner is a specialized Claude Code skill designed to streamline data validation workflows within dbt projects. It enables developers to execute comprehensive test suites, integrate advanced checks from the dbt-expectations package, and automatically parse run results to identify root causes of data anomalies. By bridging the gap between test execution and failure analysis, this skill helps maintain high-integrity data pipelines through actionable insights, detailed health reporting, and automated diagnostics for common SQL data issues.

主要功能

01Deep integration with dbt-expectations for advanced validation like regex and row counts

020 GitHub stars

03Automated execution of dbt test suites for entire projects or targeted models

04Detailed health reporting including pass rates, failure types, and model-level statistics

05Real-time parsing of run_results.json to categorize and summarize test outcomes

06Intelligent troubleshooting and specific fix recommendations for failed data checks

使用场景

01Auditing project-wide data quality using standardized expectations for uniqueness and nullability

02Validating data integrity after performing complex SQL transformations or schema migrations

03Debugging production pipeline failures by isolating and analyzing failed tests for specific models

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test dbt-quality-rule-runner

For use in Claude.ai and ChatGPT

主要功能

01Deep integration with dbt-expectations for advanced validation like regex and row counts

020 GitHub stars

03Automated execution of dbt test suites for entire projects or targeted models

04Detailed health reporting including pass rates, failure types, and model-level statistics

05Real-time parsing of run_results.json to categorize and summarize test outcomes

06Intelligent troubleshooting and specific fix recommendations for failed data checks

使用场景

01Auditing project-wide data quality using standardized expectations for uniqueness and nullability

02Validating data integrity after performing complex SQL transformations or schema migrations

03Debugging production pipeline failures by isolating and analyzing failed tests for specific models