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
ClickHouse/github-explorer
The ClickHouse/github-explorer project provides a comprehensive dataset derived from the GH Archive, which contains all events from all GitHub repositories since 2011 in a structured format. This extensive dataset, consisting of 3.1 billion records, is stored and managed using ClickHouse, a high-performance analytical database management system. The project redistributes this dataset for research purposes, allowing users to download and explore it to answer a wide range of questions about GitHub activity and trends. The dataset enables detailed analysis of GitHub data, including metrics such as counting stars, identifying top repositories by stars, and examining the distribution of repositories by star count. It also tracks the total number of repositories on GitHub and how the list of top repositories has evolved over the years. Users can analyze the growth of stars over time, understand the demographics of users giving stars, and explore repository affinity lists. Additional insights include finding friends through star counts, affinity based on issues and pull requests, repositories with the most stars in a day, and those with the highest year-over-year growth or stagnation. The project also investigates the best days to catch stars, total GitHub user counts, stars from heavy users, and repositories with the most pull requests, issues, and push access contributors. Further analysis covers repositories with the most accepted invitations, most forked repositories, proportions between stars and forks, issues with the most comments, top commented issues, commits with the most comments, and the toughest code reviews. It highlights authors with the most pushes and code reviews, organizations ranked by stars, repositories, and community size, as well as repositories by modified code and push counts. The project also features unique insights such as top labels, longest and shortest repository names, repositories with ClickHouse-related comments, most popular comments on GitHub, and a fun GitHub roulette feature. This extensive dataset and analysis platform is invaluable for researchers, developers, and analysts interested in understanding GitHub's ecosystem and trends over time.
https://github.com/ClickHouse/github-explorer
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.