querying-posthog-data
querying-posthog-data is the official agent skill of PostHog published by posthog, listed under analytics & experiments. It lives in the PostHog/skills repository, which has 75 GitHub stars and is licensed under MIT; we last read it on 2026-10-08.
This repository explains how to choose typed queries or SQL for PostHog data, necessary for using HogQL/SQL or calling execute-sql against PostHog. It covers finding or aggregating PostHog entities such as insights, dashboards, cohorts, and feature flags, as well as trends, funnels, and web analytics. It also guides users to check for approved metric definitions and provides HogQL differences, system table schemas, functions, and query examples.
Install
skills is a generic installer for any repository of Claude agent skills -- it reads PostHog/skills’s own structure rather than assuming one, the same way this page reads the skill’s own SKILL.md rather than assuming a format.
npx skills add PostHog/skills
What it connects to
Unverified means a mention in the skill’s own description, not a citation. A wrong claim here costs nothing to correct and nothing to trust yet.
Maintenance
Explains how to query PostHog data, defaulting to typed runners for supported product analytics. Read it before you write HogQL/SQL. Also read it before you call execute-sql against PostHog. Use it to find or aggregate PostHog entities. These entities include insights, dashboards, cohorts, feature flags, experiments, surveys, hog flows, warehouse data, and persons. Use it for trends, funnels, retention, lifecycle, paths, stickiness, web analytics, error tracking, logs, sessions, and LLM traces. Before you calculate a governed business or telemetry measure, check system.information_schema.metrics for an approved definition. Examples include MRR, activation, billable usage, active organizations, and failure rates. Use the approved definition before you derive a measure from raw events or use a typed domain tool. It also covers HogQL differences, system table schemas, functions, query examples, and schema discovery.
querying-posthog-data compared with similar skills
| Skill | Publisher | What it does | Repo stars | Last update |
|---|---|---|---|---|
| querying-posthog-data (this page) | posthog | Explains how to query PostHog data, defaulting to typed runners for supported product analytics. Read it befo… | 75 | 2026-10-25 |
| account-handover(same repository) | posthog | Draft structured handover notes for transitioning a PostHog account from one TAM or CSM to another. Use this… | 75 | 2026-10-25 |
| adding-warehouse-person-properties(same repository) | posthog | Sync columns from a synced data warehouse table onto PostHog person or group properties, so warehouse data be… | 75 | 2026-10-25 |
| analyzing-experiment-session-replays(same repository) | posthog | Analyze session replay patterns across experiment variants to understand user behavior differences. Use when… | 75 | 2026-10-25 |
| analyzing-task-runs(same repository) | posthog | Split a completed PostHog task run into activity records — what the agent tried, whether it worked, what bloc… | 75 | 2026-10-25 |
| assessing-heatmaps(same repository) | posthog | Assesses what a page's heatmap is telling you and recommends concrete changes. Pulls click / rageclick / scro… | 75 | 2026-10-25 |
| auditing-endpoints(same repository) | posthog | Audit every endpoint in a PostHog project for staleness, failed materialisations, and unused materialised ver… | 75 | 2026-10-25 |
Skills from the same repository first, then others for this job by repository stars. Figures are from each repository when we last read it.
Common questions about querying-posthog-data
- What does querying-posthog-data do?
- This repository explains how to choose typed queries or SQL for PostHog data, necessary for using HogQL/SQL or calling execute-sql against PostHog. It covers finding or aggregating PostHog entities such as insights, dashboards, cohorts, and feature flags, as well as trends, funnels, and web analytics. It also guides users to check for approved metric definitions and provides HogQL differences, system table schemas, functions, and query examples.
- How do I install querying-posthog-data?
- Run npx skills add PostHog/skills. The skills installer reads the repository’s own structure, so it works for any repository of agent skills.
- Who publishes querying-posthog-data?
- posthog. It is named as the official skill of PostHog.
- Is querying-posthog-data maintained, and what licence does it use?
- Its repository has 75 GitHub stars and its state in our directory is listed. Its last commit we recorded was on 2026-10-25. The repository declares the MIT licence.
More agent skills for analytics & experiments
- youtube-thumbnail-designby 101-skills
- incremental-implementationby addyosmani
- agent-observability-replay-traceby datadog-labs
- dd-browser-sdkby datadog-labs
- dd-instrument-rumby datadog-labs
- omni-ai-evalby exploreomni