stratif.io

Free plan APILinuxMacSelf-hostedWeb

What stratif.io is

stratif.io is an open-source product analytics dashboard that queries a connected data warehouse directly. It avoids event ingestion and per-event pricing, with views for trends, retention, funnels, user paths, pivots, events, people, and SQL Studio. Charts, funnels, and retention tables run live warehouse queries, and every metric includes a SQL viewer. Documented databases include DuckDB, SQLite, PostgreSQL, ClickHouse, Snowflake, and Databricks. The required events table uses user_id, event_name, and timestamp fields; properties and traits are optional, and mappings can be configured. Installation supports a server or laptop through a shell script or Docker Compose. The maker says data stays in the user’s infrastructure and credentials are encrypted at rest. A no-installation demo is available, and the project uses Apache-2.0.

Who it suits

It is intended for teams whose product events already reside in a SQL warehouse and who want self-hosted analytics. It suits users comfortable configuring databases, deployment, and optional API-key authentication.

What it does well

Direct warehouse querying
Live charts, funnels, and retention
SQL viewer for every metric
Self-hosting with script or Docker Compose
Apache-2.0 open-source license

What to know first

Requires an events table schema
No SDKs or experimentation
No session replay or push notifications
Default query timeout is 10 seconds

Verdict

stratif.io provides warehouse-based analytics with transparent SQL and self-hosting options across several platforms. It is most suitable when events already meet its schema and the listed product limitations are acceptable.

Facts from stratif.io's own pages

Analytics: Its views include trends, retention, funnels, paths, user profiles, event exploration, pivots, and SQL Studio. · docs.stratif.io, 4 Oct 2026
Analytics views: It includes Trends, Retention, Funnels, User Paths, Pivot, Events, People, and SQL Studio views. · stratif.io, 11 Oct 2026
API authentication: API key authentication can be enabled, requiring requests to include an X-API-Key header. · docs.stratif.io, 11 Oct 2026
Data handling: The maker says stratif.io connects directly to the warehouse, with no ingestion and no data leaving the user's infrastructure. · github.com, 4 Oct 2026
Demo: The documentation offers a live demo with a sample e-commerce dataset and says it requires no installation. · docs.stratif.io, 4 Oct 2026
Installation: The project documents a shell install script and a Docker Compose setup for self-hosting. · docs.stratif.io, 11 Oct 2026
Intended users: The site describes the product as built for teams whose product events are already in their data warehouse, rather than teams seeking a full Mixpanel or Amplitude replacement. · stratif.io, 11 Oct 2026
License: The GitHub repository lists the project under the Apache-2.0 license. · github.com, 4 Oct 2026
Limitations: The maker says the product does not include SDKs, experimentation, session replay, or push notifications. · github.com, 4 Oct 2026
Live queries: Charts and analytics views run live queries against the connected warehouse, with no intermediate storage or ingestion delay. · docs.stratif.io, 11 Oct 2026
Product: stratif.io is an open-source product analytics dashboard that queries event data directly in a data warehouse. · stratif.io, 11 Oct 2026
Query limits: The documented default query timeout is 10 seconds and the default maximum concurrent queries setting is 5; both are configurable. · docs.stratif.io, 11 Oct 2026
Requirements: An events table must provide user_id, event_name, and timestamp fields; properties and traits are optional. · docs.stratif.io, 4 Oct 2026
Schema setup: The expected events table has user_id, event_name, and timestamp fields, with properties and traits optional; field mappings can be configured. · docs.stratif.io, 11 Oct 2026
Security: Warehouse credentials are encrypted at rest using a configured STRATIFIO_ENCRYPTION_KEY. · docs.stratif.io, 11 Oct 2026
Self-hosting: The maker documents installation on a server or laptop, including a one-line install script and Docker Compose setup. · docs.stratif.io, 4 Oct 2026
SQL transparency: Each metric includes a SQL viewer so users can inspect the query behind it. · docs.stratif.io, 11 Oct 2026
Supported databases: The product lists DuckDB, SQLite, PostgreSQL, ClickHouse, Snowflake, and Databricks as supported databases. · github.com, 4 Oct 2026
Warehouses: Documented warehouse options are DuckDB, PostgreSQL, ClickHouse, Snowflake, and Databricks. · docs.stratif.io, 11 Oct 2026