---
id: clickhouse-connect
version: "1.7.1"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# clickhouse-connect — ClickHouse Database Core Driver for Python, Pandas, and Superset

License: permissive · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install clickhouse-connect
uv add clickhouse-connect
poetry add clickhouse-connect

## Description

## ClickHouse Connect

A high performance core database driver for connecting ClickHouse to Python, Pandas, and Superset

* Pandas DataFrames (numpy and arrow-backed). Requires pandas 2.0 or later.
* Numpy Arrays
* PyArrow Tables
* Polars DataFrames
* Superset Connector
* SQLAlchemy Core (select, joins, lightweight deletes; limited feature set)

ClickHouse Connect uses the ClickHouse HTTP interface for maximum compatibility. An experimental
[chDB](https://clickhouse.com/docs/chdb) backend is also available for running queries against an embedded
in-process engine with `get_client(interface='chdb')`. Install it with `pip install clickhouse-connect[chdb]`.

### Installation

```
pip install clickhouse-connect
```

ClickHouse Connect requires Python 3.10 or higher.

#### Upgrading from 0.x

The 1.0 release includes breaking changes. If you are upgrading from a 0.15.x or earlier release, see [MIGRATION.md](MIGRATION.md) for a guide to the changes and their replacements.

### Superset Connectivity

ClickHouse Connect is fully integrated with Apache Superset. Previous versions of ClickHouse Connect utilized a
dynamically loaded Superset Engine Spec, but as of Superset v2.1.0 the...

## AI interpretation — verify before relying

A high-performance Python driver for ClickHouse that supports Pandas DataFrames, NumPy arrays, PyArrow tables, and Polars DataFrames, with SQLAlchemy Core dialect and Superset integration via the HTTP interface.

Verdict: A production-ready, actively maintained ClickHouse driver with broad data-frame support and SQLAlchemy integration. No known vulnerabilities, permissive licensing, and recent releases indicate solid ongoing development. Medium install friction is typical for platform-specific wheels; suitable for analytics and data pipeline work.

[View on SkillFed](https://skillfed.io/packages/clickhouse-connect) · [View on PyPI](https://pypi.org/project/clickhouse-connect/)