Awesome ClickHouseData Visualization and Analysis

iamtelescope/telescope

⭐ 711 Vue added to this list on 2025-03-09 repository created 2024-12-28

Telescope is a web-based log viewer UI designed to provide an intuitive and unified interface for exploring log data stored primarily in ClickHouse databases, with additional support for Docker container logs. It enables users to create and manage multiple connections to different data sources, configure fields for display and autocompletion, and set user and group permissions with role-based access control (RBAC). The application offers dynamic visualizations and interactive graphs to help users gain insights from their logs, with customizable views, filters, and support for advanced RAW SQL filtering using ClickHouse SQL expressions. Telescope supports authentication via GitHub, including organization membership enforcement, to control access securely. The project is currently in beta, with some features still under development and plans for enhancements such as storing query presets, live log trailing, server-side modifiers, and additional authentication methods. A live demo is available for users to explore core features, and the project encourages contributions from the community. Overall, Telescope aims to simplify and enhance the experience of log data analysis by leveraging ClickHouse's powerful storage capabilities and providing a clean, distraction-free UI for efficient log exploration and management.

https://github.com/iamtelescope/telescope

clickhousedata-visualizationdockergithub-authenticationinteractive-graphslog-analysislog-data-explorationlog-data-sourceslog-filteringlog-insightslog-managementlog-permissionslog-queryinglog-securitylog-storagelog-uiraw-sql-filteringrbacrole-based-access-controltelescopeweb-based-log-viewer

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.

mr-karan/logchef

Logchef is a lightweight, high-performance log analytics platform built on ClickHouse, offering schema-agnostic querying, team-based access control, and easy deployment as a single binary.

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.

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.