stratif.io

What it does

Analytics

Its views include trends, retention, funnels, paths, user profiles, event exploration, pivots, and SQL Studio.checked 4 Oct 2026

Analytics views

It includes Trends, Retention, Funnels, User Paths, Pivot, Events, People, and SQL Studio views.checked 11 Oct 2026

API authentication

API key authentication can be enabled, requiring requests to include an X-API-Key header.checked 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.checked 4 Oct 2026

Demo

The documentation offers a live demo with a sample e-commerce dataset and says it requires no installation.checked 4 Oct 2026

Installation

The project documents a shell install script and a Docker Compose setup for self-hosting.checked 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.checked 11 Oct 2026

License

The GitHub repository lists the project under the Apache-2.0 license.checked 4 Oct 2026

Limitations

The maker says the product does not include SDKs, experimentation, session replay, or push notifications.checked 4 Oct 2026

Live queries

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

Product

stratif.io is an open-source product analytics dashboard that queries event data directly in a data warehouse.checked 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.checked 11 Oct 2026

Requirements

An events table must provide user_id, event_name, and timestamp fields; properties and traits are optional.checked 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.checked 11 Oct 2026

Security

Warehouse credentials are encrypted at rest using a configured STRATIFIO_ENCRYPTION_KEY.checked 11 Oct 2026

Self-hosting

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

SQL transparency

Each metric includes a SQL viewer so users can inspect the query behind it.checked 11 Oct 2026

Supported databases

The product lists DuckDB, SQLite, PostgreSQL, ClickHouse, Snowflake, and Databricks as supported databases.checked 4 Oct 2026

Warehouses

Documented warehouse options are DuckDB, PostgreSQL, ClickHouse, Snowflake, and Databricks.checked 11 Oct 2026