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.

PostHog is an all-in-one developer platform for building successful products. We provide product analytics, web analytics, session replay, error tracking, feature flags, experimentation, surveys, LLM analytics, data warehouse, a CDP, and an AI product assistant to help debug your code, ship features faster, and keep all your usage and customer data in one stack.