HogQL queries for PostHog

This skill helps you write HogQL queries for PostHog analytics. HogQL is PostHog's SQL dialect, a wrapper around ClickHouse SQL with simplified property access and PostHog-specific functions.

Reference files

• references/expressions.md - Sql expressions - docs
• references/aggregations.md - Supported aggregations - docs
• references/clickhouse-functions.md - Supported clickhouse functions - docs
• references/data-access.md - Accessing data using sql - docs
• references/variables.md - Sql variables - docs
• references/useful-functions.md - Useful sql functions - docs
• references/posthog.md - PostHog table schemas (events, persons, groups, sessions)
• references/sessions.md - Sessions - docs

Consult the documentation for SQL syntax, available functions, and query patterns.

Key principles