A self-hosted analytics stack that turns fragmented source systems into one queryable picture — fully owned, no cloud required.
The data existed. It just lived in a dozen systems that couldn't answer a question together.
Every real question — how does enrollment move with contact activity? — meant exporting from one system, wrangling it against another, and hoping the join held. The answer was always late and never repeatable. What was missing wasn't more data; it was one place to ask.
Sources land in PostgreSQL — which also catalogs every source-schema table so nothing goes untracked — then flow into ClickHouse, a columnar store built to answer analytical questions in one pass. Metabase sits on top for dashboards, served through Caddy. The whole stack runs self-hosted via Colima: no cloud bill, no data leaving the institution's hands.
A question that used to take a day of exports now takes a query — and everyone's looking at the same answer.
And it does that without a cloud contract or a vendor holding the institution's data. The infrastructure is quiet, local, and owned — exactly the kind of plumbing that should never be something anyone has to think about.