authoring-data-quality-checks — Claude Code skill: what it does
authoring-data-quality-checks is a Claude Code skill that adds and runs dbt-style data quality checks on warehouse tables and HogQL metrics. It runs when validating models or checking for nulls and duplicates.
no license 148 installs ★ 101 updated 2026-10-24
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a claude-codeWhat authoring-data-quality-checks does
The skill creates assertions like not-null, uniqueness, freshness, and custom SQL checks on warehouse tables and views. Checks compile into count-only HogQL queries and pass when zero failing rows are found.
Before writing assertions, it queries system information schemas to avoid duplicates and check column types. Large tables like events use lookback hours to bound the scanned rows and manage execution budgets.
Catalog metrics support custom SQL checks using the metric placeholder. Reads go through SQL systems while writes and test runs execute through data-quality MCP tools.
What it helps with
- add not null check to a table column
- verify row uniqueness in a data model
- set up freshness checks for a sync pipeline
- validate table data before analysis
Example prompts for the agent
- Add a not_null check to the id column in orders
- Check table uniqueness for events
- Set up a freshness check for the persons table
How to install authoring-data-quality-checks
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a claude-code2Manually: put the files in place
~/.claude/skills/authoring-data-quality-checks/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/authoring-data-quality-checks/
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a codex2Manually: put the files in place
.agents/skills/authoring-data-quality-checks/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a cursor2Manually: put the files in place
.cursor/skills/authoring-data-quality-checks/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install PostHog/ai-plugin skills/authoring-data-quality-checks2Manually: put the files in place
.github/skills/authoring-data-quality-checks/SKILL.md1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a gemini-cli2Platform CLI
gemini skills install https://github.com/PostHog/ai-plugin --path skills/authoring-data-quality-checksManually: put the files in place
.devin/skills/authoring-data-quality-checks/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about authoring-data-quality-checks
How to install authoring-data-quality-checks in Claude Code?
Run npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a claude-code followed by ~/.claude/skills/authoring-data-quality-checks/SKILL.md.
What does authoring-data-quality-checks do?
It sets up and runs dbt-style data quality assertions on warehouse tables, views, and HogQL metrics.
How are check results stored?
Only counts and compiled queries are saved, without storing individual failing rows.