# authoring-data-quality-checks

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.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 148 installs · ★ 101 repo stars
- Author: PostHog
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/PostHog/ai-plugin/tree/HEAD/skills/authoring-data-quality-checks/SKILL.md
- Updated: 2026-10-24
- Security check: automated, 2026-11-17 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/authoring-data-quality-checks

## What it 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.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/authoring-data-quality-checks/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/authoring-data-quality-checks/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/authoring-data-quality-checks/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/authoring-data-quality-checks/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install PostHog/ai-plugin skills/authoring-data-quality-checks
```

2. **Manually: put the files in place**
- File: `.github/skills/authoring-data-quality-checks/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/PostHog/ai-plugin --path skills/authoring-data-quality-checks
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/authoring-data-quality-checks/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill authoring-data-quality-checks -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/PostHog/ai-plugin/tree/HEAD/skills/authoring-data-quality-checks/SKILL.md

## When to use it
- 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
- 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

## Similar
- [data-quality-frameworks](https://affpapa.org/en/nevibecode/skills/data-quality-frameworks.md) — skill · 11230 installs
- [data-warehouse-experimentation](https://affpapa.org/en/nevibecode/skills/data-warehouse-experimentation.md) — skill · 283 installs
- [altimate-data-engineering-skills](https://affpapa.org/en/nevibecode/skills/altimate-data-engineering-skills.md) — skill · 2100 installs
- [data](https://affpapa.org/en/nevibecode/skills/data.md) — skill · ★ 26 repo stars
- [ktx-ai-data-agents](https://affpapa.org/en/nevibecode/skills/ktx-ai-data-agents.md) — skill · 156 installs
- [analyze-data-quality](https://affpapa.org/en/nevibecode/skills/analyze-data-quality.md) — skill · 9 installs

From the same set: [posthog/ai-plugin](https://affpapa.org/en/nevibecode/by/posthog/ai-plugin.md) — 82 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
