hyperdxio/hyperdx
HyperDX is an open source observability platform powered by Clickhouse and OpenTelemetry that centralizes and correlates logs, metrics, traces, errors, and session replays to help engineers quickly resolve production issues.
Awesome ClickHouse › Metrics and Monitoring
justwatchcom/sql_exporter
The project "justwatchcom/sql_exporter" is a flexible SQL Exporter designed for Prometheus, enabling users to run custom SQL queries at configurable intervals and export the resulting metrics via HTTP for Prometheus to consume. It supports multiple database backends including PostgreSQL, ClickHouse, AWS Athena, MS-SQL, MySQL, Snowflake, Vertica, Materialize, and CloudSQL, with active production use primarily on PostgreSQL. The exporter allows users to define jobs with unique names, intervals or cron schedules, and multiple database connections. It supports executing startup SQL commands and iterating over query results to dynamically generate metrics for multiple databases or other entities. The exporter is designed to integrate seamlessly with Prometheus and Grafana, providing example configurations and dashboards to facilitate monitoring. It supports Prometheus data model requirements by ensuring metrics are floats and labels are strings, with guidance on SQL query construction to meet these needs. The project offers deployment options including running directly via Go, Docker, or Kubernetes, with example configurations provided for each. Additional features include support for running as a non-superuser on PostgreSQL by creating specific views and functions, configurable logging levels, and database-specific configurations for cloud environments like AWS RDS and CloudSQL. The project is open to contributions and aims to support all databases with stable Go drivers. It provides detailed documentation, example configurations, and usage instructions to help users get started quickly and customize their monitoring setup. Overall, this project is a robust and extensible tool for exporting SQL query results as Prometheus metrics, supporting a wide range of databases including ClickHouse, making it valuable for monitoring SQL-based data sources in modern observability stacks.
https://github.com/justwatchcom/sql_exporter
Also in Metrics and Monitoring
uptrace/uptrace
Uptrace is an open source APM platform that uses OpenTelemetry for data collection and ClickHouse for storage, providing unified monitoring of traces, metrics, and logs with powerful querying, dashboards, and alerting capabilities.
openlit/openlit
OpenLIT is an open-source AI engineering platform providing OpenTelemetry-native observability, monitoring, and management tools for large language models, GPUs, and vector databases, with data stored in ClickHouse for efficient telemetry analysis.
openmeterio/openmeter
OpenMeter is a flexible metering and billing platform for AI, API, and DevOps companies that collects and aggregates usage events in real-time to enable usage-based billing and real-time insights.
trickstercache/trickster
Trickster is an open-source HTTP reverse proxy cache and time series dashboard accelerator that improves performance and scalability for time series databases including ClickHouse, Prometheus, and InfluxDB.
metrico/gigapipe
Gigapipe is a lightweight, polyglot observability stack that supports logs, metrics, traces, and profiling with compatibility for Loki, Prometheus, Tempo, Pyroscope, and OpenTelemetry, powered by ClickHouse and Bun for efficient data ingestion and querying.
Swetrix/swetrix
Swetrix is an open source, privacy-focused, cookie-less web analytics platform that uses Clickhouse for efficient statistical data management and offers self-hosting or cloud deployment options.
flant/loghouse
Loghouse is an open-source log management solution for Kubernetes that uses ClickHouse for efficient log storage and provides a web UI for querying and monitoring logs.