unsubbed.co

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