data-quality-validator
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
With your agent
Install OMGSkills skill "pupfish-llc/qlik-agents:skills/data-quality-validator" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.
Manual command
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-validatorFrom 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.
More from this repo
platform-conventions
Captures existing platform patterns for brownfield Qlik projects.
qlik-cloud-mcp
Capability registry for the Qlik Cloud MCP server.
qlik-data-modeling
Star schema patterns, key resolution strategies, synthetic key prevention, QVD layer design, multi-app architecture...