Integration Libraries from Third-party Developers

Documentation on integrating ClickHouse with various third-party systems and tools

Disclaimer

ClickHouse, Inc. does not maintain the tools and libraries listed below and haven’t done extensive testing to ensure their quality. For official integrations please see the integrations page.

Infrastructure products

Relational database management systems

• MySQL
  • mysql2ch
  • ProxySQL
  • clickhouse-mysql-data-reader
  • horgh-replicator
• PostgreSQL
  • clickhousedb_fdw
  • infi.clickhouse_fdw (uses infi.clickhouse_orm)
  • pg2ch
  • clickhouse_fdw
• MSSQL
  • ClickHouseMigrator

Schema migration tools

• clicko - Cluster-aware and Go integration.

Message queues

• Kafka
  • clickhouse_sinker (uses Go client)
  • stream-loader-clickhouse

Batch processing

• Spark
  • spark-clickhouse-connector

Stream processing

• Flink
  • flink-clickhouse-sink

Object storages

• S3
  • clickhouse-backup

Container orchestration

• Kubernetes
  • clickhouse-operator

Configuration management

• puppet
  • innogames/clickhouse
  • mfedotov/clickhouse

Monitoring

• Graphite
  • graphouse
  • carbon-clickhouse
  • graphite-clickhouse
  • graphite-ch-optimizer - optimizes staled partitions in *GraphiteMergeTree if rules from rollup configuration could be applied
• Grafana
  • clickhouse-grafana
• Prometheus
  • clickhouse_exporter
  • PromHouse
  • clickhouse_exporter (uses Go client)
• Nagios
  • check_clickhouse
  • check_clickhouse.py
• Zabbix
  • clickhouse-zabbix-template
• Sematext
  • clickhouse integration

Logging

• rsyslog
  • omclickhouse
• fluentd
  • loghouse (for Kubernetes)
• logagent
  • logagent output-plugin-clickhouse

Geo

• MaxMind
  • clickhouse-maxmind-geoip

AutoML

• MindsDB
  • MindsDB - Integrates with ClickHouse, making data from ClickHouse accessible to a diverse range of AI/ML models.

Programming language ecosystems

Python

• SQLAlchemy
  • sqlalchemy-clickhouse (uses infi.clickhouse_orm)
• PyArrow/Pandas
  • Ibis

PHP

• Doctrine
  • dbal-clickhouse

R

• dplyr
  • RClickHouse (uses clickhouse-cpp)

Java

• Hadoop
  • clickhouse-hdfs-loader (uses JDBC)

Scala

• Akka
  • clickhouse-scala-client

C#

• ADO.NET
  • ClickHouse.Ado
  • ClickHouse.Client
  • ClickHouse.Net
  • ClickHouse.Net.Migrations
  • Linq To DB

Elixir

• Ecto
  • clickhouse_ecto

Ruby

• Ruby on Rails
  • activecube
  • ActiveRecord
• GraphQL
  • activecube-graphql