signals-scout-data-warehouse — Claude Code skill
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.
no license 195 installs ★ 101 updated 2026-11-16
npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -a claude-codeWhat signals-scout-data-warehouse 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.
What it helps with
- 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 for the agent
- 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.
How to install signals-scout-data-warehouse
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -a claude-code2Manually: put the files in place
~/.claude/skills/signals-scout-data-warehouse/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/signals-scout-data-warehouse/
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -a codex2Manually: put the files in place
.agents/skills/signals-scout-data-warehouse/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -a cursor2Manually: put the files in place
.cursor/skills/signals-scout-data-warehouse/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install PostHog/ai-plugin skills/signals-scout-data-warehouse2Manually: put the files in place
.github/skills/signals-scout-data-warehouse/SKILL.md1Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -a gemini-cli2Platform CLI
gemini skills install https://github.com/PostHog/ai-plugin --path skills/signals-scout-data-warehouseManually: put the files in place
.devin/skills/signals-scout-data-warehouse/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -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 signals-scout-data-warehouse
How do I install signals-scout-data-warehouse in Claude Code?
Run npx skills add PostHog/ai-plugin --skill signals-scout-data-warehouse -a claude-code, then check ~/.claude/skills/signals-scout-data-warehouse/SKILL.md.
What does signals-scout-data-warehouse do?
It monitors warehouse imports, sync schemas, webhook channels, and materialized views for delivery and freshness problems. It also reviews recurring query activity for possible materialization candidates.
What does the skill need to run?
It is designed for the PostHog Signals agent in the Claude sandbox and uses authorized MCP tools for analytics, external data sources, schemas, webhooks, views, and report handling.