SQL
Query data directly with HogQL
Directly query data stored in PostHog via our SQL transition layer, HogQL. Write custom queries to analyze your data in ways that pre-built insights can't.
Features
Full SQL support
Write complex queries with JOINs, aggregations, and subqueries.
Advanced breakdowns
Group data by multiple columns for detailed analysis.
90+ aggregation functions
Use count, min, max, sum, avg, and about 90 more aggregation functions.
Direct data access
Query raw event data directly without limitations.