Search
PostHog · Data warehousing
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Twice-monthly check that evlog's drain adapters still send what each provider's own client sends. | evloghq/ | 1.9k | — | ~1.3k | Automated safety check: Pass | MIT | today |
| 2 | Sync columns from a synced data warehouse table onto PostHog person or group properties, so warehouse data becomes usable anywhere person and group properties already work: feature flag targeting… | PostHog/ | 40k | — | ~2.9k | Automated safety check: Pass | Unknown | yesterday |
| 3 | Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU). | PostHog/ | 40k | — | ~5.1k | Automated safety check: Pass | Unknown | yesterday |
| 4 | Build reusable revenue models — MRR, ARR, gross revenue, new/expansion/contraction/churn, ARPU, LTV, and per-customer/per-account revenue — on either PostHog data-warehouse views (HogQL) or an… | PostHog/ | 40k | — | ~2.1k | Automated safety check: Pass | Unknown | yesterday |
| 5 | Analyze PostHog insights, dashboards, or teams beyond the current project by querying the prod Postgres replicas synced into the dogfood data warehouse (US project 2, "PostHog App + Website"). | PostHog/ | 40k | — | ~1k | Automated safety check: Pass | Unknown | yesterday |
| 6 | Audit the health of a PostHog project's materialized views (saved queries) — find every failed materialization and flag unused or stale materialized views that cost storage and compute. | PostHog/ | 40k | — | ~1.8k | Automated safety check: Pass | Unknown | yesterday |
| 7 | ClickHouse migration patterns and rules. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~3k | Automated safety check: Pass | Unknown | yesterday |
| 8 | Debug the signals pipeline locally end-to-end. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~2.4k | Automated safety check: Notes | Unknown | yesterday |
| 9 | Write or update the user-facing posthog.com documentation for a PostHog Data warehouse import source. | PostHog/ | 40k | — | ~1.7k | Automated safety check: Pass | Unknown | yesterday |
| 10 | Implement and extend PostHog Data warehouse import sources. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~22k | Automated safety check: Pass | Unknown | yesterday |
| 11 | Runs read-only production database analysis through PostHog's internal Metabase instances. | PostHog/ | 40k | — | ~2.8k | Automated safety check: Pass | Unknown | yesterday |
| 12 | Query tophog — the ingestion pipeline's heavy-hitter store in ClickHouse — to identify hot or expensive actors (teamid, distinctid, sessionid, partition) during incident triage. | PostHog/ | 40k | — | ~2.3k | Automated safety check: Pass | Unknown | yesterday |
| 13 | Build reusable activation models — an activation-rate metric and a per-user/per-account activated flag — on either PostHog data-warehouse views (HogQL) or an external dbt project. | PostHog/ | 40k | — | ~1.4k | Automated safety check: Pass | Unknown | yesterday |
| 14 | Build reusable conversion models — funnel/step conversion rates, drop-off, and time-to-convert — on either PostHog data-warehouse views (HogQL) or an external dbt project. | PostHog/ | 40k | — | ~1.4k | Automated safety check: Pass | Unknown | yesterday |
| 15 | Build reusable dimension / lookup tables for a star schema — country/region, timezone, currency, date, plan/product, and other descriptive attributes — on either PostHog data-warehouse views (HogQL)… | PostHog/ | 40k | — | ~1.4k | Automated safety check: Pass | Unknown | yesterday |
| 16 | Build reusable product-usage and engagement models — retention, stickiness, and lifecycle — on either PostHog data-warehouse views (HogQL) or an external dbt project. | PostHog/ | 40k | — | ~1.3k | Automated safety check: Pass | Unknown | yesterday |
| 17 | Shared foundations for building reusable data models in PostHog, on either of two stacks: PostHog-native data-warehouse views / materialized views (HogQL, via the view- MCP tools), or an external… | PostHog/ | 40k | — | ~2.1k | Automated safety check: Pass | Unknown | yesterday |
| 18 | Authenticate a new or changed service to ClickHouse with the rotating ch-podauth ServiceAccount token instead of a static password. | PostHog/ | 40k | — | ~585 | Automated safety check: Pass | Unknown | yesterday |
| 19 | Guide for using the Grafana MCP to monitor and diagnose the Node.js ingestion pipeline workers in production. | PostHog/ | 40k | — | ~9.1k | Automated safety check: Pass | Unknown | yesterday |
| 20 | Profiles slow PostHog API endpoints when the main cost is in Postgres or Python. | PostHog/ | 40k | — | ~1k | Automated safety check: Pass | Unknown | yesterday |
| 21 | Populate person or group properties from a data warehouse table or materialized view, so warehouse columns become properties usable in feature flags, cohorts, and insights. | PostHog/ | 40k | — | ~2.3k | Automated safety check: Pass | Unknown | yesterday |
| 22 | Signals scout for warehouse imports. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~11k | Automated safety check: Pass | Unknown | yesterday |
| 23 | Add support for a new vendor API version to an existing Data warehouse import source, or deprecate an old one. | PostHog/ | 40k | — | ~8.8k | Automated safety check: Pass | Unknown | yesterday |
| 24 | Guide for writing performant ClickHouse queries in PostHog product code. | PostHog/ | 40k | — | ~575 | Automated safety check: Pass | Unknown | yesterday |
| 25 | Debug a customer's data warehouse source, schema, or table from a support ticket, using PostHog's own production data. | PostHog/ | 40k | — | ~6.3k | Automated safety check: Warn | Unknown | yesterday |
