CtrlK
BlogDocsLog inGet started
Tessl Logo

querying-posthog-data

Required reading before writing any HogQL/SQL or calling execute-sql against PostHog. Use whenever the user wants to search, find, or do complex aggregations PostHog entities (insights, dashboards, cohorts, feature flags, experiments, surveys, hog flows, data warehouse, persons, etc.) and query analytics data (trends, funnels, retention, lifecycle, paths, stickiness, web analytics, error tracking, logs, sessions, LLM traces). Also the first stop for a governed business number (MRR, activation, revenue): check the semantic layer (canonical metrics in system.information_schema.metrics) for an approved definition before deriving from raw events. Covers HogQL syntax differences from ClickHouse SQL, system table schemas (system.*), available functions, query examples, and the schema-discovery workflow.

74

Quality

92%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Low

Low-risk findings worth noting

SKILL.md
Quality
Evals
Security

Quality

Content

85%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A well-structured, actionable skill body that uses progressive disclosure effectively and sequences its workflows with strong validation checkpoints and feedback loops. The main room for improvement is mild verbosity in the semantic-layer workflow and relying on reference files for complete query examples.

Suggestions

Tighten the semantic-layer workflow prose (e.g., the MarkdownDefinition trust paragraph) to its load-bearing rules so the section reads closer to anchor 5 for conciseness.

Inline one short end-to-end analytics example query in the 'Querying analytics data' section so a reader can execute without first opening a reference file, raising actionability toward 5.

Consider a one-line 'start here' pointer at the top naming the three workflows, so first-time readers land on the right branch faster.

DimensionReasoningScore

Conciseness

Largely lean and assumes Claude's competence ('execute-sql is for discovery, the read tool is for retrieval'), with reference link lists kept as compact indexes; the semantic-layer section is long but load-bearing nuance rather than padding, leaving only minor tightening opportunities. Not a 5 because the business-number workflow could be trimmed slightly without losing essential guidance.

4 / 5

Actionability

Provides concrete, executable guidance — a real SQL example querying system.information_schema.metrics, named tools (posthog:execute-sql, posthog:data-catalog-metric-run), and specific column references (certification on system.information_schema.tables); minor gaps remain because full example queries are deferred to reference files rather than shown inline.

4 / 5

Workflow Clarity

Three clearly numbered workflows with explicit sequencing and validation checkpoints — 'Do this before the first query-* call', 'An empty result means no governed definition exists', 'An unknown-table error means this project has no data catalog' — plus a guarded destructive/batch step (metric creation only after user confirmation, never for one-offs) with clear feedback loops.

5 / 5

Progressive Disclosure

SKILL.md functions as a clear overview pointing to ~45 one-level-deep reference files organized by domain (Data Schema, HogQL References, Analytics Query Examples), each signaled as a markdown link; references verified to exist as real bundle files, with no deep nesting and easy navigation.

5 / 5

Total

18

/

20

Passed

Description

100%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong, specific description that clearly delineates a PostHog query/data-catalog niche, answers both what and when with concrete trigger phrases, and uses natural vocabulary. Minor over-specificity in the entity/feature enumeration slightly lengthens it but does not undermine clarity.

DimensionReasoningScore

Specificity

Lists multiple concrete actions and capabilities — 'writing any HogQL/SQL', 'calling execute-sql', 'search, find, or do complex aggregations', 'check the semantic layer (canonical metrics...)' — plus a 'Covers' clause enumerating syntax differences, system table schemas, functions, examples, and the schema-discovery workflow, giving comprehensive coverage.

5 / 5

Completeness

Explicitly answers both 'what' ('Covers HogQL syntax differences from ClickHouse SQL, system table schemas...') and 'when' ('Use whenever the user wants to search, find...', 'Also the first stop for a governed business number') with concrete trigger phrases.

5 / 5

Trigger Term Quality

Rich natural trigger terms users would actually say — 'search, find', 'aggregations', 'trends, funnels, retention, lifecycle, paths, stickiness', 'MRR, activation, revenue', 'LLM traces' — with strong synonym and domain-vocabulary coverage.

5 / 5

Distinctiveness Conflict Risk

Highly niche PostHog-specific scope (HogQL, system.*, execute-sql) with distinct triggers and minimal overlap risk; written in consistent third person ('Covers', 'Required reading') with no first/second-person voice to penalize.

5 / 5

Total

20

/

20

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

relative_links

Relative link issues: 21 missing

Warning

Total

15

/

16

Passed

Repository
PostHog/posthog
Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.