# data-quality-validator

> Claude/Codex skill by [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars · Updated 2026-05-18

Post-load data quality validation patterns for Qlik development. Provides query templates for null rate analysis, referential integrity checks, value distribution analysis, row count validation, orphaned record detection, sparse field identification, and duplicate detection. Usable by the qa-reviewer when MCP or post-load data access is available. Also provides patterns for embedding validation checks directly into load scripts. Load when performing data quality validation or writing diagnostic scripts.

## Install

```sh
git clone https://github.com/Pupfish-LLC/qlik-agents /tmp/qlik-agents && ln -s /tmp/qlik-agents/skills/data-quality-validator ~/.claude/skills/data-quality-validator
```

## From README

Overview Post-load data quality validation catches issues that successful reloads can mask. Scripts reload without errors yet contain incorrect data: synthetic keys, orphaned records, unexpected nulls, duplicate keys, or value anomalies. This skill covers two contexts: QA Reviewer (post-load inspection) — qa-reviewer runs validation queries against loaded data or via MCP database connections, producing a Data Quality Validation Report Script Developer (embedded checks) — script-developer embeds validation checks directly in load scripts, reporting issues during reload via TRACE or error-handling framework The skill provides actionable query templates and patterns for both contexts. --- Section 1: Validation Categories Null Rate Analysis What it catches: Fields with unexpected null rates. Key fields should have 0% nulls. Dimension fields may have expected nulls (handled by NullAsValue) or unexpected ones indicating missing source data.

## Links

- HTML page: https://omgskills.com/library/pupfish-llc/qlik-agents/skills/data-quality-validator/
- GitHub: https://github.com/Pupfish-LLC/qlik-agents
- Author: [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md)

## More from this repo

- [platform-conventions](https://omgskills.com/library/pupfish-llc/qlik-agents/skills/platform-conventions/index.md) — Captures existing platform patterns for brownfield Qlik projects.
   - [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars
- [qlik-cloud-mcp](https://omgskills.com/library/pupfish-llc/qlik-agents/skills/qlik-cloud-mcp/index.md) — Capability registry for the Qlik Cloud MCP server.
   - [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars
- [qlik-data-modeling](https://omgskills.com/library/pupfish-llc/qlik-agents/skills/qlik-data-modeling/index.md) — Star schema patterns, key resolution strategies, synthetic key prevention, QVD layer design, multi-app architecture...
   - [@pupfish-llc](https://omgskills.com/library/pupfish-llc/index.md) · 1 stars