# auditing-warehouse-source-health

auditing-warehouse-source-health audits PostHog data warehouse sources and syncs to pinpoint broken connectors, failed schemas, and degraded webhooks.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 204 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/auditing-warehouse-source-health/SKILL.md
- Updated: 2026-11-16
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/auditing-warehouse-source-health

## What it does

This skill inspects your PostHog warehouse ingestion pipeline to compile an overview of active connection failures. It queries the `data-warehouse-data-health-issues-retrieve` tool, categorizing issues by operational impact. Broken source connections appear first because a dead connector halts every underlying schema, followed by billing quota blocks and table-level errors.

For deeper inspection, it pulls from `external-data-sources-list` and `external-data-schemas-list`, checking webhook states through `external-data-sources-webhook-info-retrieve`. The default health endpoint only flags active failures. Schemas paused by users or syncs marked `Completed` that stopped updating days ago require inspecting `last_synced_at` timestamps directly.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill auditing-warehouse-source-health -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/auditing-warehouse-source-health/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/auditing-warehouse-source-health/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill auditing-warehouse-source-health -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/auditing-warehouse-source-health/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill auditing-warehouse-source-health -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/auditing-warehouse-source-health/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install PostHog/ai-plugin skills/auditing-warehouse-source-health
```

2. **Manually: put the files in place**
- File: `.github/skills/auditing-warehouse-source-health/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill auditing-warehouse-source-health -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/PostHog/ai-plugin --path skills/auditing-warehouse-source-health
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/auditing-warehouse-source-health/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill auditing-warehouse-source-health -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/auditing-warehouse-source-health/SKILL.md

## When to use it
- identify failing imports across PostHog warehouse connections
- detect schema drift and broken database table syncs
- spot silent webhook failures that regular health checks miss
- triage stale dashboard data during project handovers

## Example prompts
- Audit my PostHog warehouse sources and show what is failing
- Why are warehouse imports broken across my project?
- Check source connection health and list tables hitting billing limits

## Similar
- [setting-up-a-data-warehouse-source](https://affpapa.org/en/nevibecode/skills/setting-up-a-data-warehouse-source.md) — skill · 405 installs
- [suggesting-data-imports](https://affpapa.org/en/nevibecode/skills/suggesting-data-imports.md) — skill · 401 installs
- [enterprise-data-engineering-pipeline-ssis-pyspark](https://affpapa.org/en/nevibecode/skills/enterprise-data-engineering-pipeline-ssis-pyspark.md) — skill · 2000 installs
- [retail-etl-pipeline-medallion](https://affpapa.org/en/nevibecode/skills/retail-etl-pipeline-medallion.md) — skill · 1800 installs
- [building-syncs](https://affpapa.org/en/nevibecode/skills/building-syncs.md) — skill · 1400 installs
- [data-engineering](https://affpapa.org/en/nevibecode/skills/data-engineering.md) — skill · ★ 2858 repo stars

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
