active

Cortex

The simplest semantic layer for data-driven applications.

the foundation problem

Every analytics tool assumes you already know what to measure.

400+ tools in market. Same 5% of companies served. The gap between "we have data" and "we understand what it means" was wider than any tool could bridge.

Five teams. Five definitions of "monthly revenue." Zero shared language.
Text2SQL gave confident wrong answers. Worse than none.
Better UIs on broken foundations still give confident wrong answers.

metric: Monthly Revenue

Sales team says

$1.2M

src:Salesforce

sql:WHERE closed_won = true

consensus conflict

cortex · semantic layer

definition

{

"metric": "revenue",

"sql": "SUM(amount)",

"time": "invoice_date"

}

connectors

CSV

result...

the semantic layer · open source · MIT

Define a metric once. Every team gets the answer they actually meant.

Metrics, dimensions, and measures defined in JSON. A REST API, a query engine with caching, connectors for Postgres, MySQL, BigQuery, SQLite, CSVs, and Sheets. JSON-first, so AI agents can reason about queries without surgery on a weird DSL.

Runs on your machine, your cluster, or ours. Pick one.
Open source. MIT. Shipping every two weeks.
Build the engine first. The UI is negotiable.

lesson

Build the engine first. The UI is negotiable.

Status

Open source · MIT · shipping every two weeks

Stack

Python

FastAPI

Vue

TypeScript

PostgreSQL

Redis

Docker