PostHog exposes a RESTful HogQL Query API that returns grid-shaped results. Dora connects to it with a personal API key, no Postgres wire protocol needed.
You can browse events, persons, sessions, and groups in the standard data grid, inspect schemas, run ad-hoc HogQL queries, and export results.
PostHog API key
Steps
1.Get your PostHog project API key
In your PostHog instance, go to **Project Settings → Project API Key**. Copy the key that looks like `phx_...`.
2.Choose your region
PostHog Cloud serves US (`us`) and EU (`eu`) regions. The region is shown in your instance URL: `us.posthog.com` or `eu.posthog.com`.
3.Find your project ID
Your project ID is visible in Project Settings. It is a UUID like `018b1234-...`. You will need it together with the API key.
4.Add a PostHog connection in Dora
Open the connection dialog and select **PostHog** from the provider tiles. Paste your API key, select the region, and enter the project ID.
5.Connect and start querying
Click Connect. Dora validates the key with a trivial HogQL query. Once connected, you can browse tables (events, persons, sessions, groups), inspect schemas, and run HogQL queries in the SQL console.
Good to know
- PostHog connections are read-only. Dora queries the HogQL API which does not support writes.
- The API key is stored encrypted on-device and never sent to the frontend.
- Self-hosted PostHog instances are not yet supported, only PostHog Cloud (US or EU region).
- HogQL is similar to SQL but has ClickHouse-specific syntax for arrays, nested data, and time-series functions.