querying-tophog

PostHog/posthog

SkillLoads cleanly

Query tophog — the ingestion pipeline's heavy-hitter store in ClickHouse — to identify hot or expensive actors (team_id, distinct_id, session_id, partition)…

Scores
out of 100 · grade A

2026-08-21

Works

40% of the score

100/100

Loads cleanly: valid frontmatter, required fields present, no dangling references.

Maintained

25% of the score

94/100

no commits in the last 12 weeks
no license file

Adopted

20% of the score

63/100

38,059 stars on the source repo.

Documented

15% of the score

81/100

1,021 words with worked examples.

Loads cleanly. Every structural check Claude Code needs to register this passed. Last commit today.

Install

npx skills add PostHog/posthog/querying-tophog

What the check found

Every finding on this listing, and what each one means for whether it loads.
Finding	What it means
No license	The repository ships no license file, so the reuse terms are unclear.

What it says it does

Query tophog — the ingestion pipeline's heavy-hitter store in ClickHouse — to identify hot or expensive actors (team_id, distinct_id, session_id, partition) during incident triage. Use when investigating ingestion lag, a hot or lagging Kafka partition, expensive person processing, merge storms, or any "which team or distinct_id is causing this" question. Covers the internal Metabase access path (SSO via hogli), the tophog schema, and the cost-vs-volume query lens. Internal-only: results contain cross-customer identifiers.

Every number above came out of reading the file and its repository. Nothing is a judgement call, nothing is a model’s opinion, and nothing can be paid for. The full method is published. Source last committed 2026-08-21.

Also in PostHog/posthog

Other artifacts published from the same repository.
Artifact	What the check found	Type	Reach	Last commit
qa-frontendPostHog/posthog	No license	Skill	38k stars	today
qa-teamPostHog/posthog	No license	Skill	38k stars	today
exploring-apm-tracesPostHog/posthog	No license	Skill	38k stars	today
authoring-log-alertsPostHog/posthog	No license	Skill	38k stars	today
adding-personhog-rpcPostHog/posthog	No license	Skill	38k stars	today
writing-evalsPostHog/posthog	No license	Skill	38k stars	today

Other data & analytics skills

Browse all

Same category, same type, ranked by score.
Artifact	What the check found	Category	Reach	Last commit
data-context-extractoranthropics/knowledge-work-plugins	clean	Data & analytics	2,615 installs	today
analyticscoreyhaines31/marketingskills	clean	Data & analytics	51,489 installs	yesterday
build-dashboardanthropics/knowledge-work-plugins	clean	Data & analytics	7,700 installs	today
sql-queriesanthropics/knowledge-work-plugins	clean	Data & analytics	3,764 installs	today
payment-assistantccxt/ccxt	clean	Data & analytics	44k stars	today
create-vizanthropics/knowledge-work-plugins	clean	Data & analytics	4,677 installs	today

Put this measurement in your README

A badge carrying how many listings this index holds from the repository and how many pass every static structural check. It reads from this index every time somebody loads your page, so it changes when the measurement changes and there is nothing to keep up to date. Free, no account, and the value is not something you or we can set by hand.

[![SkillWorks](https://toolproof.kynth.studio/badge/skillworks/PostHog/posthog.svg)](https://skillworks.kynth.studio/?q=PostHog%2Fposthog)

Would rather not hotlink us? Every badge is also served in shields.io’s endpoint schema, so shields renders the image and your readers never talk to our domain:

Published by Toolproof, the masthead over this index and eight others. The method behind the number is at toolproof.kynth.studio/methodology, and the whole thing is readable as JSON with no key at /api.