AlSaltAlBahri/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

  • donet5/SqlSugar - Best ORM Fastest ORM Simple Easy Sqlite orm Oracle ORM Mysql Orm postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb

  • 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

  • esazykin/laravel-clickhouse - Eloquent model 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

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

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

• ContentSquare/chproxy - ClickHouse http proxy and load balancer

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

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

• justwatchcom/sql_exporter - Flexible SQL Exporter for Prometheus.

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

• clickhousedb_fdw - PostgreSQL’s Foreign Data Wrapper For ClickHouse

• subzerocloud/showcase - REST api for your database (PostgreSQL/Sqlite/ClickHouse).

• 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

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

• 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

• jneo8/clickhouse-setup - Tutorial for setup clickhouse server.

• 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

• plutov/clickhouse-helm - ClickHouse Helm Chart

• 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)

• toddwschneider/nyc-taxi-data - Import public NYC taxi and for-hire vehicle (Uber, Lyft) trip data into a PostgreSQL or ClickHouse database

Social

• Telegram (Russian)

• Twitter (English)

License