stratif.io

Spec sheet

Product

stratif.io is an open-source product analytics dashboard that queries event data directly in a data warehouse.Read 11 Oct 2026 · stratif.io

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.Read 11 Oct 2026 · stratif.io

Security

Warehouse credentials are encrypted at rest using a configured STRATIFIO_ENCRYPTION_KEY.Read 11 Oct 2026 · docs.stratif.io

License

The GitHub repository lists the project under the Apache-2.0 license.Read 4 Oct 2026 · github.com

Analytics

Its views include trends, retention, funnels, paths, user profiles, event exploration, pivots, and SQL Studio.Read 4 Oct 2026 · docs.stratif.io

Analytics views

It includes Trends, Retention, Funnels, User Paths, Pivot, Events, People, and SQL Studio views.Read 11 Oct 2026 · stratif.io

API authentication

API key authentication can be enabled, requiring requests to include an X-API-Key header.Read 11 Oct 2026 · docs.stratif.io

Data handling

The maker says stratif.io connects directly to the warehouse, with no ingestion and no data leaving the user's infrastructure.Read 4 Oct 2026 · github.com

Demo

The documentation offers a live demo with a sample e-commerce dataset and says it requires no installation.Read 4 Oct 2026 · docs.stratif.io

Installation

The project documents a shell install script and a Docker Compose setup for self-hosting.Read 11 Oct 2026 · docs.stratif.io

Limitations

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

Live queries

Charts and analytics views run live queries against the connected warehouse, with no intermediate storage or ingestion delay.Read 11 Oct 2026 · docs.stratif.io

Query limits

The documented default query timeout is 10 seconds and the default maximum concurrent queries setting is 5; both are configurable.Read 11 Oct 2026 · docs.stratif.io

Requirements

An events table must provide user_id, event_name, and timestamp fields; properties and traits are optional.Read 4 Oct 2026 · docs.stratif.io

Schema setup

The expected events table has user_id, event_name, and timestamp fields, with properties and traits optional; field mappings can be configured.Read 11 Oct 2026 · docs.stratif.io

Self-hosting

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

SQL transparency

Each metric includes a SQL viewer so users can inspect the query behind it.Read 11 Oct 2026 · docs.stratif.io

Supported databases

The product lists DuckDB, SQLite, PostgreSQL, ClickHouse, Snowflake, and Databricks as supported databases.Read 4 Oct 2026 · github.com

Warehouses

Documented warehouse options are DuckDB, PostgreSQL, ClickHouse, Snowflake, and Databricks.Read 11 Oct 2026 · docs.stratif.io

Where Specifiction places it

• Funnel Analytics#23 of 277.0
• Behavior Analytics#23 of 257.0
• Product Analytics Tools#42 of 457.1