Specialized for ClickHouse
Purpose-built interface that leverages ClickHouse’s columnar architecture and analytical capabilities for log exploration.
Logchef
Purpose-built log analytics UI for ClickHouse
Logchef is a dedicated log query and visualization interface built specifically for ClickHouse. It fills a critical gap in the ClickHouse ecosystem, providing a powerful log explorer without reinventing log collection or storage.
Focus on querying, not ingestion: Logchef intentionally doesn’t handle log collection, relying instead on established tools like Vector, Filebeat, Promtail, or Logstash that already do this job reliably.
Dual Query Modes
Simple search syntax for quick exploration, full SQL power when you need it, and AI-powered natural language to SQL. Built for all users.
Team-Centric
Multi-tenant by design with Teams and Sources. Control who sees what with granular access controls.
Schema Agnostic
Works with any ClickHouse log table structure. No forced migrations or schema changes to your existing setup.
AI-Powered SQL Generation
Translate natural language questions into ClickHouse SQL. Lower the barrier for exploration and speed up query construction. Learn More
Real-time Alerting
Monitor your logs continuously with SQL-based alerts. Integrate with Alertmanager for battle-tested routing to Slack, PagerDuty, email, and more. Learn More
MCP Integration
Model Context Protocol server enables AI assistants like Claude to interact with your logs naturally. Explore MCP
Why ClickHouse for Logs?
ClickHouse’s columnar architecture makes it ideal for log analytics:
- Blazing-fast aggregations over billions of log entries
- Efficient compression dramatically reduces storage costs
- Powerful SQL with analytical extensions for complex log queries
- Column-oriented design optimized for searching specific fields in large datasets
Logchef provides the missing piece: a specialized, user-friendly interface to unlock this potential.
Key Features
Query Your Way
- Simple Search Syntax:
status=200,level="error" AND service="payment-api" - Full SQL Power: Write raw ClickHouse SQL for complex analysis
- AI-Powered Natural Language to SQL: Ask questions in plain English and get SQL queries generated for you. See AI Query Examples.
- MCP Server Integration: Connect AI assistants like Claude to query your logs conversationally. Learn More.
- Collections: Save and organize reusable queries per source for your team
- Smart Field Suggestions: Intelligent field name autocompletion as you type
Team Management
- Multi-tenant Support: Organize users into Teams
- Source Management: Control access to log sources per team
- Granular Permissions: Define who can query what
Flexible Integration
- Any Log Source: Application logs, HTTP logs, system logs - you name it
- Bring Your Own Collection: Works with Vector, Fluentbit, or any tool that can write to ClickHouse
- Schema Agnostic: Use our optimized OTEL schema or your existing table structure
Real-time Alerting
- SQL-Based Conditions: Define alerts using familiar ClickHouse SQL queries
- Alertmanager Integration: Native Prometheus Alertmanager support for routing to Slack, PagerDuty, email, and webhooks
- Delivery Guarantees: Automatic retry logic with exponential backoff ensures alerts reach their destination
- Alert History: Complete audit trail of all alert evaluations, triggers, and resolutions
- Learn More: Check out the alerting documentation for configuration examples
Built for Scale
- ClickHouse Performance: Lightning-fast queries over terabytes of logs
- Resource Efficient: Minimal overhead on top of your ClickHouse instance
- Single Binary: Simple deployment with just one executable
- Production Ready: Used by teams handling millions of log entries daily
- Comprehensive Monitoring: Built-in Prometheus metrics for usage, performance, and health tracking
Try It Out
Visit our demo instance to explore Logchef’s features:
- Choose your Team
- Select a Log Source
- Start querying with Search or SQL mode
Open Source
Logchef is open source software licensed under AGPLv3. We welcome contributions from the community!