# signals-scout-data-warehouse

signals-scout-data-warehouse monitors warehouse imports for failures, stale data, and sharp row-count drops, then flags recurring query patterns that may merit materialized views.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 195 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/signals-scout-data-warehouse/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/signals-scout-data-warehouse

## What it does

This skill reviews external data sources, sync schemas, webhook delivery channels, and materialized views. It looks for failed imports, stalled runs, freshness that falls behind the configured cadence, and sudden drops in row volume. It also scans recurring query-log hotspots and surfaces tables or query shapes that may benefit from materialization.

The workflow compares what an import promises with what it actually delivers, then writes findings through the report channel and keeps run notes in the scratchpad. It relies on the PostHog Signals agent and its authorized MCP tools for analytics, source configuration, schemas, webhooks, views, and inbox reports. Without that agent and the required MCP access, these checks cannot run. If activity history is unavailable, history-dependent checks are skipped while independent checks continue.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -a claude-code
```

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

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -a codex
```

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

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -a cursor
```

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

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install PostHog/ai-plugin skills/signals-scout-data-warehouse
```

2. **Manually: put the files in place**
- File: `.github/skills/signals-scout-data-warehouse/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/PostHog/ai-plugin --path skills/signals-scout-data-warehouse
```

### Windsurf (Devin Desktop)

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

### OpenCode

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

## When to use it
- detect failed warehouse imports
- find schemas that have fallen behind their sync cadence
- catch sharp drops in imported row volume
- spot recurring expensive queries on the same table
- surface candidates for materialized views

## Example prompts
- Audit the warehouse imports and report schemas that are behind their configured sync cadence.
- Check webhook channels and materialized views for failures or silent staleness.
- Review recurring warehouse queries and suggest candidates for materialization.

## Similar
- [setting-up-a-data-warehouse-source](https://affpapa.org/en/nevibecode/skills/setting-up-a-data-warehouse-source.md) — skill · 405 installs
- [signals-scout-data-pipelines](https://affpapa.org/en/nevibecode/skills/signals-scout-data-pipelines.md) — skill · 317 installs
- [data-warehouse-experimentation](https://affpapa.org/en/nevibecode/skills/data-warehouse-experimentation.md) — skill · 283 installs
- [data-context-extractor](https://affpapa.org/en/nevibecode/skills/data-context-extractor.md) — skill · 3300 installs
- [analyzing-data](https://affpapa.org/en/nevibecode/skills/analyzing-data.md) — skill · 1500 installs
- [ktx-ai-data-agents-context-layer](https://affpapa.org/en/nevibecode/skills/ktx-ai-data-agents-context-layer.md) — skill · 157 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
