wicked-garden-qe-data-quality-tester

wicked-garden-qe-data-quality-tester is a skill for Claude Code from mikeparcewski/wicked-garden. It costs 65 tokens per session (567 once invoked), scanned A, original, MIT.

A data-quality testing skill that checks whether stored data matches its schema, relationships, required fields, allowed values, expected distributions, freshness, and row counts. It also verifies that database migrations can move forward and roll back safely.

In plain words
What is it for?
Use it to validate databases, data warehouses, ETL pipelines, data contracts, and migration plans. It produces assertion tests and reports showing drift, freshness problems, broken relationships, and example offending rows.
Why use it?
It catches corrupted, incomplete, duplicated, stale, or unexpectedly changed data before it reaches users or downstream systems. It also helps detect migrations that lose data or fail to restore the original state.

Skill for Claude Code

Written for Claude Code: shipped in a Claude Code plugin.

Part of the wicked-garden plugin — 144 skills, 5 commands, 1 agent, 13 hooks shipped together

Good fit Use it to validate databases, data warehouses, ETL pipelines, data contracts, and migration plans. It produces assertion tests and reports showing drift, freshness problems, broken relationships, and example offending rows.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/mikeparcewski/wicked-garden/qe-data-quality-tester
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add mikeparcewski/wicked-garden --skill qe-data-quality-tester
Clone the repo
git clone --depth 1 https://github.com/mikeparcewski/wicked-garden

Made for: Claude Code.

Or install wicked-garden, the plugin that ships this one along with the rest of its 144 skills, 5 commands, 1 agent, 13 hooks.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for wicked-garden-qe-data-quality-tester

README.md
[![agentmods](https://agentmods.dev/badge/skills/mikeparcewski/wicked-garden/qe-data-quality-tester/github.svg)](https://agentmods.dev/skills/mikeparcewski/wicked-garden/qe-data-quality-tester)
Your own site
<a href="https://agentmods.dev/skills/mikeparcewski/wicked-garden/qe-data-quality-tester"><img src="https://agentmods.dev/badge/skills/mikeparcewski/wicked-garden/qe-data-quality-tester/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for wicked-garden-qe-data-quality-tester

Your own site · 80×15
<a href="https://agentmods.dev/skills/mikeparcewski/wicked-garden/qe-data-quality-tester"><img src="https://agentmods.dev/badge/skills/mikeparcewski/wicked-garden/qe-data-quality-tester.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 65 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 567 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00065 $0.00567
Opus 5.5 $0.00026 $0.00227
Sonnet 5.5 $0.00013 $0.00113
Haiku 4.5 $0.00006 $0.00057

Measured 1mo ago against content hash 318f7cacd602, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

wicked-garden-qe-data-quality-tester scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 1mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/qe-data-quality-tester/SKILL.md · 63 lines

How it starts

The opening of the file, as written. The whole thing — 63 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Data Quality Tester

You verify the data itself, not just the code that touches it.

Checks

  • Schema conformance — every row matches the declared schema
  • Referential integrity — FKs resolve; orphans flagged
  • Nullability — required fields aren't null
  • Range / enum — values fall in expected bounds
  • Distribution — row count, cardinality, null rate within tolerance of baseline
  • Freshness — timestamps within expected lag
  • Uniqueness — no unexpected dupes on declared keys
  • Row counts — upstream → downstream conservation

Migration testing

  • Forward: run the migration on a representative dataset, re-check all invariants
  • Rollback: run the down migration, verify original state restored
  • Pre-flight: dry-run on a snapshot, estimate duration + lock impact

Tools

  • great_expectations — Python suites, docs-as-output
  • dbt-test — warehouse-native assertions
  • SQL-based custom checks — EXCEPT queries, cardinality ratios
  • Soda for streaming / operational data

Run what you write — never ship

The wicked-garden-qe skill's refs/author.md § Verified-test contract binds every test you produce, whether dispatched or invoked directly:

  • Run every file you write with the project's own harness and report file · exact command · result (N passed / N failed); not run = unverified, never covered; a red test ships as failing with the reason, never as green.
  • A test that needs a server, seed data or a build is needs-fixture with how to start it, and is run against that fixture before it is claimed.
  • Claim pre-existing coverage only with path:line of the test; count new tests separately from cited pre-existing ones.
  • Never git push / gh pr create / gh pr merge — the run's deliver phase opens the PR; standalone, the human does. Leave the files on the working tree.

Output

Assertion suite + a freshness / drift report. On failure, show the offending rows (bounded sample) and the invariant that broke.

Read the full file on GitHub · 63 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 1mo ago Changed · -7 lines 318f7cacd602
  2. 1mo ago Changed · +18 lines 013737b40262
  3. 1mo ago First seen · 52 lines · 65 tokens per session scan A 83b9a797e41b

Subscribe to this mod's changes

wicked-garden-qe-data-quality-tester is a skill published in the GitHub repository mikeparcewski/wicked-garden (9 stars, last pushed today), licensed MIT. It adds 65 tokens to every session and 567 once invoked, about $0.0003 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.