// the find
Openpanel-dev/openpanel
OpenPanel is an open-source web and product analytics platform, an open-source alternative to Mixpanel with optional self-hosting.
OpenPanel is a self-hostable product analytics platform targeting the Mixpanel use case: funnels, cohorts, session replay, user profiles, real-time dashboards. The stack is Postgres + ClickHouse + Redis, which is the right call for separating mutable user data from high-volume event storage. Built by a solo developer, actively maintained, cloud-hosted option available.
The dual-database architecture (Postgres for identity/config, ClickHouse for events) is architecturally sound and will actually scale, unlike competitors that try to do everything in one store. SDK coverage is genuinely broad — web, iOS (Swift), Android (Kotlin), React Native, plus server-side SDKs for Python, Ruby, Rust, Java. The MCP server integration (38 tools for querying your analytics via Claude/Cursor) is a clever differentiator that no established player has. Session replay with no artificial monthly cap is a concrete advantage over Mixpanel's 5k/20k limits.
Self-hosting complexity is real: you're standing up Postgres, ClickHouse, Redis, and the app itself — that's four moving parts before you've tracked a single event, and ClickHouse is not trivial to operate at any scale. The project is essentially a one-person operation; the bus factor is 1, which matters if you're building critical analytics infrastructure on top of it. A/B testing is listed as a feature but there's no detail on how variant assignment works or whether it's statistically sound — this is often where analytics tools cut corners. The comparison table in the README is written by the vendor and should be read skeptically; GA4 funnel support is not as limited as implied.