Integrations
ClickHouse integrations are organized by their support level:
- Core integrations: built or maintained by ClickHouse, they are supported by ClickHouse and live in the ClickHouse GitHub organization
- Partner integrations: built or maintained, and supported by, third-party software vendors
- Community integrations: built or maintained and supported by community members. No direct support is available besides the public GitHub repositories and community Slack channels
Each integration is further categorized into Language client, Data ingestion, Data visualization and SQL client categories.
Note
We are actively compiling this list of ClickHouse integrations below, so it's not exhaustive. Feel free to contribute any relevant ClickHouse integration to the list.
Name | Logo | Category | Description | Resources |
---|---|---|---|---|
Amazon Kinesis | Data ingestion | Integration with Amazon Kinesis. | Documentation | |
Amazon MSK | Data ingestion | Integration with Amazon Managed Streaming for Apache Kafka (MSK). | Documentation | |
Amazon S3 | Data ingestion | Import from, export to, and transform S3 data in flight with ClickHouse built-in S3 functions. | Documentation | |
Amazon Glue | Data ingestion | Query ClickHouse over JDBC | Documentation | |
Apache Spark | Data ingestion | Spark ClickHouse Connector is a high performance connector built on top of Spark DataSource V2. | GitHub, Documentation | |
Astrato | Data visualization | Astrato brings true Self-Service BI to Enterprises & Data Businesses by putting analytics in the hands of every user, enabling them to build dashboards, reports & data apps without IT. | Documentation | |
AutoMQ | Data ingestion | Cloud-native Kafka and RocketMQ alternatives that decouples durability to S3 and EBS | AutoMQ | |
Cassandra | Data integration | Allows ClickHouse to use Cassandra as a dictionary source. | Documentation | |
CHDB | SQL Client | An embedded OLAP SQL Engine | GitHub, Documentation | |
ClickHouse Client | SQL client | ClickHouse Client is the native command-line client for ClickHouse. | Documentation | |
DeltaLake | Data integration | provides a read-only integration with existing Delta Lake tables in Amazon S3. | Documentation | |
EmbeddedRocksDB | Data integration | Allows integrating ClickHouse with rocksdb. | Documentation | |
Fivetran | Data ingestion | ClickHouse Cloud destination for the Fivetran data movement platform. | Documentation | |
Google Cloud Storage | Data ingestion | Import from, export to, and transform GCS data in flight with ClickHouse built-in S3 functions. | Documentation | |
Go | Language client | The Go client uses the native interface for a performant, low-overhead means of connecting to ClickHouse. | Documentation | |
HDFS | Data integration | Provides integration with the Apache Hadoop ecosystem by allowing to manage data on HDFS via ClickHouse. | Documentation | |
Hive | Data integration | The Hive engine allows you to perform SELECT quries on HDFS Hive table. | Documentation | |
HouseWatch | Data management | Open source tool for monitoring and managing ClickHouse clusters. | GitHub | |
Hudi | Data integration | provides a read-only integration with existing Apache Hudi tables in Amazon S3. | Documentation | |
Iceberg | Data integration | Provides a read-only integration with existing Apache Iceberg tables in Amazon S3. | Documentation | |
JDBC | Data integration | Allows ClickHouse to connect to external databases via JDBC table engine. | Documentation | |
Java, JDBC | Language client | The Java client and JDBC driver. | Documentation | |
Kafka | Data ingestion | Integration with Apache Kafka, the open-source distributed event streaming platform. | Documentation | |
Looker Studio | Data visualization | Looker Studio is a free tool that turns your data into informative, easy to read, easy to share, and fully customizable dashboards and reports. | Documentation | |
Looker | Data visualization | Looker is an enterprise platform for BI, data applications, and embedded analytics that helps you explore and share insights in real time. | Documentation | |
Metabase | Data visualization | Metabase is an easy-to-use, open source UI tool for asking questions about your data. | Documentation | |
MinIO | Data ingestion | MinIO is a High Performance Object Storage released under GNU Affero General Public License v3.0. It is API compatible with the Amazon S3 cloud storage service | Documentation | |
MongoDB | Data integration | MongoDB engine is read-only table engine which allows to read data (SELECT queries) from remote MongoDB collection. | Documentation | |
MySQL | Data integration | The MySQL engine allows you to perform SELECT and INSERT queries on data that is stored on a remote MySQL server. | Documentation | |
NATS | Data integration | Allows integrating ClickHouse with NATS. | Documentation | |
Node.JS | Language client | The official JS client for connecting to ClickHouse. | Documentation | |
ODBC | Data integration | Allows ClickHouse to connect to external databases via ODBC table engine. | Documentation | |
PostgreSQL | Data ingestion | Snapshot and real-time CDC data replication from PostgreSQL databases to ClickHouse Cloud. | Documentation | |
PowerBI | Data visualization | Microsoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. | Documentation | |
Python | Language client | A suite of Python packages for connecting Python to ClickHouse. | Documentation | |
QuickSight | Data visualization | Amazon QuickSight powers data-driven organizations with unified business intelligence (BI) at hyperscale. | Documentation | |
RabbitMQ | Data integration | Allows ClickHouse to connect RabbitMQ. | Documentation | |
Redis | Data integration | Allows ClickHouse to use Redis as a dictionary source. | Documentation | |
Rust | Language client | A typed client for ClickHouse | Documentation | |
SQLite | Data integration | Allows to import and export data to SQLite and supports queries to SQLite tables directly from ClickHouse. | Documentation | |
Superset | Data visualization | Explore and visualize your ClickHouse data with Apache Superset. | Documentation | |
Tableau Online | Data visualization | Tableau Online streamlines the power of data to make people faster and more confident decision makers from anywhere | Documentation | |
dbt | Data ingestion | Use dbt (data build tool) to transform data in ClickHouse by simply writing select statements. dbt puts the T in ELT. | Documentation |
Partner integrations
Name | Logo | Category | Description | Resources |
---|---|---|---|---|
Airbyte | Data ingestion | Use Airbyte, to create ELT data pipelines with more than 140 connectors to load and sync your data into ClickHouse. | Documentation | |
AccelData | Data management | ADOC allows users to monitor and ensure the dependability and integrity of their visualized data, facilitating rea-time data processing and analytics. | Documentation | |
Atlas | Schema management | Manage your ClickHouse schema as code. | Documentation | |
Azure Event Hubs | Data Ingestion | A data streaming platform that supports Apache Kafka's native protocol | Website | |
BlinkOps | Security automation | Create automations to manage data and user permissions. | Documentation | |
Bytewax | Data ingestion | Open source Python stream processor for transforming and ingesting data to ClickHouse | Documentation | |
Calyptia (Fluent Bit) | Data ingestion | CNCF graduated open-source project for the collection, processing, and delivery of logs, metrics, and traces | Blog | |
CloudCanal | Data integration | A data synchronization and migration tool. | Website | |
CloudQuery | Data ingestion | Open source high-performance ELT framework. | Documentation | |
Confluent | Data ingestion | Integration with Apache Kafka on Confluent platform. | Documentation | |
Cube.js | Data visualization | Cube is the Semantic Layer for building data apps. | Website | |
DBeaver | SQL client | Free multi-platform database administration tool. Connects to Clickhouse through JDBC driver. | Documentation | |
DataGrip | SQL client | DataGrip is a powerful database IDE with dedicated support for ClickHouse. | Documentation | |
Dataddo | Data integration | Data integration platform | Website | |
DbVisualizer | SQL client | DbVisualizer is a database tool with extended support for ClickHouse. | Documentation | |
Decodable | Data ingestion | Powerful Stream Processing Built On Apache Flink | Website | |
Deepnote | Data visualization | Deepnote is a collaborative Jupyter-compatible data notebook built for teams to discover and share insights. | Documentation | |
DLT | Data integration | An open source Python library that makes data loading easy. | Documentation | |
Draxlr | Data visualization | Draxlr is a Business intelligence tool with data visualization and analytics. | Documentation | |
EMQX | Data ingestion | EMQX is an open source MQTT broker with a high-performance real-time message processing engine, powering event streaming for IoT devices at massive scale. | Documentation | |
Explo | Data visualization | Explo is a customer-facing analytics tool for any platform | Documentation | |
Gigasheet | Data visualization | A cloud big data analytics spreadsheet that enables business users to instantly analyze and explore ClickHouse data. | Website | |
GlassFlow | Data ingestion | Real-time event streaming and data transformation in Python for ClickHouse | Documentation | |
Goldsky | Data Integration | High-performance Web3 data indexing via Subgraphs and realtime data replication pipelines. | Documentation | |
Grafana | Data visualization | With Grafana you can create, explore and share all of your data through dashboards. | Documentation | |
Great Expectations | Data management | An open-source data management tool, with a paid cloud offering. | Website | |
GrowthBook | Data visualization | Warehouse native experimentation platform (feature flagging and A/B testing). | Documentation | |
HEX | Data visualization | Hex is a modern, collaborative platform with notebooks, data apps, SQL, Python, no-code, R, and so much more. | Documentation | |
Hashboard | Data visualization | Hashboard is a business intelligence platform that enables self-service data exploration and metric tracking. | Documentation | |
HighTouch | Data integration | Sync your data directly from your warehouse to 140+ destinations | Website | |
Holistics | Data visualization | Business Intelligence for ClickHouse database | Website | |
IBM Instana | Data management | Instana can auto-discover and monitor ClickHouse server processes | Documentation | |
Jitsu | Data analytics | An open-source event collection platform. | Documentation | |
LangChain | 🦜️🔗 | SDK | LangChain is a framework for developing applications powered by language models | Documentation |
Luzmo | Data visualization | Luzmo is an embedded analytics platform with a native ClickHouse integration, purpose-built for Software and SaaS applications. | Documentation | |
Mage | Data Ingestion | Open-source data pipeline tool for transforming and integrating data | Documentation | |
Metaplane | Data management | Data observability for every data team | Website | |
MindsDB | AI/ML | The platform for customizing AI from enterprise data | Website | |
Mitzu | Data visualization | Mitzu is a no-code warehouse-native product analytics application. Find funnel, retention, user segmentation insights without copying your data. | Documentation | |
Mode Analytics | Data visualization | Business Intelligence built around data teams | Website | |
Omni | Data visualization | Business intelligence that speaks your language. Explore, visualize, and model data your way with Omni. From spreadsheets to SQL—in a single platform. | Website | |
Openblocks | SQL client | Openblocks is a low code platform for building UIs | Documentation | |
OpsRamp (HP) | Data management | Provides observability metrics for ClickHouse | Documentation | |
Popsink | Data integration | Build real-time Change Data Capture (CDC) pipelines to ClickHouse. | Documentation | |
Prequel | Data sharing | Connect your ClickHouse instance to Prequel to share data to or sync data from your users and partners. | Documentation | |
Quesma | Data integration | Use Kibana and OpenSearch Dashboards with data in ClickHouse. | Website | |
Redash | Data visualization | Connect and query your data sources, build dashboards to visualize data and share | Website | |
Redpanda | Data ingestion | Redpanda is the streaming data platform for developers. It’s API-compatible with Apache Kafka, but 10x faster, much easier to use, and more cost effective | Blog | |
Restack Data Hub | Data governance | Users can achieve more comprehensive data governance and observability framework with Restack Data Hub. | Documentation | |
Restack OpenMetadata | Data quality | Restack OpenMetadata supports metadata extraction, query usage tracking, data profiling, and data quality checks. | Documentation | |
Retool | No code | Create your application with drag-and-drop interface. | Documentation | |
Rill | Data visualization | Rill is an Operational BI tool purpose-built for slicing & dicing data with OLAP engines. | Documentation | |
RisingWave | Data ingestion | SQL stream processing with a Postgres-like experience. 10x faster and more cost-efficient than Apache Flink. | Documentation | |
RudderStack | Data ingestion | RudderStack makes it easy to collect and send customer data to the tools and teams that need it | Documentation | |
RunReveal | Data ingestion | Ingest and normalize audit logs from any SaaS application into ClickHouse. Create alerts and detections from scheduled queries. | Website | |
Sematext | Data management | Observability monitoring for ClickHouse databases. | Documentation | |
SiSense | Data visualization | Embed analytics into any application or workflow | Website | |
SigNoz | Data visualization | Open Source Observability Platform | Documentation | |
Snappy Flow | Data management | Collects ClickHouse database metrics via plugin. | Documentation | |
Soda | Data quality | Soda integration makes it easy for organziations to detect, resolve, and prevent data quality issues by running data quality checks on data before it is loaded into the database. | Website | |
StreamingFast | Data ingestion | Blockchain-agnostic, parallelized and streaming-first data engine. | Website | |
Streamkap | Data ingestion | Setup real-time CDC (Change Data Capture) streaming to ClickHouse with high throughput in minutes. | Documentation | |
Supabase | Data ingestion | Open source Firebase alternative | GitHub,Blog | |
Teleport | Secure connection | Teleport Database Service authenticates to ClickHouse using x509 certificates, which are available for the ClickHouse HTTP and Native (TCP) interfaces. | Documentation | |
TABLUM.IO | SQL client | TABLUM.IO ingests data from a variety of sources, normalizes and cleans inconsistencies, and gives you access to it via SQL. | Documentation | |
Tooljet | Data Visualization | ToolJet is an open-source low-code framework to build and deploy custom internal tools. | Documentation | |
Upstash | Data Ingestion | A data platform offering serverless Kafka and other solutions | Website | |
Vector | Data ingestion | A lightweight, ultra-fast tool for building observability pipelines with built-in compatibility with ClickHouse. | Documentation | |
WarpStream | Data Ingestion | A Kafka compatible data streaming platform built directly on top of object storage | Website | |
YepCode | Data integration | YepCode is the integration & automation tool that loves source code. | Documentation | |
Zing Data | Data visualization | Simple social business intelligence for ClickHouse, made for iOS, Android and the web. | Documentation |
Community integrations
Name | Logo | Category | Description | Resources |
---|---|---|---|---|
Apache Airflow | Data ingestion | Open-source workflow management platform for data engineering pipelines | Github | |
Apache Beam | Data ingestion | Open source, unified model and set of language-specific SDKs for defining and executing data processing workflows. Compatible with Google Dataflow. | Documentation, Examples | |
Apache InLong | Data ingestion | One-stop integration framework for massive data | Documentation | |
Apache Nifi | Data ingestion | Automates the flow of data between software systems | Documentation | |
Apache SeaTunnel | Data ingestion | SeaTunnel is a very easy-to-use ultra-high-performance distributed data integration platform | Website | |
Apache SkyWalking | Data management | Open-source APM system that provides monitoring, tracing and diagnosing capabilities for distributed systems in Cloud Native architectures. | Blog | |
Apache StreamPark | Data ingestion | A stream processing application development framework and stream processing operation platform. | Website | |
Bytebase | Data management | Open-source database DevOps tool, it's the GitLab for managing databases throughout the application development lifecycle | Documentation | |
C# | Language client | ClickHouse.Client is a feature-rich ADO.NET client implementation for ClickHouse | Documentation | |
C++ | Language client | C++ client for ClickHouse | GitHub | |
CHProxy | Data management | Chproxy is an HTTP proxy and load balancer for the ClickHouse database | GitHub | |
Chat-DBT | AI Integration | Create ClickHouse queries using Chat GPT. | GitHub | |
ClickHouse Monitoring Dashboard | Dashboard | A simple monitoring dashboard for ClickHouse | Github | |
Common Lisp | Language client | Common Lisp ClickHouse Client Library | GitHub | |
DBNet | Software IDE | Web-based SQL IDE using Go as a back-end, and the browser as the front-end. | Github | |
DataLens | Data visualization | An open-source data analytics and visualization tool. | Website, Documentation | |
Dataease | Data visualization | Open source data visualization analysis tool to help users analyze data and gain insight into business trends. | Website | |
Datahub | Data management | Open Source Data Catalog that enables data discovery, data observability and federated governance | Documentation | |
Dbmate | Data management | Database migration tool that will keep your database schema in sync across multiple developers and servers | GitHub | |
DeepFlow | Data ingestion | Application Observability using eBPF | Website | |
Easypanel | Deployment method | It's a modern server control panel. You can use it to deploy ClickHouse on your own server. | Website, Documentation | |
Explo | Data visualization | Explo helps companies build real-time analytics dashboard by providing flexible components. | Website | |
Flink | Data ingestion | Flink sink for ClickHouse database, powered by Async Http Client | GitHub | |
Goose | Data migration | A database migration tool that supports SQL migrations and Go functions. | GitHub, Documentation | |
Ibis | Language client | The flexibility of Python analytics with the scale and performance of modern SQL | Website | |
Jaeger | Data ingestion | Jaeger gRPC storage plugin implementation for storing traces in ClickHouse | GitHub | |
JupySQL | SQL client | The native SQL client for Jupyter notebooks. | Documentation | |
Kestra | Data orchestration | Open source data orchestration and scheduling platform | Website | |
Logchain | Security | Data security and privileged access management | Website | |
Meltano | Data ingestion | Meltano is an open-source, full-stack data integration platform | Documentation | |
Mprove | Data visualization | Self-service Business Intelligence with Version Control | Website | |
Netobserv | Data management | An OpenShift and Kubernetes operator for network observability. | Blog | |
Observable | Data visualization | Observable is a platform where you can collaboratively explore, analyze, visualize, and communicate with data on the web. | Website | |
OpenTelemetry | Data ingestion | Exporter that supports sending logs, metrics, trace OpenTelemetry data to ClickHouse | GitHub | |
PHP | Language client | This extension provides the ClickHouse integration for the Yii framework 2.0 | GitHub | |
Pgwarehouse | Data ingestion | Simple tool to quickly replicate Postgres tables into ClickHouse | GitHub | |
Pinax | Blockchain analytics | Indexing, analytics, and search tools for blockchains. | Blog | |
Pulse | Data management | A developer platform for internal data UIs. | Website | |
QStudio | GUI | A simple to use GUI for interacting with ClickHouse databases. | Website | |
QStudio | SQL client | qStudio is a free SQL GUI for running SQL scripts and charting results | Documentation | |
Qryn | Data Ingestion, Management, Visualization | qryn is a polyglot observability stack built on top of ClickHouse, transparently compatible with Loki, Prometheus, Tempo, Opentelemetry and many other formats and standard APIs without requiring custom clients, code or plugins | Documentation, Github, Website | |
RSyslog | Data Ingestion | This module provides native support for logging to ClickHouse. | Documentation | |
Rocket.BI | Data visualization | RocketBI is a self-service business intelligence platform that helps you quickly analyze data, build drag-n-drop visualizations and collaborate with colleagues right on your web browser. | GitHub, Documentation | |
Ruby | Language client | A modern Ruby database driver for ClickHouse | GitHub | |
R | Language client | R package is a DBI interface for the ClickHouse database | GitHub | |
SQLPad | SQL client | SQLPad is a web app for writing and running SQL queries and visualizing the results | Documentation | |
Scala | Language client | ClickHouse Scala Client that uses Akka Http | GitHub | |
SchemaSpy | Data visualization | SchemaSpy supports ClickHouse schema visualuzation | GitHub | |
Tableau | Data visualization | Interactive data visualization software focused on business intelligence | Documentation | |
TricksterCache | Data visualization | Open Source HTTP Reverse Proxy Cache and Time Series Dashboard Accelerator | Website | |
Visual Studio Client | Language client | Visual studio lightweight client | Marketplace | |
VulcanSQL |