Logchef
Logchef is a self-hosted web analytics tool that provides lightweight log analytics platform.
Overview
Lightweight, single-binary log analytics interface for ClickHouse, focused on high-performance querying and visualization Open-source log explorer for ClickHouse A modern, single binary, high-performance log analytics platform The project has 732 GitHub stars and is licensed under AGPL-3.0.
Key Features
Source: GitHub README
- Query-first log exploration: Fast filtering with both LogChefQL and ClickHouse SQL.
- AI Query Assistant: Turn natural language into SQL instantly.
- Real-time alerting: Schedule rules and send email or webhook notifications.
- OIDC + RBAC included: SSO and team-based access out of the box.
- Schema-agnostic: Point at any ClickHouse table without migrations.
- Single binary: One executable, no runtime dependencies.
- Comprehensive metrics: Prometheus metrics for usage and performance.
- MCP integration: Model Context Protocol server for AI assistants (logchef-mcp).
- CLI: Query logs from your terminal with syntax highlighting and multi-context support.
Getting Started
Source: GitHub README
Download the latest release for your platform from GitHub Releases:
## Normalized Features
*Source: tool-features-normalized.json*
ai integration, binary, clickhouse, docker, docker compose, metrics, migration tools, rbac, rest api, sso, webhooks.
<DeploymentOptions slug={frontmatter.slug} /> Features
Authentication & Access
- Role-Based Access Control
- Single Sign-On (SSO)
Integrations & APIs
- REST API
- Webhooks
AI & Machine Learning
- AI / LLM Integration
Import & Export
- Migration Tools
Analytics & Reporting
- Metrics & KPIs
Compare Logchef
Related Analytics & Business Intelligence Tools
View all 176 →Superset
71KApache Superset is an open-source data exploration and visualization platform — connect to any SQL database, build interactive dashboards, and run ad-hoc queries.
OpenBB
63KThe open-source AI workspace for finance — connect proprietary and public data, build custom analytics apps, and deploy AI agents on your own infrastructure.
Metabase
46KOpen-source business intelligence that lets anyone in your company ask questions and learn from data. Build dashboards, run queries, and share insights without SQL.
ClickHouse
46KUltra-fast column-oriented database for real-time analytics. Process billions of rows per second with SQL. Open-source alternative to Snowflake and BigQuery.
Umami
36KSimple, fast, privacy-focused alternative to Google Analytics. Own your website data.
Umami
36KSimple, fast, privacy-focused alternative to Google Analytics. Own your website data.