stratif.io

What the maker publishes

Analytics

Its views include trends, retention, funnels, paths, user profiles, event exploration, pivots, and SQL Studio. source

Analytics views

It includes Trends, Retention, Funnels, User Paths, Pivot, Events, People, and SQL Studio views. source

API authentication

API key authentication can be enabled, requiring requests to include an X-API-Key header. source

Data handling

The maker says stratif.io connects directly to the warehouse, with no ingestion and no data leaving the user's infrastructure. source

Demo

The documentation offers a live demo with a sample e-commerce dataset and says it requires no installation. source

Installation

The project documents a shell install script and a Docker Compose setup for self-hosting. source

Intended users

The maker describes it as intended for teams whose product events are already in a SQL warehouse and who want self-hosted analytics. source

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. source

License

The GitHub repository lists the project under the Apache-2.0 license. source

Limitations

The maker says the product does not include SDKs, experimentation, session replay, or push notifications. source

Live queries

Charts, funnels, and retention tables run live queries against the connected warehouse, and each metric has a SQL viewer. source

Live queries

Charts and analytics views run live queries against the connected warehouse, with no intermediate storage or ingestion delay. source

Product

stratif.io is an open-source product analytics dashboard that queries a data warehouse directly, without event pipelines or per-event pricing. source

Product

stratif.io is an open-source product analytics dashboard that queries event data directly in a data warehouse. source

Query limits

The documented default query timeout is 10 seconds and the default maximum concurrent queries setting is 5; both are configurable. source

Requirements

An events table must provide user_id, event_name, and timestamp fields; properties and traits are optional. source

Schema setup

The expected events table has user_id, event_name, and timestamp fields, with properties and traits optional; field mappings can be configured. source

Security

Warehouse credentials are encrypted at rest using an installation-specific STRATIFIO_ENCRYPTION_KEY. source

Security

Warehouse credentials are encrypted at rest using a configured STRATIFIO_ENCRYPTION_KEY. source

Self-hosting

The maker documents installation on a server or laptop, including a one-line install script and Docker Compose setup. source

SQL transparency

Each metric includes a SQL viewer so users can inspect the query behind it. source

Supported databases

The product lists DuckDB, SQLite, PostgreSQL, ClickHouse, Snowflake, and Databricks as supported databases. source

Warehouses

Documented warehouse options are DuckDB, PostgreSQL, ClickHouse, Snowflake, and Databricks. source

Checked against the maker's pages on 11 Oct 2026.