xiedeyantu/awesome-clickhouse

A curated list of awesome ClickHouse software.

Awesome ClickHouse

Table of Contents

• Documentation
• Language bindings
• Integrations
• CLI
• GUI
• Ops
• Examples
• Social
• License

A curated list of awesome ClickHouse (sources) software.

Documentation

• Official docs

• Changelog

• clickhouse-presentations - Presentations, meetups and talks for ClickHouse

Language bindings

• C++:

  • artpaul/clickhouse-cpp - ClickHouse C++ client library

  • ClickHouse/clickhouse-cpp - C++ client library for ClickHouse

• Elixir:

  • balance-platform/pillar - Elixir library client for work with ClickHouse

  • clickhouse-elixir/clickhouse_ecto - Ecto adapter for ClickHouse database

  • clickhouse-elixir/clickhousex - Elixir lib to work with ClickHouse database

• GO:

  • https://github.com/ClickHouse/ch-go [ClickHouse/ch-go] - Low-level Go Client for ClickHouse

  • ClickHouse/clickhouse-go - Golang driver for ClickHouse

  • go-faster/ch - clickhouse client (wip)

  • gorose - GoRose(go orm), a mini database ORM for golang

  • kshvakov/clickhouse - Golang SQL database driver for Yandex ClickHouse

  • leprosus/golang-clickhouse - Golang Yandex ClickHouse connector

  • mailru/go-clickhouse - Golang SQL database driver for Yandex ClickHouse

  • roistat/go-clickhouse - Golang ClickHouse connector

  • uptrace/go-clickhouse - ClickHouse client for Go

  • vahid-sohrabloo/chconn - Low-level ClickHouse database driver for Golang

• Java:

  • JiamingMai/clickhouse-ast-parser - AST parser and visitor for ClickHouse SQL

  • x-ream/sqli - orm sql interface, Criteria, CriteriaBuilder, ResultMapBuilder

• JDBC:

  • analytikaplus/clickhouse-tableau-connector-jdbc - Tableau connector to ClickHouse using JDBC driver

  • blynkkk/clickhouse4j - Lighter and faster alternative for the official ClickHouse JDBC driver

  • clickhouse-jdbc - JDBC driver for ClickHouse

  • housepower/ClickHouse-Native-JDBC - ClickHouse Native Protocol JDBC implementation

• Kotlin:

  • TanVD/AORM - Clickhouse Kotlin SQL Framework

• .Net:

  • DarkWanderer/ClickHouse.Client - .NET client for ClickHouse

  • dotnetcore/FreeSql - 🦄 .NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, Click house orm, MsAccess orm

  • killwort/ClickHouse-Net - Yandex ClickHouse fully managed .NET client

  • Octonica/ClickHouseClient - ClickHouse .NET Core driver

• Node.js:

  • apla/node-clickhouse - Yandex ClickHouse driver for nodejs

  • TimonKK/clickhouse - NodeJS client for ClickHouse

• ODBC:

  • yandex/clickhouse-odbc - ODBC driver for ClickHouse

• PHP:

  • 8bitov/clickhouse-php-client - PHP Driver for ClickHouse

  • FriendsOfDoctrine/dbal-clickhouse - Doctrine DBAL driver for ClickHouse database

  • lizhichao/one-ck - php tcp client for clickhouse

  • pinba-server/pinba-server - pinba server with storage in clickhouse

  • sanchezzzhak/kak-clickhouse - Yii2 ext. ClickHouse

  • phpClickHouse - PHP ClickHouse wrapper

  • the-tinderbox/ClickhouseBuilder - Clickhouse Query Builder

• Python:

  • carrotquest/django-clickhouse - django-clickhouse

  • sqlalchemy-clickhouse - ClickHouse dialect for SQLAlchemy

  • Infinidat/infi.clickhouse_orm - A Python library for working with the ClickHouse database

  • kszucs/pandahouse - Pandas interface for Clickhouse database

  • long2ice/asynch - An asyncio ClickHouse Python Driver with native (TCP) interface support

  • maximdanilchenko/aiochclient - Lightweight async http(s) ClickHouse client for python 3.6+ with types converting

  • mymarilyn/aioch - aioch - is a library for accessing a ClickHouse database over native interface from the asyncio

  • clickhouse-driver - ClickHouse Python Driver with native interface support

  • xzkostyan/clickhouse-sqlalchemy - ClickHouse dialect for SQLAlchemy

• R:

  • hannesmuehleisen/clickhouse-r - Rstats client for ClickHouse (https://clickhouse.yandex)

  • IMSMWU/RClickhouse - A 'DBI' Interface to the Yandex Clickhouse Database Providing Basic 'dplyr' Support

• Ruby:

  • archan937/clickhouse - A Ruby database driver for Clickhouse

  • PNixx/clickhouse-activerecord - A Ruby database ActiveRecord driver for ClickHouse

  • shlima/click_house - Modern Ruby database driver for ClickHouse

• Rust:

  • loyd/clickhouse.rs - A typed client for ClickHouse

  • suharev7/clickhouse-rs - Tokio based asynchronous ClickHouse client library for rust programming language.

• Scala:

  • crobox/clickhouse-scala-client - Clickhouse Scala Client with Reactive Streams support

Integrations

• adjust/clickhouse_fdw - ClickHouse FDW for PostgreSQL. Forked from: https://github.com/Percona-Lab/clickhousedb_fdw

• Altinity/clickhouse-grafana - Clickhouse datasource for grafana

• Altinity/clickhouse-mysql-data-reader - utility to read mysql data

• ClickHouse/clickhouse-jdbc-bridge - A JDBC proxy from ClickHouse to external databases

• graphouse - Graphouse allows you to use ClickHouse as a Graphite storage

• clickvisual/clickvisual - A light weight log visual analytic platform for clickhouse.

• cloudflare/flow-pipeline - A set of tools and examples to run a flow-pipeline (sFlow, NetFlow)

• ContentSquare/chproxy - ClickHouse http proxy and load balancer

• metabase-clickhouse-driver - Metabase driver for the ClickHouse database

• loghouse - Ready to use log management solution for Kubernetes storing data in ClickHouse and providing web UI

• gmmstrive/flink-connector-clickhouse - flink sql connector clickhouse zeppelin

• go-graphite/carbon-clickhouse - Graphite metrics receiver with ClickHouse as storage

• go-graphite/graphite-clickhouse - Graphite cluster backend with ClickHouse support

• housepower/clickhouse_sinker - Easily load data from kafka to ClickHouse with high performance

• housepower/spark-clickhouse-connector - Spark ClickHouse Connector build on DataSourceV2 API and gRPC protocol.

• ibis-project/ibis - Expressive analytics in Python, whatever the scale.

• ITECOMMPAY/kibouse - Clickhouse adapter for Kibana

• itinycheng/flink-connector-clickhouse - Flink SQL connector for ClickHouse. Support ClickHouseCatalog and read/write primary data, maps, arrays to clickhouse.

• ivi-ru/flink-clickhouse-sink - Flink sink for Clickhouse

• jaegertracing/jaeger-clickhouse - Jaeger ClickHouse storage plugin implementation

• jaykelin/clickhouse-hdfs-loader - loading hdfs data to clickhouse

• justwatchcom/sql_exporter - Flexible SQL Exporter for Prometheus.

• lmangani/cLoki - Clickhouse Loki: Grafana Loki API + ClickHouse Backend in NodeJS

• carbon-clickhouse - Graphite metrics receiver with ClickHouse as storage

• lomik/graphite-clickhouse - Graphite cluster backend with ClickHouse support

• metrico/qryn - LogQL on top of ClickHouse (formerly c₤oki)

• mintance/nginx-clickhouse - Simple nginx logs parser & transporter to ClickHouse database

• pg2ch - Data streaming from postgresql to clickhouse via logical replication mechanism

• clickhousedb_fdw - PostgreSQL’s Foreign Data Wrapper For ClickHouse

• PromHouse - Long-term remote storage with built-in clustering and downsampling for Prometheus 2.x on top of ClickHouse

• Quiq/influxdb-tools - InfluxDB Tools

• QXIP/cloki-go-legacy - Clickhouse Loki API in GO (WIP)

• QXIP/cloki-go - Clickhouse Loki API in GO

• shimohq/mogo - A light weight web log visual analytic platform for clickhouse.

• silentsokolov/dbt-clickhouse - The Clickhouse plugin for dbt (data build tool)

• Slach/clickhouse-flamegraph - CLI utility for build flamegraph based on system.trace_log

• trickstercache/trickster - Open Source HTTP Reverse Proxy Cache and Time Series Dashboard Accelerator

• uptrace/uptrace - Distributed tracing using OpenTelemetry and ClickHouse

• vectorengine/vectorsql - VectorSQL is a free analytics DBMS for IoT & Big Data, compatible with ClickHouse

• clickhouse-grafana - Clickhouse datasource for grafana

• whisklabs/airflow-clickhouse-plugin - Airflow ClickHouse Plugin based on clickhouse-driver

• zeromicro/cds - Data syncing in golang for ClickHouse

CLI

• cli - Built-in client

• hatarist/clickhouse-cli - A third-party client for the Clickhouse DBMS server

GUI

• EdurtIO/dbm - ClickHouse DataBase Manager Tools

• HouseOps - A simple client

• sqlpad/sqlpad - Web-based SQL editor run in your own private cloud. Supports MySQL, Postgres, SQL Server, Vertica, Crate, ClickHouse, Presto, SAP HANA, Cassandra, Snowflake, BigQuery, SQLite, and more with ODBC

• tabix - Simple business intelligence application and sql editor tool

• lighthouse - Lightweight interface for ClickHouse

Ops

• clickhouse-copier/ - Copies (and reshards) data from one cluster to another cluster

• clickhouse-local - Allows running SQL queries on data without stopping the ClickHouse server, similar to how awk does this

• AlexAkulov/clickhouse-backup - Tool for easy ClickHouse backup and restore with S3 support

• AlexeySetevoi/ansible-clickhouse - ansible role for clickhouse

• Altinity/altinity-dashboard - Altinity Dashboard helps you manage ClickHouse installations controlled by clickhouse-operator.

• clickhouse-operator - The ClickHouse Operator creates, configures and manages ClickHouse clusters running on Kubernetes

• Altinity/clickhouse-zabbix-template - Zabbix template for ClickHouse

• arduanov/homebrew-clickhouse - ClickHouse for MacOS Sierra and High Sierra.

• bytebase/bytebase - Web-based, zero-config, dependency-free database schema change and version control tool for teams.

• ClickHouse/clickhouse_exporter - This is a simple server that periodically scrapes ClickHouse stats and exports them via HTTP for Prometheus(https://prometheus.io/) consumption

• delium/clickhouse-migrator - Easy data migrator to robust clickhouse

• clickhouse_exporter - Scraper for Prometheus

• grafana/clickhouse-datasource - Grafana Plugin for ClickHouse

• housepower/ckman - This is a tool which used to manage and monitor ClickHouse database

• knadh/sql-jobber - A highly opinionated, distributed job-queue built specifically for queuing and executing heavy SQL read jobs asynchronously. Supports MySQL, Postgres, ClickHouse.

• long2ice/synch - Sync data from other DB to ClickHouse(cluster)

• clickhouse-bulk - Collects many small inserts to ClickHouse and send in big inserts

• radondb/radondb-clickhouse-kubernetes - Open Source，High Availability Cluster，based on ClickHouse

• tetafro/clickhouse-cluster - Simple clickhouse cluster with docker-compose

• zlzforever/ClickHouseMigrator - Help to migrate data to ClickHouse, create database and table auto.

Examples

• AlexeyKupershtokh/clickhouse-maxmind-geoip - A demonstration how to use ClickHouse with MaxMind GeoIP2 databases for geolocaiton

• ClickHouse/github-explorer - Everything You Always Wanted To Know About GitHub (But Were Afraid To Ask)

Social

• Telegram (Russian)

• Twitter (English)

License