WaveHouse – Supabase for ClickHouse
Open-source gateway between your frontend and ClickHouse for ingest, caching, and live push.
WaveHouse is a single Apache-2.0 binary that sits between your frontend and ClickHouse: it validates inserts against your live schema, buffers them in a NATS JetStream WAL so writes return instantly and avoid ClickHouse's 'too many parts' errors, then batch-flushes them. It also pushes new rows to subscribers over SSE in real time, gap-filled from history for late-connecting clients, and enforces Hasura-style per-table row/column policies from JWT claims. A TypeScript SDK (~1.4KB gzipped) wraps inserts, queries, and live subscriptions.
What holds up
- +Apache 2.0 and self-hostable — same binary as the managed cloud version, no vendor lock-in.
- +Buffers writes in a WAL and returns 200 OK instantly, avoiding the 'too many parts' errors of direct inserts.
- +Real-time SSE push is gap-filled from JetStream history, so late-connecting clients don't miss events.
Mind the limits
- −Adds another service to run — a binary plus NATS JetStream, not just pointing your frontend at ClickHouse.
- −Built specifically around ClickHouse — doesn't help on a different OLAP database.
Featured here? Take the badge
Put it on your site — it links back to this review. Free for every listed product, always.
<a href="https://stillworks.dev/products/p/wavehouse-supabase-for-clickhouse/"><img src="https://stillworks.dev/badge/wavehouse-supabase-for-clickhouse.svg" alt="Picked by StillWorks" width="250" height="54"></a>