Skip to main content
Skip to main content
Edit this page

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.

Core integrations

NameLogoCategoryDescriptionResources
Amazon KinesisData ingestionIntegration with Amazon Kinesis.Documentation
Amazon MSKData ingestionIntegration with Amazon Managed Streaming for Apache Kafka (MSK).Documentation
Amazon S3Data ingestionImport from, export to, and transform S3 data in flight with ClickHouse built-in S3 functions.Documentation
Amazon Glue
Data ingestionQuery ClickHouse over JDBCDocumentation
Apache SparkApache Spark logoData ingestionSpark ClickHouse Connector is a high performance connector built on top of Spark DataSource V2.GitHub,
Documentation
Azure Event HubsData ingestionA data streaming platform that supports Apache Kafka's native protocolWebsite
C++
Language clientC++ client for ClickHouseGitHub
Cassandra
Data ingestionAllows ClickHouse to use Cassandra as a dictionary source.Documentation
CHDBAI/MLAn embedded OLAP SQL EngineGitHub,
Documentation
ClickHouse ClientSQL clientClickHouse Client is the native command-line client for ClickHouse.Documentation
ConfluentData ingestionIntegration with Apache Kafka on Confluent platform.Documentation
dbtdbtData integrationUse dbt (data build tool) to transform data in ClickHouse by simply writing select statements. dbt puts the T in ELT.Documentation
DeltaLake
Data ingestionprovides a read-only integration with existing Delta Lake tables in Amazon S3.Documentation
EmbeddedRocksDBData integrationAllows integrating ClickHouse with rocksdb.Documentation
FivetranData ingestionClickHouse Cloud destination for the Fivetran data movement platform.Documentation
Google Cloud StorageData ingestionImport from, export to, and transform GCS data in flight with ClickHouse built-in S3 functions.Documentation
GolangLanguage clientThe Go client uses the native interface for a performant, low-overhead means of connecting to ClickHouse.Documentation
HDFSData ingestionProvides integration with the Apache Hadoop ecosystem by allowing to manage data on HDFS via ClickHouse.Documentation
HiveData ingestionnThe Hive engine allows you to perform SELECT quries on HDFS Hive table.Documentation
Hudi
Data ingestionprovides a read-only integration with existing Apache Hudi tables in Amazon S3.Documentation
Iceberg
Data ingestionProvides a read-only integration with existing Apache Iceberg tables in Amazon S3.Documentation
Java, JDBCLanguage clientThe Java client and JDBC driver.Documentation
KafkaData ingestionIntegration with Apache Kafka, the open-source distributed event streaming platform.Documentation
Looker StudioData visualizationLooker Studio is a free tool that turns your data into informative, easy to read, easy to share, and fully customizable dashboards and reports.Documentation
LookerData visualizationLooker is an enterprise platform for BI, data applications, and embedded analytics that helps you explore and share insights in real time.Documentation
Metabase
Data visualizationMetabase is an easy-to-use, open source UI tool for asking questions about your data.Documentation
MinIO
Data ingestionMinIO 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 serviceDocumentation
MongoDBData ingestionMongoDB engine is read-only table engine which allows to read data (SELECT queries) from remote MongoDB collection.Documentation
MySQLData ingestionThe MySQL engine allows you to perform SELECT and INSERT queries on data that is stored on a remote MySQL server.Documentation
NATSData ingestionAllows integrating ClickHouse with NATS.Documentation
Node.JSLanguage clientThe official JS client for connecting to ClickHouse.Documentation
ODBC
Data integrationAllows ClickHouse to connect to external databases via ODBC table engine.Documentation
OpenTelemetry
Data ingestionExporter that supports sending logs, metrics, trace OpenTelemetry data to ClickHouseGitHub
PostgreSQLData ingestionSnapshot and real-time CDC data replication from PostgreSQL databases to ClickHouse Cloud.Documentation
PowerBI
Data visualizationMicrosoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence.Documentation
PythonLanguage clientA suite of Python packages for connecting Python to ClickHouse.Documentation
QuickSightData visualizationAmazon QuickSight powers data-driven organizations with unified business intelligence (BI).Documentation
RabbitMQData ingestionAllows ClickHouse to connect RabbitMQ.Documentation
RedisData ingestionAllows ClickHouse to use Redis as a dictionary source.Documentation
Redpanda
Data ingestionRedpanda is the streaming data platform for developers. It’s API-compatible with Apache Kafka, but 10x faster, much easier to use, and more cost effectiveBlog
Rust
Language clientA typed client for ClickHouseDocumentation
SQLiteData ingestionAllows to import and export data to SQLite and supports queries to SQLite tables directly from ClickHouse.Documentation
SupersetData visualizationExplore and visualize your ClickHouse data with Apache Superset.Documentation
Tableau
Data visualizationInteractive data visualization software focused on business intelligenceDocumentation
Tableau Online
Data visualizationTableau Online streamlines the power of data to make people faster and more confident decision makers from anywhereDocumentation

Partner integrations

NameLogoCategoryDescriptionResources
Airbyte
Data ingestionUse Airbyte, to create ELT data pipelines with more than 140 connectors to load and sync your data into ClickHouse.Documentation
AccelData
Data managementADOC allows users to monitor and ensure the dependability and integrity of their visualized data, facilitating rea-time data processing and analytics.Documentation
Atlas
Schema managementManage your ClickHouse schema as code.Documentation
AstratoData visualizationAstrato 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 ingestionCloud-native Kafka and RocketMQ alternatives that decouples durability to S3 and EBSWebsite
BlinkOps
Security automationCreate automations to manage data and user permissions.Documentation
BytewaxData ingestionOpen source Python stream processor for transforming and ingesting data to ClickHouseDocumentation
Calyptia (Fluent Bit)
Data ingestionCNCF graduated open-source project for the collection, processing, and delivery of logs, metrics, and tracesBlog
Chartbrew
Data visualizationChartbrew is a data visualization platform that allows users to create dashboards and monitor data in real time.Documentation,
Website,
Blog
CloudCanalData integrationA data synchronization and migration tool.Website
CloudQueryData ingestionOpen source high-performance ELT framework.Documentation
Cube.jsData visualizationCube is the Semantic Layer for building data apps.Website
DBeaverSQL clientFree multi-platform database administration tool. Connects to Clickhouse through JDBC driver.Documentation
DataGripSQL clientDataGrip is a powerful database IDE with dedicated support for ClickHouse.Documentation
Dataddo
Data integrationData integration platformWebsite
DbVisualizer
SQL clientDbVisualizer is a database tool with extended support for ClickHouse.Documentation
Decodable
Data ingestionPowerful Stream Processing Built On Apache FlinkWebsite
DeepnoteData visualizationDeepnote is a collaborative Jupyter-compatible data notebook built for teams to discover and share insights.Documentation
DLTData integrationAn open source Python library that makes data loading easy.Documentation
DraxlrData visualizationDraxlr is a Business intelligence tool with data visualization and analytics.Documentation
EMQX320备份Data ingestionEMQX 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 visualizationExplo is a customer-facing analytics tool for any platform.Documentation
Gigasheet
Data visualizationA cloud big data analytics spreadsheet that enables business users to instantly analyze and explore ClickHouse data.Website
GlassFlow
Data ingestionReal-time event streaming and data transformation in Python for ClickHouse.Documentation
Goldsky
Data IntegrationHigh-performance Web3 data indexing via Subgraphs and real-time data replication pipelines.Documentation
GrafanaData visualizationWith Grafana you can create, explore and share all of your data through dashboards.Documentation
Great ExpectationsData managementAn open-source data management tool, with a paid cloud offering.Website
GrowthBook
Data visualizationWarehouse native experimentation platform (feature flagging and A/B testing).Documentation
HEX
Data visualizationHex is a modern, collaborative platform with notebooks, data apps, SQL, Python, no-code, R, and so much more.Documentation
HashboardData visualizationHashboard is a business intelligence platform that enables self-service data exploration and metric tracking.Documentation
HighTouch
Data integrationSync your data directly from your warehouse to 140+ destinationsWebsite
Holistics
Data visualizationBusiness Intelligence for ClickHouse databaseWebsite
HouseWatch
Data managementOpen source tool for monitoring and managing ClickHouse clusters.GitHub
IBM InstanaData managementInstana can auto-discover and monitor ClickHouse server processesDocumentation
JitsuData analyticsAn open-source event collection platform.Documentation
LangChain🦜️🔗SDKLangChain is a framework for developing applications powered by language modelsDocumentation
Luzmo
Data visualizationLuzmo is an embedded analytics platform with a native ClickHouse integration, purpose-built for Software and SaaS applications.Documentation
Mage
Data IngestionOpen-source data pipeline tool for transforming and integrating dataDocumentation
Metaplane
Data managementData observability for every data teamWebsite
MindsDB
AI/MLThe platform for customizing AI from enterprise dataWebsite
Mitzu
Data visualizationMitzu is a no-code warehouse-native product analytics application. Find funnel, retention, user segmentation insights without copying your data.Documentation
Mode Analytics
Data visualizationBusiness Intelligence built around data teamsWebsite
OmniData visualizationBusiness 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 clientOpenblocks is a low code platform for building UIsDocumentation
OpsRamp (HP)
Data managementProvides observability metrics for ClickHouseDocumentation
PopsinkData integrationBuild real-time Change Data Capture (CDC) pipelines to ClickHouse.Documentation
PrequelData sharingConnect your ClickHouse instance to Prequel to share data to or sync data from your users and partners.Documentation
QuesmaData integrationUse Kibana and OpenSearch Dashboards with data in ClickHouse.Website
Redash
Data visualizationConnect and query your data sources, build dashboards to visualize data and shareWebsite
Restack Data Hub
Data governanceUsers can achieve more comprehensive data governance and observability framework with Restack Data Hub.Documentation
Restack OpenMetadata
Data qualityRestack OpenMetadata supports metadata extraction, query usage tracking, data profiling, and data quality checks.Documentation
RetoolNo codeCreate your application with drag-and-drop interface.Documentation
RillData visualizationRill is an Operational BI tool purpose-built for slicing & dicing data with OLAP engines.Documentation
RisingWaveData ingestionSQL stream processing with a Postgres-like experience. 10x faster and more cost-efficient than Apache Flink.Documentation
RudderStackData ingestionRudderStack makes it easy to collect and send customer data to the tools and teams that need itDocumentation
RunReveal
Data ingestionIngest and normalize audit logs from any SaaS application into ClickHouse. Create alerts and detections from scheduled queries.Website
Sematext
Data managementObservability monitoring for ClickHouse databases.Documentation
SiSense
Data visualizationEmbed analytics into any application or workflowWebsite
SigNoz
Data visualizationOpen Source Observability PlatformDocumentation
Snappy Flow
Data managementCollects ClickHouse database metrics via plugin.Documentation
Soda
Data qualitySoda 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
Splunk
Data integrationSplunk modular input to import to Splunk the ClickHouse Cloud Audit logs.Website,
Documentation
StreamingFast
Data ingestionBlockchain-agnostic, parallelized and streaming-first data engine.Website
Streamkap
Data ingestionSetup real-time CDC (Change Data Capture) streaming to ClickHouse with high throughput in minutes.Documentation
Supabase
Data ingestionOpen source Firebase alternativeGitHub,Blog
Teleport
Secure connectionTeleport Database Service authenticates to ClickHouse using x509 certificates, which are available for the ClickHouse HTTP and Native (TCP) interfaces.Documentation
TABLUM.IOSQL clientTABLUM.IO ingests data from a variety of sources, normalizes and cleans inconsistencies, and gives you access to it via SQL.Documentation
Tooljet
Data VisualizationToolJet is an open-source low-code framework to build and deploy custom internal tools.Documentation
UpstashData IngestionA data platform offering serverless Kafka and other solutionsWebsite
Vector
Data ingestionA lightweight, ultra-fast tool for building observability pipelines with built-in compatibility with ClickHouse.Documentation
WarpStreamData IngestionA Kafka compatible data streaming platform built directly on top of object storageWebsite
YepCodeData integrationYepCode is the integration & automation tool that loves source code.Documentation
Zing Data
Data visualizationSimple social business intelligence for ClickHouse, made for iOS, Android and the web.Documentation

Community integrations

NameLogoCategoryDescriptionResources
Apache Airflow
Data ingestionOpen-source workflow management platform for data engineering pipelinesGithub
Apache Beam
Data ingestionOpen 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 ingestionOne-stop integration framework for massive dataDocumentation
Apache NiFi
Data ingestionAutomates the flow of data between software systemsDocumentation
Apache SeaTunnel
Data ingestionSeaTunnel is a very easy-to-use ultra-high-performance distributed data integration platformWebsite
Apache SkyWalking
Data managementOpen-source APM system that provides monitoring, tracing and diagnosing capabilities for distributed systems in Cloud Native architectures.Blog
Apache StreamPark
Data ingestionA stream processing application development framework and stream processing operation platform.Website
Bytebase
Data managementOpen-source database DevOps tool, it's the GitLab for managing databases throughout the application development lifecycleDocumentation
C#Language clientClickHouse.Client is a feature-rich ADO.NET client implementation for ClickHouseDocumentation
CHProxyData managementChproxy is an HTTP proxy and load balancer for the ClickHouse databaseGitHub
Chat-DBTAI IntegrationCreate ClickHouse queries using Chat GPT.GitHub
ClickHouse Monitoring DashboardDashboardA simple monitoring dashboard for ClickHouseGithub
Common Lisp
Language clientCommon Lisp ClickHouse Client LibraryGitHub
Dataflow
Data ingestionGoogle Dataflow is a serverless service for running batch and streaming data pipelines using Apache Beam.Documentation
DBNet
Software IDEWeb-based SQL IDE using Go as a back-end, and the browser as the front-end.Github
DataLens
Data visualizationAn open-source data analytics and visualization tool.Website,
Documentation
Dataease
Data visualizationOpen source data visualization analysis tool to help users analyze data and gain insight into business trends.Website
Datahub
Data managementOpen Source Data Catalog that enables data discovery, data observability and federated governanceDocumentation
DbmateData managementDatabase migration tool that will keep your database schema in sync across multiple developers and serversGitHub
DeepFlow
Data ingestionApplication Observability using eBPFWebsite
Easypanel
Deployment methodIt's a modern server control panel. You can use it to deploy ClickHouse on your own server.Website,
Documentation
ExploData visualizationExplo helps companies build real-time analytics dashboard by providing flexible components.Website
Flink
Data ingestionFlink sink for ClickHouse database, powered by Async Http ClientGitHub
Goose
Data migrationA database migration tool that supports SQL migrations and Go functions.GitHub,
Documentation
Ibis
Language clientThe flexibility of Python analytics with the scale and performance of modern SQLWebsite
Jaeger
Data ingestionJaeger gRPC storage plugin implementation for storing traces in ClickHouseGitHub
JupySQL
SQL clientThe native SQL client for Jupyter notebooks.Documentation
KestraData orchestrationOpen source data orchestration and scheduling platformWebsite
Logchain
SecurityData security and privileged access managementWebsite
MeltanoData ingestionMeltano is an open-source, full-stack data integration platformDocumentation
Mprove
Data visualizationSelf-service Business Intelligence with Version ControlWebsite
NetobservData managementAn OpenShift and Kubernetes operator for network observability.Blog
ObservableData visualizationObservable is a platform where you can collaboratively explore, analyze, visualize, and communicate with data on the web.Website
PHP
Language clientThis extension provides the ClickHouse integration for the Yii framework 2.0GitHub
PgwarehouseData ingestionSimple tool to quickly replicate Postgres tables into ClickHouseGitHub
Pinax
Blockchain analyticsIndexing, analytics, and search tools for blockchains.Blog
Pulse
Data managementA developer platform for internal data UIs.Website
QStudio
GUIA simple to use GUI for interacting with ClickHouse databases.Website
Qryn
Data Ingestion, Management, Visualizationqryn 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 pluginsDocumentation, Github, Website
RSyslog
Data IngestionThis module provides native support for logging to ClickHouse.Documentation
Rocket.BIData visualizationRocketBI 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 clientA modern Ruby database driver for ClickHouseGitHub
R
Language clientR package is a DBI interface for the ClickHouse databaseGitHub
SQLPadSQL clientSQLPad is a web app for writing and running SQL queries and visualizing the resultsDocumentation
Scala
Language clientClickHouse Scala Client that uses Akka HttpGitHub
SchemaSpy
Data visualizationSchemaSpy supports ClickHouse schema visualuzationGitHub
TricksterCachetrickster-logoData visualizationOpen Source HTTP Reverse Proxy Cache and Time Series Dashboard AcceleratorWebsite
Visual Studio Client
Language clientVisual studio lightweight clientMarketplace
VulcanSQL
Data API FrameworkIt's a Data API Framework for data applications that helps data folks create and share data APIs faster. It turns your SQL templates into data APIs. No backend skills required.Website,
Documentation