Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a claude-code
Open on GitHub

What 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-code

2Manually: put the files in place

~/.claude/skills/authoring-data-quality-checks/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/authoring-data-quality-checks/

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.

Similar skills

All skills for Data and databases →

From the same set82

The whole set →
review-hog-resolution-criteria The review-hog-resolution-criteria Claude Code skill resolves open pull request review comments. It makes verifiable changes, explains declines, and hands risky decisions to a person. CX Codex +1 148installs working-with-scouts The working-with-scouts Claude Code skill helps manage PostHog Signals scouts that watch a project and send reports to the Signals inbox. Assign monitoring tasks, review findings, and steer the scouts with feedback. CX Codex +1 148installs setting-up-warehouse-properties The setting-up-warehouse-properties Claude Code skill maps warehouse columns to person or group properties in PostHog. It runs for reverse ETL setup or when replacing a recurring identify job. CX Codex +1 148installs suggesting-path-cleaning-rules suggesting-path-cleaning-rules is a Claude Code skill that proposes URL path-cleaning rules for web analytics. It engages on requests to generate or inspect suggestions and troubleshoot path_cleaning_suggestions issues. CX Codex +1 148installs querying-canvas-data The querying-canvas-data Claude Code skill helps put PostHog data into a canvas and make its metrics traceable to their source. It applies when a canvas needs charts, tables, analytics events, or data from GitHub or an MCP server. CX Codex +1 148installs creating-surveys The creating-surveys Claude Code skill creates PostHog surveys and forms through MCP. It activates for requests to build a survey or call survey-create. CX Codex +1 127installs checking-member-access The checking-member-access Claude Code skill explains member and role permissions in a PostHog project through access-control MCP tools. It answers who can view or edit dashboards, flags, and data. CX Codex +1 122installs signals-scout-pr-follow-up signals-scout-pr-follow-up — a Claude Code skill checks merged pull requests against post-deploy telemetry. It looks for the promised effect and regressions tied to a specific change. CX Codex +1 122installs

Project sponsors

Companies that keep this analytics open