Telescope is a web application designed to provide an intuitive interface for exploring log data. It is built to work with any type of logs, as long as they are stored in ClickHouse. Users can easily configure connections to their ClickHouse databases and run queries to filter, search, and analyze logs efficiently. While ClickHouse is the primary supported storage backend, future versions of Telescope may introduce support for additional data sources.

• Telescope @ GitHub.

Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage.

PeerDB is an ETL/ELT tool built for PostgreSQL. We implement multiple Postgres native and infrastructural optimizations to provide a fast, reliable and a feature-rich experience for moving data in/out of PostgreSQL.

• PeerDB @ GitHub.

Related contents:

• Reliably Replicating Data Between PostgreSQL and ClickHouse Part 1 - PeerDB Open Source @ BenjaminWootton.com.

Chproxy is an HTTP proxy and load balancer for ClickHouse.

• Chproxy @ GitHub.

Database schema diagrams visualizer. Open-source database diagrams editor.

Free and open-source database diagrams editor, visualize and design your DB with a single query.

ChartDB is a powerful, web-based database diagramming editor. Instantly visualize your database schema with a single "Smart Query." Customize diagrams, export SQL scripts, and access all features—no account required. Experience seamless database design here.

• ChartDB @ GitHub.

Open source analytics infrastructure. Fast and scalable. No bloat. GDPR compliant.

A single production-ready Docker image built on ClickHouse, Kafka, and Node.js for tracking events, users, page views, and interactions.

• Trench @ GitHub.

Affordable full-stack production debugging & monitoring. Resolve Production Issues, Fast.
An Open Source Observability Platform: Unify Session Replays, Logs, Traces, Metrics and Errors – All Without the Datadog Price Tag.

Resolve production issues, fast. An open source observability platform unifying session replays, logs, metrics, traces and errors powered by Clickhouse and OpenTelemetry.

• HyperDX @ GitHub.
• Monthly Dose of Data - November 2023 @ Data Council.

Real-time, high-performance reading of log files and writing to clickhouse.

This tool can write the monolog standard log directly to clickhouse in real time via the tcp protocol. If you can write regular rules, other standardized log can also support it.

Flow collector, enricher and visualizer.
This program receives flows (currently Netflow/IPFIX and sFlow), enrice them with interface names (using SNMP), geo information (using MaxMind), and exports them to Kafka, then ClickHouse. It also exposes a web interface to browse the collected data.