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, experiments, surveys, LLM analytics, data warehouse, 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.