The ELK stack, minus the E, the L, and the pain.

ClickHouse already stores and queries logs better than Elasticsearch. What was missing is a UI you actually want to live in. clickpower is that UI, plus a thin ingest layer and alerting, in one container.

Live demo ↗ docker compose up View source

🔍 level:error service:api "deadlock" http.status>=500

13:52:48ERRORdatabase deadlock detected (route=/health)

13:52:46ERRORdatabase deadlock detected (route=/api/cart)

13:52:45WARNslow request /api/orders took 1688ms

13:52:43ERRORdatabase deadlock detected (route=/api/login)

13:52:43INFOPOST /api/search 200 46ms

200 shown · 21 ms · 143,300 rows scanned · 12.6 MB

clickpower Discover: histogram, field sidebar, virtualized log table and detail panel

What you get

Search that compiles to SQL

KQL-style syntax — level:error -host:web-3 http.status>=500 (a OR b) — parsed to an AST and compiled to parameter-bound ClickHouse SQL. Nothing is string-concatenated.

Click-to-filter everything

Field sidebar with top values, JSON detail tree, trace jump, ±1 min context view. Every click edits the query and the URL, so any view is a shareable link.

Raw SQL when you want it

Flip to SQL mode and run anything against a read-only ClickHouse user with a row cap. Query time and rows scanned are always on screen.

Schema-light

Seven core columns plus a native JSON column. Unknown fields like http.status resolve to attributes.http.status automatically.

Bring logs with Vector

Bundled Vector config ships docker, file and syslog logs straight into ClickHouse. JSON-lines and OTLP/HTTP endpoints are on the roadmap.

One dependency

Dashboards, saved searches and alert rules live in ClickHouse too (ReplacingMergeTree). No Postgres, no Redis, no sidecars.

Runs without a server

Set CLICKPOWER_ENGINE=chdb and ClickHouse runs inside the Node process via chDB, against a Parquet fixture. Same SQL, same bound parameters. That is what the live demo is.

Architecture

Vector ─────────────▶ ClickHouse ◀────────▶ clickpower (Next.js: UI + /api/query/*) docker · file · syslog clickpower.logs DSL → SQL, param-bound, readonly user clickpower_meta.* saved searches · dashboards · alerts

Quick start

# demo with a fake-log generator
git clone https://github.com/seongilp/clickpower
cd clickpower
docker compose --profile demo --profile full up --build
# → http://localhost:3000/discover

# local development
docker compose up -d clickhouse
pnpm install && cp .env.example .env.local
pnpm seed -- --backfill=120 --rate=20 --once
pnpm dev