Integration libraries from third-party developers

:::warning 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 {#infrastructure-products}

<details> <summary>Relational database management systems</summary>

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

</details> <details> <summary>Message queues</summary>

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

</details> <details> <summary>Batch processing</summary>

• Spark
  • spark-clickhouse-connector

</details> <details> <summary>Stream processing</summary>

• Flink
  • flink-clickhouse-sink

</details> <details> <summary>Object storages</summary>

• S3
  • clickhouse-backup

</details> <details> <summary>Container orchestration</summary>

• Kubernetes
  • clickhouse-operator

</details> <details> <summary>Configuration management</summary> - [puppet](https://puppet.com) - [innogames/clickhouse](https://forge.puppet.com/innogames/clickhouse) - [mfedotov/clickhouse](https://forge.puppet.com/mfedotov/clickhouse) </details> <details> <summary>Monitoring</summary>

• 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

</details> <details> <summary>Logging</summary>

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

</details> <details> <summary>Geo</summary>

• MaxMind
  • clickhouse-maxmind-geoip

</details> <details> <summary>AutoML</summary>

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

</details>

Programming language ecosystems {#programming-language-ecosystems}

<details> <summary>Python</summary>

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

</details> <details> <summary>PHP</summary>

• Doctrine
  • dbal-clickhouse

</details> <details> <summary>R</summary>

• dplyr
  • RClickHouse (uses clickhouse-cpp)

</details> <details> <summary>Java</summary>

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

</details> <details> <summary>Scala</summary>

• Akka
  • clickhouse-scala-client

</details> <details> <summary>C#</summary>

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

</details> <details> <summary>Elixir</summary>

• Ecto
  • clickhouse_ecto

</details> <details> <summary>Ruby</summary>

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

</details>