Nicheloom

Market intelligence for builders — see what's gaining traction before it's crowded.

Logchef

Open-source schema-agnostic log viewer for ClickHouse

Details

External ID
46356369
Source
HN
Company
—
Product
Logchef
Website domain
logchef.app
Launched
Dec. 22, 2025
Cohort
—
Upvotes
5
Upvotes percentile
0.10400763358778627
Tags
—
Fetched at
Sept. 7, 2026, 9:25 p.m.
Updated at
Sept. 7, 2026, 9:25 p.m.

Description

Hey HN, I'm Karan. I built Logchef because we moved our log workloads to ClickHouse at Zerodha and found the ecosystem lacking for actual log exploration.Tools like Metabase and Grafana are great for dashboards, but log exploration is a different workflow.The Grafana ClickHouse plugin requires manual column configuration for logs, has no field sidebar, and its ad-hoc filters are slow on large tables. Grafana's RBAC is Enterprise-only, and even then it's datasource-level and not at table-level. If someone has access to the ClickHouse datasource, they can query any table. In Logchef, you create Sources (pointing to specific tables) and assign them to Teams. Team A only sees their logs, Team B only theirs. Fine-grained access control without any Enterprise license :)Metabase has no concept of log-specific features at all. We kept falling back to raw SQL in clickhouse-client, which works but isn't something you want to hand to your whole team.So I built Logchef — a log viewer designed specifically for ClickHouse. Schema-agnostic, so you can start filtering immediately without migrations.What it does:- Point at any ClickHouse table – no schema migrations/no OTEL requirement - LogchefQL query language (simpler than SQL for filtering) - Field sidebar like Kibana – click values to add filters - SQL-based alerting that routes to Alertmanager - AI assistant that turns natural language queries like "find slow POST requests" into working SQL - MCP server for querying logs from your favourite LLM assistant tool - Single Go binary (~15MB), embeds the frontendWe've been running this in production for 8 months and I'm excited to ship v1.0 today.Demo: https://demo.logchef.appGitHub: https://github.com/mr-karan/logchefDocs: https://logchef.appHappy to answer questions about ClickHouse for logs, the architecture, or anything else.

Enrichment

Theme
database infrastructure and developer tools
Vertical
Horizontal
Function
Dev tools
Audience
Developer
AI stance
Not AI
Project type
Hobby / open-source project
Normalized one-liner
log viewer for clickhouse without schema
Manually corrected
False

Could you build this?

Partial While the web UI and query runner are standard web engineering, building a high-throughput, schema-agnostic live log streamer with custom query syntax (LogchefQL) and ClickHouse query optimization requires non-trivial log pipeline architecture.

What it would actually take: Built with Go and TypeScript/React. The difficult parts involve writing an efficient parser and transpiler for LogchefQL into ClickHouse SQL, designing dynamic schema detection heuristics over sparse and nested JSON log columns, and implementing memory-efficient WebSocket/SSE streaming for real-time live-tailing against petabyte-scale ClickHouse clusters without overloading database resources.

Discussion

3 comments analyzed.

Competitors mentioned: telescope

Concerns raised: Other ClickHouse observability products impose opinionated schemas, Schema migrations create adoption hurdles for existing ClickHouse datastores

Competitors

Other products that read as similar to this one — 49 launches clear the similarity bar, closest 8 shown.

Attention rank: #49 of 50 (itself plus its competitors, highest first — normalized so YC and Product Hunt are compared fairly).

Launched 51 days after the earliest competitor.

Other launches for this product

Same idea, different domain

Nobody's really built a dev tools tool for Sales yet.