data-quality-checks

Automate data quality validation with Great Expectations, anomaly detection, and lineage tracking.

1|Updated Mar 21, 2026
One-click install
npx skills add https://github.com/kalilurrahman/kr-claudiator-skills-original-prompts --skill data-quality-checks-kalilurrahman
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-quality-checks
Source: https://github.com/kalilurrahman/kr-claudiator-skills-original-prompts/tree/main/03-data-analytics/data-quality-checks
Command: npx skills add https://github.com/kalilurrahman/kr-claudiator-skills-original-prompts --skill data-quality-checks-kalilurrahman

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires great-expectations, pandas, numpy, scipy, pyspark, apache-airflow, prometheus-client, pytest.

What problem does it solve? Bad data silently corrupts pipelines, dashboards, and downstream decisions. This Skill automates data quality validation so schema drift, nulls, duplicates, stale data, and anomalies are caught on every pipeline run instead of after users notice. ## Core Features & Use Cases - Great Expectations Validation: Build expectation suites covering schema, types, nullability, uniqueness, and value ranges, then run them as checkpoints on every ETL execution. - Anomaly & Freshness Detection: Detect statistical outliers with Z-scores, flag unusual daily volumes against rolling baselines, and enforce data freshness SLAs. - Quarantine & Lineage: Separate invalid records into quarantine storage for debugging, track transformations from source to destination, and expose quality metrics via Prometheus. - Use Case: An hourly Airflow DAG loads orders data, runs six automated checks (schema, completeness, uniqueness, ranges, freshness, anomalies), records a quality score, and fails the pipeline if critical checks fail. ## Quick Start Ask the AI to design automated data quality checks with Great Expectations for your orders dataset, including schema validation, freshness SLAs, and quarantine handling.

Frequently Asked Questions about data-quality-checks

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

FAQPage Schema
How do I validate data quality with Great Expectations?

Create a data context, connect a datasource, and build an expectation suite with checks like column types, not-null constraints, uniqueness, and value ranges. Then run a checkpoint against each new batch and inspect the validation results for failures.

How to detect anomalies in data pipelines with Python?

Use Z-score detection to flag values more than three standard deviations from the mean, or compare daily volumes against a 30-day rolling baseline. Alert when anomaly rates exceed a threshold such as 5 percent of records or a 50 percent volume change.

What data quality dimensions should I check in ETL pipelines?

Check completeness (no nulls in critical columns), accuracy (valid formats and realistic values), consistency across systems, timeliness (freshness SLAs), validity (values in acceptable ranges), and uniqueness (no duplicate primary keys).

Can I run data quality checks in Airflow DAGs?

Yes. Define a PythonOperator that loads the data, runs schema, completeness, uniqueness, range, freshness, and anomaly checks, then raises an error when critical checks fail. Schedule the DAG hourly to validate every pipeline run.

What should I do with records that fail validation?

Quarantine invalid records instead of dropping them. Write good records to production storage and bad records to a separate quarantine path with a timestamp, then alert on the quarantined count so the data can be debugged and potentially recovered.