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.
Awesome ClickHouse › Data Visualization and Analysis
TongchengOpenSource/ckibana
CKibana is an open-source project designed to facilitate the visualization and analysis of data stored in ClickHouse using native Kibana interfaces. It acts as a ClickHouse adapter and proxy for Kibana, enabling users to seamlessly query and analyze ClickHouse data with Kibana's powerful visualization tools. This is particularly useful for scenarios where log data, such as nginx logs, are migrated from ElasticSearch to ClickHouse, allowing users to continue their log queries and analysis without disruption. The project supports Kibana versions 6.x and 7.x (up to 7.1.1) and is compatible with common ElasticSearch query syntax, although some limitations exist, such as the need to use querystring syntax for ip_range and date_range queries. CKibana includes advanced features like dynamic sampling to improve query performance, caching of query results using ElasticSearch to speed up repeated queries, and time rounding to reduce query load on ClickHouse by aligning query times. Additional features include a blacklist to prevent complex queries from overloading ClickHouse, query templates for syntax monitoring, and a query circuit breaker to limit maximum query time ranges. The project supports a variety of aggregation functions commonly used in ElasticSearch, such as terms, sum, min, max, avg, percentiles, filters, and cardinality. CKibana can be quickly deployed using Docker Compose, with built-in mock data and pre-configured Kibana dashboards for immediate use. It requires Java JDK 17 or higher and depends on ElasticSearch, ClickHouse, and Kibana services. The project provides detailed documentation and API references to assist with setup and configuration. Overall, CKibana bridges the gap between ClickHouse and Kibana, enabling users to leverage Kibana's visualization capabilities directly on ClickHouse data, improving performance and maintaining compatibility with existing ElasticSearch query patterns.
https://github.com/TongchengOpenSource/ckibana
Also in Data Visualization and Analysis
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.
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.