Integration Libraries from Third-party Developers

Disclaimer

ClickHouse, Inc. does not maintain the tools and libraries listed below and haven’t done extensive testing to ensure their quality.

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