DQ
Data Quality Checks
🔵 Stable🕐 updated 2026-06-28
🔷 SkillSpec L3
pm-dataeng
Design the data quality checks for a table or pipeline across the standard dimensions. Use when asked to add data quality tests, define DQ checks, catch bad data before it hits dashboards, or set up monitoring for a dataset. Produces a checks plan across completeness, validity, uniqueness, freshness, consistency, and accuracy — each with the rule, severity, and where it runs (dbt test / Great Expectations / SQL assertion).
What to give it
▸The table / pipeline — and what it represents (grain, key columns).
▸The columns that matter — keys, required fields, enums, ranges, dates.
▸Freshness expectation — how current the data must be.
▸Tooling — dbt tests, Great Expectations, Soda, or raw SQL assertions.
✅ The bar it holds itself to
Every skill in this library self-verifies — these are this skill's own quality checks, straight from its definition.
✓Covers the core dimensions (completeness, uniqueness, validity, freshness, consistency)
✓Each check has an explicit rule and a severity (block vs. warn)
✓Severity is disciplined — only truly critical checks block the pipeline
✓Freshness has a measurable SLA, not "should be recent"
✓Each check names where it runs and what happens on failure
⚠️ What it refuses to do
Do not block the pipeline on every check — alert fatigue makes people ignore the real failures; reserve 🔴 for critical
Do not only test the happy path — the grain key, nulls, and freshness are where the real breakage hides
Do not write checks with no failure action — a test that fails into the void changes nothing
Do not skip freshness — stale data that looks fine is the most dangerous kind
Do not check only one table in isolation — cross-table consistency (FKs, reconciliations) catches integration bugs
Install
npx pm-claude-skills add --agent claude # or codex · cursor · gemini · hermes
# or one-line MCP (every skill, any client):
claude mcp add pm-skills -- npx -y pm-claude-skills-mcpRelated skills
🔌 Embed this skill
Drop this on your blog, docs, or site — it renders a "Run this skill" card:
<div data-pm-skill="data-quality-checks"></div>
<script src="https://mohitagw15856.github.io/pm-claude-skills/embed.js" async></script>💬 Discussion
Data Quality Checks is one of 599 open-source professional AI agent skills — all SkillSpec L3.
Try them all in the browser · ⭐ Star on GitHub · Browse the full catalog