Search
Databases · By PostHog
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Audit already-implemented Data warehouse import sources for endpoints, schemas, and tables the vendor's API offers but we never wired up. | PostHog/ | 40k | — | ~3.7k | Automated safety check: Pass | Unknown | today |
| 2 | Find feature flags that were soft-deleted in the active project within a recent time window. | PostHog/ | 40k | — | ~2k | Automated safety check: Pass | Unknown | today |
| 3 | 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 | today |
| 4 | Creates product analytics or SQL-backed box plot insights in PostHog. | PostHog/ | 40k | — | ~1.1k | Automated safety check: Pass | Unknown | today |
| 5 | Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU). | PostHog/ | 40k | — | ~5.1k | Automated safety check: Pass | Unknown | today |
| 6 | 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 | today |
| 7 | Explains how to query PostHog data, defaulting to typed runners for supported product analytics. | PostHog/ | 40k | — | ~4.2k | Automated safety check: Pass | Unknown | today |
| 8 | Converts engineering analytics (PR / CI) data into saved PostHog insights, dashboards, and subscriptions, and explains how to query the product data directly with SQL. | PostHog/ | 40k | — | ~2.9k | Automated safety check: Pass | Unknown | today |
| 9 | How to add a new ingestion warning type to the event ingestion pipeline. | PostHog/ | 40k | — | ~3.7k | Automated safety check: Pass | Unknown | today |
| 10 | Pull and interpret production experiment query-performance data from the staff-only /api/debugchqueries endpoints backing the /experiments/staff scene: slowest experiment queries, precompute… | PostHog/ | 40k | — | ~3.7k | Automated safety check: Pass | Unknown | today |
| 11 | 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 | today |
| 12 | 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.5k | Automated safety check: Pass | Unknown | today |
| 13 | ClickHouse migration patterns and rules. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~3k | Automated safety check: Pass | Unknown | today |
| 14 | Debug the signals pipeline locally end-to-end. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~2.4k | Automated safety check: Notes | Unknown | today |
| 15 | 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 | today |
| 16 | Determine which PostHog team owns a file, directory, or code path, or enumerate all code a team owns (via distributed owners.yaml, products//product.yaml, and .github/CODEOWNERS). | PostHog/ | 40k | — | ~1.5k | Automated safety check: Pass | Unknown | today |
| 17 | Explore and diagnose a PostHog endpoint's execution logs — error messages, failed runs, cache misses, slow runs, or unexpected row counts during endpoint invocations. | PostHog/ | 40k | — | ~1.7k | Automated safety check: Pass | Unknown | today |
| 18 | Pick the right y-axis unit when creating or updating an insight via posthog:insight-create or posthog:insight-update — both TrendsQuery (trendsFilter.aggregationAxisFormat) and SQL insights… | PostHog/ | 40k | — | ~2.1k | Automated safety check: Pass | Unknown | today |
| 19 | Implement and extend PostHog Data warehouse import sources. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~22k | Automated safety check: Pass | Unknown | today |
| 20 | Investigates a session recording by gathering metadata, person profile, same-session events, and linked error tracking issues in one pass. | PostHog/ | 40k | — | ~2.4k | Automated safety check: Pass | Unknown | today |
| 21 | Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT). | PostHog/ | 40k | — | ~2.5k | Automated safety check: Notes | Unknown | today |
| 22 | Runs read-only production database analysis through PostHog's internal Metabase instances. | PostHog/ | 40k | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 23 | 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 | today |
| 24 | A skill your agent uses when adding a bucket-like rate limit backed by Redis: a per-caller budget with burst capacity and continuous refill, a refund path for requests that did no work, or a limit… | PostHog/ | 40k | — | ~1.6k | Automated safety check: Pass | Unknown | today |
| 25 | 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 | today |
| 26 | 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 | today |
| 27 | 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 | today |
| 28 | 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 | today |
| 29 | 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 | today |
| 30 | 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 | today |
| 31 | Runs diagnostics and a health check on one PostHog experiment: its setup, exposures, results and changes during the run. | PostHog/ | 40k | — | ~5.9k | Automated safety check: Pass | Unknown | today |
| 32 | Investigate logs in a PostHog project: verify a service or deployment is healthy, explain an error spike, triage an incident, or understand what a log stream is saying. | PostHog/ | 40k | — | ~2.1k | Automated safety check: Pass | Unknown | today |
| 33 | 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 | today |
| 34 | Workflow for optimizing ClickHouse and HogQL queries. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~5.7k | Automated safety check: Pass | Unknown | today |
| 35 | Profiles slow PostHog API endpoints when the main cost is in Postgres or Python. | PostHog/ | 40k | — | ~1k | Automated safety check: Pass | Unknown | today |
| 36 | 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 | today |
| 37 | Signals scout for warehouse imports. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~11k | Automated safety check: Pass | Unknown | today |
| 38 | 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 | today |
| 39 | Guide for writing performant ClickHouse queries in PostHog product code. | PostHog/ | 40k | — | ~575 | Automated safety check: Pass | Unknown | today |
| 40 | 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 | today |
