Logchef

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.

Specialized for ClickHouse

Purpose-built interface that leverages ClickHouse’s columnar architecture and analytical capabilities for log exploration.

Dual Query Modes

Simple search syntax for quick exploration, full SQL power when you need it. Built for both beginners and power 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.

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
• 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

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

Try It Out

Visit our demo instance to explore Logchef’s features:

1. Choose your Team
2. Select a Log Source
3. Start querying with Search or SQL mode

Open Source

Logchef is open source software licensed under AGPLv3. We welcome contributions from the community!

View on GitHub • Read Documentation