The first open-source, self-hosted option for warehouse-native product analytics — works directly on your existing data warehouse.
Website · Live Demo · Quick Start · Docs · Contributing
Your events are already in your warehouse. Stop sending them somewhere else. Every SaaS analytics platform makes you re-pipe your data into their system — creating vendor lock-in, duplicating data, and adding cost. stratif.io connects directly to your existing DuckDB, Postgres, Snowflake, or ClickHouse. No ingestion. No pipelines. No data ever leaves your infrastructure.
Open source and self-hosted. No vendor lock-in, no surprise invoices. One install script and you own your analytics stack completely.
Learn product analytics hands-on. stratif.io ships with ~5,000 realistic sample events. Explore funnels, retention, and user journeys without needing your own data — no account, no credit card.
Warehouse-native analytics is a category of tools that run product analysis — funnels, retention, paths — directly on the events already in your data warehouse (DuckDB, Snowflake, ClickHouse, Databricks, Postgres). No ingestion pipeline. No SDK. No duplicate copy of your data in a third-party SaaS.
stratif.io is for you if your product events are already in a SQL warehouse, you want self-hosted funnels, retention, and path analysis on that data, and you don't want to pay per event or hand your data to a SaaS vendor.
stratif.io is not a full-stack replacement for Mixpanel or Amplitude. It does not ship SDKs, experimentation, session replay, or push notifications. If you need those, pair stratif.io with a platform that does event collection, or keep using your current tool for those specific capabilities.
curl -fsSL https://stratif.io/install.sh | shOpen http://localhost:6870 when it's done. For Docker Compose and advanced setup, see docs.stratif.io.
DuckDB · SQLite · PostgreSQL · ClickHouse · Snowflake · Databricks
- Point stratif.io at your database — one row per event, with a timestamp, a user ID, and an event name
- Select your events table — any additional columns are picked up automatically as filterable properties
- Explore funnels, retention, journeys, sessions, and SQL directly in the UI
| stratif.io | Amplitude / Mixpanel | PostHog | Warehouse-native SaaS* | |
|---|---|---|---|---|
| Open source | ✅ | ❌ | ✅ | ❌ |
| Self-hosted | ✅ | ❌ | ✅ | ❌ |
| Warehouse-native (no ingestion) | ✅ | ❌ | ❌ | ✅ |
| No usage-based pricing | ✅ | ❌ | ❌ | ❌ |
| Sample data to learn with | ✅ | ❌ | ❌ | ❌ |
* Mitzu, Kubit, Optimizely (ex-NetSpring), Statsig — all closed-source, cloud-only, paid.
PRs welcome. See CONTRIBUTING.md.
License: Apache-2.0 © Carlo Abi Chahine
Built on the shoulders of giants — React, FastAPI, SQLGlot, shadcn/ui, TanStack Query, Zustand, Recharts, Tailwind CSS.