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.
- Glintlog · hn · 2026-02-04 · 10 upvotes · similarity 0.45
- Managed Postgres with native ClickHouse integration · hn · 2026-01-22 · 45 upvotes · similarity 0.43
- The TypeScript Semantic Layer for ClickHouse · hn · 2026-06-27 · 8 upvotes · similarity 0.41
- WaveHouse · hn · 2026-08-20 · 20 upvotes · similarity 0.40
- Oodle · hn · 2025-11-04 · 11 upvotes · similarity 0.39
- BetterDB · hn · 2026-01-23 · 6 upvotes · similarity 0.39
- SensorFlow · ph · 2026-09-27 · 1 upvotes · similarity 0.38
- Dbmask · hn · 2026-09-10 · 5 upvotes · similarity 0.37
Other launches for this product
- No other launches for this product.
Same idea, different domain
Nobody's really built a dev tools tool for Sales yet.