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
OpenLabs-so/openanalytics
OpenAnalytics is an open-source, privacy-first web analytics platform distributed as a pnpm monorepo, offered both self-hosted under AGPL-3.0 and as a hosted service at getopen.so. It tracks visitors without cookies or cross-site profiling, exposing only aggregate reads to protect user privacy. The system is split into focused services: a lightweight browser tracker script under a strict byte budget, a collector that validates, sanitizes, rate-limits and enqueues incoming events, and a worker that drains the queue into the analytics store, computing sessions, rollups, exports, mail and deletions. Two databases anchor the architecture: PostgreSQL holds control-plane data such as accounts, sites and configuration, while ClickHouse stores raw events and pre-aggregated rollups for fast analytical queries. Access to ClickHouse is deliberately narrowed to a single query-gateway process that verifies signed query envelopes before executing them, keeping the analytical store isolated from the rest of the system. A realtime service streams live visitor activity to the dashboard over server-sent events, and a Next.js web application renders the dashboard itself. Additional components include a CLI for site setup, statistics and device-flow login, plus shared packages for the domain model, Postgres and ClickHouse migrations, Redis-compatible caching via Valkey, authentication, OpenAPI contracts, observability and integration testing. Feature-wise, OpenAnalytics covers page views, custom and attribute-driven events, sessions, Core Web Vitals, funnels, per-site retention, embeddable widgets, public share links, revenue analytics pulled from a connected Stripe account, CSV/JSON import and export, an MCP server for AI assistants, and the CLI. It targets teams that want Google-Analytics-style reporting without cookies or third-party data sharing, and who are comfortable operating a small self-hosted stack built around ClickHouse for the analytical workload.
https://github.com/OpenLabs-so/openanalytics
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.
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.
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.
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.