Program · Open Source
Data warehouse without the cloud: AI on the client's own infrastructure
The problem. Most data warehouses either send AI queries out to a US-cloud API or skip AI altogether. For a mid-market DACH client with DSGVO constraints, competitive-data sensitivities and licence-cost pressure, neither option works. What we built instead was AI that runs on the warehouse itself, on the client's own infrastructure, with audit trails and no data leaving the building.
The result. Retires per-seat BI and CRM licences,
keeps every AI query inside the building, and gives the business
a documented exit path from its incumbent SaaS.
Under the hood: A read-only
ki_middleware gives local AI safe, audited access to the
warehouse. dlt pipelines ingest CRM, ERP and Excel-controlling
data into a PostgreSQL DWH with thirty-one governed views. Dagster orchestrates, Metabase visualises, and a nightly sync feeds
the open-source CRM. Containerised, ADR-documented, with an
eight-chapter operator handbook and a DSGVO security policy.
Open-source throughout.
The same principle, local AI with no data leaving the building, runs in the open in Throughline, a vendor-neutral memory store for nine AI assistants. PostgreSQL 16 with pgvector again, with no account, no telemetry and no cloud. Beta, 752 tests, MIT licence.