Skip to content

korchasa/awesome-clickhouse

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

91 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Awesome ClickHouse

Note: This repository contains an automatically compiled list of resources, tools, and information related to ClickHouse.

A curated list of awesome ClickHouse software.

Language bindings

C/C++

  • ClickHouse/clickhouse-cpp - ClickHouse/clickhouse-cpp is a C++ client library designed for seamless interaction with the ClickHouse database.
  • RoaringBitmap/CRoaring - CRoaring is a library that implements Roaring bitmaps in C and C++, optimized for high performance with SIMD enhancements.
  • ada-url/ada - Ada is a fast and WHATWG-compliant URL parser library built in modern C++.
  • artpaul/clickhouse-cpp - ClickHouse C++ client library for interacting with the ClickHouse database.
  • simdjson/simdjson - simdjson is a high-performance JSON parsing library that achieves gigabytes of parsing speed per second.

Elixir

  • balance-platform/pillar - Pillar is an Elixir library client for effectively working with ClickHouse, an OLAP database.
  • clickhouse-elixir/clickhouse_ecto - ClickhouseEcto is an Ecto adapter for ClickHouse database implemented in Elixir.
  • clickhouse-elixir/clickhousex - Clickhousex is an Elixir library that enables connections to ClickHouse databases via HTTP.
  • plausible/ecto_ch - Ecto ClickHouse adapter is a library that enables Elixir applications to interact with ClickHouse databases using the Ecto framework.

JavaScript/Typescript

  • ClickHouse/clickhouse-js - This project is the official JavaScript client for ClickHouse DB, designed to facilitate database interactions in both Node.js and web environments.
  • DmitryBe/spark-clickhouse - This project is a connector for integrating Apache Spark with Yandex ClickHouse.
  • TimonKK/clickhouse - A Node.js client library for interacting with ClickHouse using an HTTP interface.
  • apla/node-clickhouse - Node.js driver for interacting with Yandex ClickHouse.
  • itinycheng/flink-connector-clickhouse - Flink ClickHouse Connector is a SQL connector that enables interaction between Flink and ClickHouse databases.
  • subzerocloud/showcase - subZero is a library for creating customizable REST APIs on top of various databases like PostgreSQL, SQLite, MySQL, and ClickHouse.
  • zimv/node-clickhouse-orm - A ClickHouse ORM for Node.js that simplifies database interactions through an HTTP interface.

Golang

  • AfterShip/clickhouse-sql-parser - A Go library and CLI tool for parsing ClickHouse SQL into an Abstract Syntax Tree (AST) and beautifying SQL format.
  • ClickHouse/ch-go - A low-level TCP client for the ClickHouse database implemented in Go.
  • ClickHouse/clickhouse-go - This project is a Golang driver for ClickHouse, providing a way to interact with ClickHouse databases.
  • chdb-io/chdb-go - chdb-go is a Go bindings library and command-line interface for chDB, an OLAP SQL engine powered by ClickHouse.
  • mailru/go-clickhouse - The go-clickhouse is a Golang SQL database driver for efficiently interfacing with Yandex ClickHouse.
  • roistat/go-clickhouse - go-clickhouse is a Golang connector designed to interface with the Yandex ClickHouse database.
  • runreveal/pql - PQL is a Go library that compiles a pipelined-based query language into SQL, primarily tested with Clickhouse.
  • springrain/zorm - ZORM is a lightweight ORM library for Go that supports multiple databases including DM, Kingbase, MySQL, and PostgreSQL.
  • uptrace/go-clickhouse - Golang ClickHouse client providing a native protocol interface and an API compatible with database/sql.
  • vahid-sohrabloo/chconn - A low-level ClickHouse database driver for Golang that prioritizes performance and efficient database interactions.

Java

.Net

  • DarkWanderer/ClickHouse.Client - ClickHouse.Client is a .NET ADO.NET client for the ultra-fast ClickHouse database.
  • DotNetNext/SqlSugar - SqlSugar is a user-friendly ORM framework for .NET that facilitates database interactions with minimal code.
  • Octonica/ClickHouseClient - ClickHouse .NET Core driver that implements the ADO.NET DbProvider API for database interactions.
  • ilyabreev/ClickHouse.Net - ClickHouse.Net is a .NET Core library providing abstractions and helpers for Clickhouse.Ado.

ODBC

  • ClickHouse/clickhouse-odbc - This project is an ODBC driver for ClickHouse that allows applications to access ClickHouse databases seamlessly.

PHP

Python

  • ClickHouse/clickhouse-connect - ClickHouse Connect is a Python driver that connects ClickHouse to Python, Pandas, and Superset.
  • Infinidat/infi.clickhouse_orm - A Python library for working with the ClickHouse database.
  • carrotquest/django-clickhouse - This project aims to seamlessly integrate the Yandex ClickHouse database into Django applications.
  • cloudflare/sqlalchemy-clickhouse - This project provides a ClickHouse dialect for SQLAlchemy, allowing for seamless integration of ClickHouse and Python applications.
  • ibis-project/ibis - Ibis is a portable Python dataframe library designed for efficient data manipulation and exploration.
  • jayvynl/django-clickhouse-backend - A Django backend for the ClickHouse database that allows for seamless interaction using Django ORM.
  • kszucs/pandahouse - Pandahouse is a Pandas interface for the Clickhouse database that simplifies database interactions through Python.
  • long2ice/asynch - An asyncio ClickHouse Python Driver with native (TCP) interface support.
  • maximdanilchenko/aiochclient - Aiochclient is a lightweight async HTTP client for Python that facilitates interaction with ClickHouse while supporting type conversion.
  • mymarilyn/aioch - aioch is a library for accessing a ClickHouse database over native interface from the asyncio.
  • mymarilyn/clickhouse-driver - This project is a Python driver for ClickHouse that supports a native TCP interface.
  • tobymao/sqlglot - SQLGlot is a Python library that serves as a no-dependency SQL parser and transpiler supporting multiple SQL dialects.
  • xzkostyan/clickhouse-sqlalchemy - ClickHouse dialect for SQLAlchemy.

R

  • IMSMWU/RClickhouse - RClickhouse is an R package that provides a DBI interface to the Clickhouse database with basic dplyr support.

Ruby

Rust

Scala

Other sdk/libraries

UIs

GUI

  • ClickHouse/click-ui - Click UI is a design system and component library for ClickHouse, aimed at providing UI components for application development.
  • CodePhiliaX/Chat2DB - Chat2DB is an AI-driven database tool and SQL client that supports various database engines.
  • caioricciuti/ch-ui - CH-UI is a user-friendly interface for managing data from ClickHouse databases.
  • metrico/clickhouse-mate - ClickHouse-Mate is an advanced user interface for ClickHouse that enhances SQL query management through autocompletion and efficient navigation.
  • timeseries/qstudio - qStudio is a free SQL analysis tool that offers a graphical interface for browsing databases, executing SQL queries, and visualizing the results.

CLI

CHUI(Chat-based User Interface) or CHUBACA(Chat-Based Client:)

  • plmercereau/chat-dbt - Chat-DBT facilitates human-like interaction with databases through OpenAI GPT, allowing natural language queries.
  • sqlchat/sqlchat - SQL Chat is a chat-based SQL client that allows users to interact with databases using natural language commands.

Integrations

Data Transfer and Synchronization

  • Altinity/clickhouse-mysql-data-reader - The clickhouse-mysql-data-reader is a utility tool that enables the reading of data from MySQL databases.
  • ClickHouse/clickpy - ClickPy is a Python package analytics service powered by ClickHouse that provides insights into download statistics and package adoption.
  • ITECOMMPAY/kibouse - Kibouse is an adapter tool that connects Clickhouse with Kibana for enhanced analytics and visualization of logs.
  • Infinidat/infi.clickhouse_fdw - A PostgreSQL foreign data wrapper for ClickHouse.
  • Percona-Lab/PromHouse - PromHouse is a long-term remote storage solution for Prometheus 2.x built on top of ClickHouse, featuring clustering and downsampling capabilities.
  • Percona-Lab/clickhousedb_fdw - clickhousedb_fdw is an open-source Foreign Data Wrapper that allows PostgreSQL servers to interact with ClickHouse databases.
  • QuesmaOrg/quesma - Quesma is a programmable database gateway that facilitates smooth migrations between different database platforms.
  • azat/chdig - Chdig is a terminal user interface tool for efficient introspection of ClickHouse databases.
  • cloudflare/flow-pipeline - A set of tools and examples to run a flow-pipeline for collecting and processing sFlow and NetFlow data.
  • copybird/copybird - Copybird is a cloud-native universal backup tool for databases and files.
  • devlive-community/datacap - DataCap is an integrated software for data transformation, integration, and visualization.
  • go-graphite/carbon-clickhouse - Carbon-clickhouse is a Graphite metrics receiver that stores metrics in ClickHouse.
  • growthbook/growthbook - GrowthBook is an open-source platform for feature flagging and A/B testing.
  • ildus/clickhouse_fdw - clickhouse_fdw is a Foreign Data Wrapper allowing PostgreSQL users to access and query data stored in ClickHouse.
  • jneo8/clickhouse-setup - A tutorial for setting up a ClickHouse server both in single and clustered configurations using Docker.
  • kobsio/klogs - klogs is a fast and reliable tool for logging that integrates Fluent Bit with ClickHouse.
  • meteroid-oss/meteroid - Meteroid is an open-source billing infrastructure aimed at streamlining subscription management and invoicing for SaaS applications.
  • metrico/fluXpipe - FluxPipe is a standalone serverless Flux API for querying and interacting with remote data such as InfluxDB 3.0 and ClickHouse.
  • metrico/quackpipe - QuackPipe is an OLAP API built on top of DuckDB with additional compatibility for ClickHouse.
  • mintance/nginx-clickhouse - This project is a simple NGINX logs parser that transports log data to a ClickHouse database.
  • openblocks-dev/openblocks - Openblocks is an open-source platform designed as an alternative to Retool for building internal applications and tools quickly.
  • openmeterio/openmeter - OpenMeter provides a cloud metering solution for AI and billing, facilitating real-time collection and aggregation of usage data.
  • plausible/analytics - Plausible Analytics is a simple yet powerful open source web analytics tool that emphasizes privacy and easy usability.
  • prismelabs/analytics - Prisme Analytics is an open-source and privacy-focused analytics service that simplifies data collection and reporting.
  • synmetrix/synmetrix - Synmetrix is a production-ready open source semantic layer on Cube for managing metrics data.
  • timeplus-io/proton - Timeplus Proton is a fast and lightweight streaming SQL engine powered by ClickHouse.
  • trickstercache/trickster - Trickster is an open-source HTTP reverse proxy cache that enhances the performance of web applications and time series databases.
  • zerodha/dungbeetle - A distributed job server designed for queuing and executing heavy SQL read jobs asynchronously.

Metrics and Monitoring

  • ClickHouse/clickhouse_exporter - ClickHouse Exporter is a server that scrapes ClickHouse stats and exports them for Prometheus.
  • burningalchemist/sql_exporter - The SQL Exporter is a configuration driven tool for exposing metrics from various DBMSs for Prometheus.
  • hyperdxio/hyperdx - HyperDX is an open-source observability platform that aggregates logs, metrics, traces, exceptions, and session replays to quickly resolve production issues.
  • justwatchcom/sql_exporter - Flexible SQL Exporter for Prometheus that runs user-defined SQL queries and exports metrics for monitoring.
  • metrico/qryn - qryn is an all-in-one polyglot observability stack that handles logs, metrics, traces, and profiling, providing a drop-in alternative to Grafana Cloud.
  • openlit/openlit - OpenLIT provides complete observability and evaluations for the entire GenAI stack, enabling developers to improve LLM applications from development to production.
  • pinba-server/pinba-server - Pinba-server is a simple and fast metrics server for PHP applications that stores data in ClickHouse.
  • uptrace/uptrace - Uptrace is an open source APM that enables monitoring of application performance using OpenTelemetry traces, metrics, and logs.

Deployment and Management Tools

  • Altinity/altinity-dashboard - Altinity Dashboard helps you manage ClickHouse installations controlled by clickhouse-operator.
  • Altinity/clickhouse-backup - A tool for easy backup and restore for ClickHouse databases using object storage.
  • Altinity/clickhouse-operator - Altinity Kubernetes Operator for ClickHouse manages ClickHouse clusters on Kubernetes.
  • ByConity/ByConity - ByConity is an open-source cloud data warehouse that builds upon ClickHouse, offering advanced features for data management and querying.
  • Canner/vulcan-sql - VulcanSQL is an Analytical Data API Framework for rapidly creating APIs from diverse data sources.
  • ClickHouse/clickhouse-kafka-connect - The clickhouse-kafka-connect is the official Kafka Connect sink connector for ClickHouse that facilitates data delivery from Kafka topics to ClickHouse tables.
  • ClickHouse/spark-clickhouse-connector - This project provides a Spark ClickHouse Connector built on the DataSourceV2 API.
  • ContentSquare/chproxy - Chproxy is an open-source HTTP proxy and load balancer for the ClickHouse database.
  • DataflareApp/Dataflare - Dataflare is a simple and intuitive database manager designed for managing and querying various databases.
  • HouseOps/HouseOps - HouseOps is a simple and effective UI for managing and monitoring ClickHouse databases.
  • PostHog/charts-clickhouse - Helm chart for deploying PostHog with ClickHouse on your K8s infrastructure.
  • apache/incubator-gluten - Gluten is a project designed to optimize execution speed by offloading JVM-based SQL engine processes to native engines.
  • aws-samples/aws-lambda-clickhouse - This project enables the execution of ClickHouse queries within an AWS Lambda environment.
  • bytebase/bytebase - Bytebase is an advanced DevSecOps solution designed for enhancing database management across various teams.
  • chdb-io/chdb - chDB is an in-process SQL OLAP Engine powered by ClickHouse that allows efficient querying of data.
  • devlive-community/dbm - DBM is an open-source database management system that supports various SQL-speaking databases.
  • flant/loghouse - Loghouse is a ready-to-use log management solution for Kubernetes that leverages ClickHouse for log storage and provides a web UI for monitoring.
  • frectonz/sql-studio - SQL Studio is a single command SQL database explorer that supports multiple databases including SQLite, PostgreSQL, and ClickHouse.
  • getlago/lago - Lago is an open-source API for metering and usage-based billing.
  • go-graphite/graphite-clickhouse - A backend integrating Graphite with ClickHouse for enhanced monitoring capabilities.
  • jaegertracing/jaeger-clickhouse - Jaeger ClickHouse is a storage plugin implementation for storing traces within the ClickHouse database.
  • l1xnan/duckling - Duckling is a fast viewer application for CSV and Parquet files and various databases, developed with Tauri.
  • mindis/prom2click - Prom2click is a Prometheus remote storage adapter for ClickHouse that facilitates scalable metrics storage.
  • mprove-io/mprove - Mprove is an open-source self-service business intelligence tool with version control capabilities.
  • myscale/MyScaleDB - MyScaleDB is an open-source SQL vector database built on ClickHouse for scalable AI application development.
  • plutov/clickhouse-helm - This project provides a Helm Chart for deploying a replicated ClickHouse environment in Kubernetes.
  • red-soft-ru/clickhouse-rpm - This project is a ClickHouse DBMS build script for RHEL based distributions.
  • tabixio/tabix - Tabix is an open-source business intelligence application and SQL editor tool specifically tailored for Clickhouse.
  • tetafro/clickhouse-cluster - A simple ClickHouse cluster setup using Docker Compose, featuring two shards and two replicas.

Data Visualization and Analysis

  • Altinity/clickhouse-grafana - Altinity Grafana datasource plugin enables effective integration of ClickHouse with Grafana for data visualization.
  • ClickHouse/ClickHouse - ClickHouse® is a real-time analytics DBMS that allows generating analytical data reports instantly.
  • ClickHouse/adsb.exposed - The ADS-B Massive Visualizer enables interactive visualization and analytics of air traffic data using ClickHouse.
  • ClickHouse/github-explorer - GitHub Explorer is a project that offers a detailed dataset for analyzing GitHub events since 2011 to facilitate research and provide insights.
  • ClickHouse/graphouse - Graphouse allows users to utilize ClickHouse as storage for Graphite metrics.
  • ClickHouse/pastila - This project is a paste service built on top of ClickHouse, allowing users to share and store text data seamlessly.
  • PostHog/HouseWatch - HouseWatch is an open-source tool for monitoring and managing ClickHouse clusters.
  • Slach/clickhouse-flamegraph - Clickhouse-flamegraph is a CLI utility for visualizing ClickHouse system.trace_log as flamegraphs.
  • Swetrix/swetrix - Swetrix is a cookie-less, open-source web analytics service that prioritizes user privacy.
  • TongchengOpenSource/ckibana - CKibana is a ClickHouse adapter for Kibana, enabling data visualization and analysis using Kibana's native features.
  • akvorado/akvorado - Akvorado is a flow collector, enricher, and visualizer that processes and displays network flow data.
  • benawad/voidpulse - Voidpulse is an open-source, AI-driven analytics platform designed as a cost-effective alternative to Mixpanel.
  • bytedance/Jeddak-DPSQL - DPSQL is a microservice that provides privacy protection for SQL queries, enabling secure data analysis between databases and applications.
  • clickcat-project/ClickCat - ClickCat is a user-friendly interface that allows you to search, explore, and visualize your ClickHouse data.
  • clickvisual/clickvisual - ClickVisual is a browser-based platform for log analytics and data visualization built on ClickHouse.
  • cyber-drop/ethereum_analytical_db - This project is an Ethereum Analytical Database that provides a solution for accessing and analyzing Ethereum data using ClickHouse.
  • datainsider-co/rocket-bi - Rocket BI is a web-based self-service business intelligence tool designed for analytical databases including ClickHouse.
  • duyet/clickhouse-monitoring - A simple UI for monitoring ClickHouse using a dashboard built with Next.js.
  • grafana/clickhouse-datasource - Official Grafana plugin for querying and visualizing ClickHouse data.
  • lodthe/clickhouse-playground - ClickHouse Playground allows users to run SQL queries easily from their browser without needing a local database instance.

ETL and Data Processing

  • Altinity/clickhouse-sink-connector - Altinity Sink Connector enables automated data replication from MySQL, PostgreSQL, and MongoDB to ClickHouse.
  • Canner/WrenAI - Wren AI is an open-source SQL AI Agent that allows users to interact with various data sources using natural language queries.
  • ClickHouse/dbt-clickhouse - The Clickhouse plugin for dbt (data build tool) enables data transformation functionalities integrated with ClickHouse.
  • PeerDB-io/peerdb - PeerDB is a fast and efficient ETL tool designed to replicate data from Postgres to various storage solutions.
  • Quiq/influxdb-tools - InfluxDB Tools provides scripts for backing up InfluxDB data, migrating it to ClickHouse, and restoring data using the InfluxDB HTTP API.
  • VaBezruchko/spark-clickhouse-connector - The Spark Clickhouse Connector integrates Apache Spark with Yandex Clickhouse for efficient data processing and management.
  • amacneil/dbmate - Dbmate is a lightweight and framework-agnostic tool designed for database migration.
  • bryzgaloff/airflow-clickhouse-plugin - A popular ClickHouse plugin for Apache Airflow that facilitates seamless execution of queries with rich functionality.
  • delium/clickhouse-migrator - Clickhouse Migrator is an easy-to-use data migration tool designed for the ClickHouse database.
  • droher/boxball - Boxball provides prebuilt Docker images with comprehensive baseball history data for analytical frameworks.
  • eabz/evm-indexer - A scalable SQL indexer for EVM-compatible blockchains.
  • easysql/easy_sql - Easy SQL is a library that simplifies the ETL development process using SQL.
  • getdozer/dozer - Dozer is a real-time data movement tool that leverages Change Data Capture (CDC) from various sources to move data into various sinks.
  • housepower/clickhouse_sinker - clickhouse_sinker is a tool that facilitates the easy loading of data from Kafka into ClickHouse.
  • jitsucom/bulker - Bulker is a tool for streaming and batching large amounts of semi-structured data into data warehouses.
  • jitsucom/jitsu - Jitsu is an open-source tool that acts as an alternative to Segment for collecting event data and streaming it to data warehouses.
  • larsnovikov/horgh-replicator - This project is a Golang-based tool for binlog replication from MySQL to multiple databases, including PostgreSQL and ClickHouse.
  • long2ice/synch - Synch is a data synchronization tool that allows seamless transfer of data from other databases to ClickHouse.
  • nikepan/clickhouse-bulk - ClickHouse-Bulk is a tool for collecting and sending multiple small inserts to ClickHouse as larger batch inserts.
  • ozontech/file.d - file.d is a fast and flexible tool for building data pipelines to efficiently read, process, and output events.
  • scottpersinger/pgwarehouse - pgwarehouse is a tool that facilitates the synchronization of data from a Postgres database to cloud data warehouses such as Snowflake and ClickHouse.
  • scratchdata/scratchdata - Scratch Data is a versatile tool for streaming data into and out of analytics databases.
  • toddwschneider/nyc-taxi-data - A project that provides scripts to process and analyze NYC taxi and for-hire vehicle trip data using PostgreSQL and ClickHouse.
  • uber/storagetapper - StorageTapper is a scalable real-time MySQL change data streaming, logical backup, and replication service.
  • wgzhao/Addax - Addax is a versatile open-source ETL tool that can seamlessly transfer data between various RDBMS and NoSQL databases, making it an ideal solution for data migration.
  • ytsaurus/ytsaurus - YTsaurus is a scalable and fault-tolerant open-source big data platform that facilitates distributed storage and processing.
  • zeromicro/cds - ClickHouse Data Synchromesh is a Go-based tool designed for real-time data syncing from MySQL and MongoDB to ClickHouse.
  • zlzforever/ClickHouseMigrator - ClickHouseMigrator is a tool that helps to migrate data to ClickHouse and automate database and table creation.

Ops

  • adminerevo/adminerevo - AdminerEvo is a database management tool built in a single PHP file that supports various database systems.
  • housepower/ckman - ckman is a tool designed for managing and monitoring ClickHouse databases.

Documentation

  • Altinity/clickhouse-rpm-install - A guide for installing ClickHouse RPM packages from Altinity's repositories.
  • ClickHouse/clickhouse-docs - This repository contains the official documentation for ClickHouse.
  • ClickHouse/clickhouse-presentations - This project provides presentations, meetups, and talks about ClickHouse, an open-source database management system.
  • Onelinerhub/onelinerhub - Onelinerhub is a collection of thousands of code solutions with clear explanations aimed at educating developers.
  • dubinc/dub - Dub.co is an open-source link management infrastructure designed for modern marketing teams.
  • smi2/clickhouse-frontend - This project serves as a redirection to the previously known TABIX, focusing on its documentation and resources.
  • tinybirdco/clickhouse_knowledge_base - The Tinybird ClickHouse Knowledge Base is a curated resource aimed at sharing knowledge and fostering community engagement around ClickHouse.

Examples

Community and support

  • Telegram - Telegram is a channel for discussions and updates about ClickHouse.
  • Twitter - Official Twitter account for ClickHouseDB providing updates and community interactions.

License

About

A curated list of awesome ClickHouse software.

Topics

Resources

License

Stars

Watchers

Forks