querying-tophog
querying-tophog is a SQL analytics & reporting skill for AI agents, published by PostHog in the posthog repository on GitHub. Skillspace rates querying-tophog D (59/100) and it passed the safety scan; a judge model has also reviewed it.
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.
- Grade
- D
- Quality
- 59 / 100
- Safety
- Passed
- GitHub stars
- 35,560
Placed #1 of 6 in the judged category final for SQL analytics & reporting.
Our two independent classifiers differ on this skill's category, so treat the placement as provisional.
This rating describes the version of the repository we crawled; it may have changed since, so go by its current files.
Our review
- Architecture
- 84 / 100
- Maturity
- Basic: a single SKILL.md
- Security scan
- No issues found
- License
- Not declared. Check the repository before reusing it.
- Adoption
- Adopted by 1 other repositories, in 1 collections
- Scope
- Repo-internal: written for the repository it lives in. PostHog's internal tophog table and internal Metabase access
Judge review
Placed #1 of 6 in the judged category final for SQL analytics & reporting.
- Trigger
88 88 - Instructions
88 88 - Specificity
92 92 - Safety
92 92 - Disclosure
82 82 - Maintenance
85 85
Exemplary internal ops skill that explicitly justifies its per-person SSO access path over standing credentials because the underlying ClickHouse cluster holds customer data.
Not checked yet
- Category is a classifier prediction; no model has read this skill yet
- No blind task eval yet
- Sibling files (scripts, references) not fetched; security scan covers SKILL.md only
Skillspace indexes and rates this skill; it does not host or endorse it. Run third-party skills at your own risk.