auditing-warehouse-source-health

Audits PostHog data warehouse sources and syncs to report broken connections and failed schemas.

713|118|Updated Aug 11, 2020
One-click install
npx skills add https://github.com/PostHog/posthog-foss --skill auditing-warehouse-source-health
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: auditing-warehouse-source-health
Source: https://github.com/PostHog/posthog-foss/tree/main/products/warehouse_sources/skills/auditing-warehouse-source-health
Command: npx skills add https://github.com/PostHog/posthog-foss --skill auditing-warehouse-source-health

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

When PostHog data warehouse imports fail or go stale, it is hard to know which source connection, sync schema, or webhook channel is at fault. This Skill performs a project-wide health audit and produces a prioritized report so you know exactly where to dig first.

Core Features & Use Cases

  • One-shot health scan: Pulls all failed and degraded sources and sync schemas via the data-health-issues endpoint and groups them by severity.
  • Prioritized reporting: Ranks source-level errors above schema failures, separates billing-limit issues from technical ones, and shows the blast radius of each broken source.
  • Deeper optional checks: On request, detects stale-but-Completed schemas, abandoned sources, and silently broken webhook push channels.
  • Use Case: A user asks "why are my imports failing?" and receives a grouped report showing a Stripe source with authentication failure, two Postgres schemas failing on schema drift, and a HubSpot schema blocked by a billing limit, each with a recommended next step.

Quick Start

Ask the assistant to audit the health of my PostHog data warehouse sources and tell me which imports are broken and why.

Frequently Asked Questions about auditing-warehouse-source-health

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I find out why my PostHog warehouse imports are failing?

Run a source health audit that calls the data-health-issues endpoint to list all failed sources and sync schemas. The audit groups issues by severity, showing source-level errors first since they cascade to every schema underneath.

What is the difference between a source error and a sync schema failure in PostHog?

A source error means the entire external data connection is broken, so every schema under it stops syncing. A sync schema failure affects only one table, typically from schema drift like a renamed column or a billing limit being reached.

Does the data health endpoint detect broken webhooks on Stripe sources?

No, the data-health-issues endpoint only reports active source and sync failures. Webhook problems require calling webhook-info-retrieve per source to check whether the webhook exists, is enabled remotely, or has external errors.

Why does my schema show Completed but the data is stale?

A schema can report Completed status while its last_synced_at timestamp is far older than its sync frequency allows. Cross-check external-data-schemas-list for schemas whose last sync is stale relative to their configured frequency.

Can the audit fix broken sources automatically?

No, the audit is strictly read-only and never calls destructive tools. It reports issues and recommends hand-offs to diagnosis or tuning skills, and any fix requires explicit user confirmation before execution.

When should I use a single-sync diagnosis instead of a full audit?

Use a full audit when you want a project-wide triage of what is broken. If you already know which sync is failing and want a deep-dive on that one failure, go directly to the diagnosing-failed-warehouse-syncs skill.