Skip to main content
skill CX Codex

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

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

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

2Manually: put the files in place

~/.claude/skills/signals-scout-data-warehouse/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/signals-scout-data-warehouse/

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.

Similar skills

All skills for Data and databases →
setting-up-a-data-warehouse-source PostHog setting-up-a-data-warehouse-source connects databases, cloud storage buckets, and SaaS tools to PostHog's data warehouse. Handles credential verification, table discovery, and sync modes. CX Codex +1 405installs signals-scout-data-pipelines PostHog signals-scout-data-pipelines signals scout detects silent delivery failures in PostHog data pipelines. It catches stalled exports, degraded CDP functions, and failing hog flows against baselines. CX Codex +1 317installs data-warehouse-experimentation rampstackco The data-warehouse-experimentation Claude Code skill explains how to run A/B tests in a data warehouse without vendor platforms. It covers user assignment, metric calculation, and statistical analysis. CX Codex +1 283installs data-context-extractor official anthropics data-context-extractor extracts tribal knowledge from data analysts about your warehouse and auto-generates reference files. Runs in bootstrap mode for initial setup and iteration mode to add new domains. CX Codex +1 3,300installs analyzing-data astronomer analyzing-data turns business questions into SQL, runs them against the data warehouse and caches the table mappings it finds along the way. CX Codex +1 1,500installs ktx-ai-data-agents-context-layer reason-machines The ktx-ai-data-agents-context-layer skill guides setup of ktx as a context layer for warehouse queries. It connects approved metrics, data structure, and business knowledge for AI agents. CX Codex +1 157installs

From the same set82

The whole set →
debugging-surveys debugging-surveys investigates why PostHog Surveys fail to appear or record complete answers. Useful for support cases involving targeting, SDK behavior, and stored responses. CX Codex +1 197installs authoring-scouts authoring-scouts is a Claude Code skill for creating, tuning, and testing PostHog Signals scouts that inspect project metrics on a schedule and submit findings. CX Codex +1 196installs creating-online-evaluations creating-online-evaluations — a Claude Code skill that turns production failure modes into continuously-running online evaluations in PostHog. It starts when new generations need automatic scoring against specific errors. CX Codex +1 195installs signals-scout-insight-alerts signals-scout-insight-alerts — a Claude Code skill for reviewing insight alert history in PostHog. It scans recent alert triggers and flags material incidents that missed notifying the team. CX Codex +1 195installs signals-scout-mcp-tool-calls signals-scout-mcp-tool-calls — a PostHog Signals skill that sifts $mcp_tool_call telemetry for MCP tools agents struggle with, then files one report per product category. CX Codex +1 194installs signals-scout-web-vitals signals-scout-web-vitals tracks page p75 LCP, INP, CLS, and FCP from PostHog events, spots performance degradation against Google thresholds, and links regressions to deploys. CX Codex +1 194installs signals-scout-skills-store signals-scout-skills-store audits shared PostHog agent skills for vague descriptions, oversized bodies, broken links, and leaked secrets. Produces reports with copy-ready fixes. CX Codex +1 193installs analyzing-expensive-users analyzing-expensive-users — a skill for Claude Code, Codex, Cursor and other agents that finds the top spenders in PostHog AI observability and explains what drives their costs. CX Codex +1 192installs

Project sponsors

Companies that keep this analytics open