Awesome ClickHouseData Visualization and Analysis

mr-karan/logchef

⭐ 891 Vue repository created 2024-09-25

Logchef is a lightweight, high-performance log analytics platform designed to work seamlessly with ClickHouse, a powerful columnar database. It is distributed as a single binary, simplifying deployment and management for teams needing efficient log storage, querying, and visualization. The platform supports schema-agnostic log exploration, allowing users to query any ClickHouse table without predefined schema constraints, which provides great flexibility in handling diverse log data. Users can perform simple searches or leverage full ClickHouse SQL for advanced log analysis, making it suitable for both casual users and power users who require complex queries. Logchef is optimized for speed and resource efficiency, enabling fast query execution even on large datasets. It supports team-based access control with fine-grained permissions, ensuring secure multi-tenant log access for organizations. The interface is intuitive and modern, offering various views such as explore, collections, teams, users, and source settings, which help users manage and analyze logs effectively. The project provides a Docker Compose setup for quick start, making it easy to deploy and run the platform locally or in production environments. Comprehensive documentation is available on the official website, covering setup, configuration, and API usage. The platform is open-source under the AGPLv3 license, encouraging community contributions and transparency. Logchef is ideal for development teams and organizations looking for a scalable, robust, and user-friendly log analytics solution built on top of ClickHouse's powerful querying capabilities.

https://github.com/mr-karan/logchef

agplv3clickhousedockerhigh-performance-queryinglog-analyticslog-managementmulti-tenantopen-sourceschema-agnosticsingle-binarysql-queriesteam-based-access-controlvisualization

Also in Data Visualization and Analysis

akvorado/akvorado

Akvorado is a flow collector, enricher, and visualizer that processes network flow data, enriches it with interface and geolocation information, and stores it in ClickHouse for real-time analysis and visualization.

clickvisual/clickvisual

ClickVisual is a lightweight log analytics and data visualization platform built on ClickHouse, designed for efficient log querying, analysis, and monitoring.

Altinity/clickhouse-grafana

Altinity/clickhouse-grafana is a Grafana datasource plugin that enables seamless integration and visualization of ClickHouse data within Grafana dashboards.

serenedb/serenedb

SereneDB is a distributed real-time search analytics database that unifies Elasticsearch-like search and ClickHouse-like analytics in a single, Postgres-compatible platform for high performance and ease of use.

iamtelescope/telescope

Telescope is a web-based log viewer UI that enables intuitive exploration and analysis of log data stored primarily in ClickHouse, with support for Docker logs and advanced querying features.

ClickHouse/metabase-clickhouse-driver

A ClickHouse database driver enabling integration with the Metabase business intelligence front-end for data visualization and querying.

ClickHouse/adsb.exposed

An interactive platform for visualizing and analyzing massive ADS-B air traffic data using ClickHouse with real-time querying and detailed visualizations.

mprove-io/mprove

Mprove is an open-source self-service Business Intelligence platform with version control, leveraging ClickHouse for high-performance data analytics and flexible deployment options.