clickhouse-connect

ClickHouse Database Core Driver for Python, Pandas, and Superset

clickhouse-connect Permissive license Apache-2.0 Active ★ 514 v1.7.1 released 2026-08-12

Install

clickhouse-connect on PyPI

pip

pip install clickhouse-connect

uv

uv add clickhouse-connect

poetry

poetry add clickhouse-connect

Package facts

License	Apache-2.0 (permissive)
Python support	supports the current Python release (<3.15,>=3.10)
Install friction	medium — platform-specific wheel
Runtime dependencies	5 — certifi, urllib3, tzdata, backports.zstd, lz4
Maintenance	actively maintained — 1 days since the last release
Last repo commit	2026-08-13
First released	2022-09-21
Popularity	one of the top 1,000 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: clickhouse_connect-1.7.1-cp310-cp310-macosx_10_9_x86_64.whl; clickhouse_connect-1.7.1-cp310-cp310-macosx_11_0_arm64.whl; clickhouse_connect-1.7.1-cp310-cp310-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl; clickhouse_connect-1.7.1-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl; clickhouse_connect-1.7.1-cp310-cp310-musllinux_1_2_aarch64.whl; clickhouse_connect-1.7.1-cp310-cp310-musllinux_1_2_x86_64.whl; clickhouse_connect-1.7.1-cp310-cp310-win32.whl; clickhouse_connect-1.7.1-cp310-cp310-win_amd64.whl; clickhouse_connect-1.7.1-cp310-cp310-win_arm64.whl; clickhouse_connect-1.7.1-cp311-cp311-macosx_10_9_x86_64.whl; clickhouse_connect-1.7.1-cp311-cp311-macosx_11_0_arm64.whl; clickhouse_connect-1.7.1-cp311-cp311-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl; clickhouse_connect-1.7.1-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl; clickhouse_connect-1.7.1-cp311-cp311-musllinux_1_2_aarch64.whl; clickhouse_connect-1.7.1-cp311-cp311-musllinux_1_2_x86_64.whl; clickhouse_connect-1.7.1-cp311-cp311-win32.whl; clickhouse_connect-1.7.1-cp311-cp311-win_amd64.whl; clickhouse_connect-1.7.1-cp311-cp311-win_arm64.whl; clickhouse_connect-1.7.1-cp312-cp312-macosx_10_13_x86_64.whl; clickhouse_connect-1.7.1-cp312-cp312-macosx_11_0_arm64.whl

Keywords: clickhouse, superset, sqlalchemy, http, driver

Development Status :: 5 - Production/StableIntended Audience :: DevelopersLicense :: OSI Approved :: Apache Software LicenseProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14

About clickhouse-connect

from the package's own PyPI description — quoted content, verbatim

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

Read as markdown · JSON record · Source repository · Homepage

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

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.

Medium install friction due to platform-specific wheels across multiple Python versions (3.10–3.14) and architectures. Active maintenance with a release just 1 day ago and recent commits signal ongoing support. Runtime dependencies on compression libraries (backports.zstd, lz4) and urllib3 are standard.

Apache-2.0 is a permissive license; you may use, modify, and distribute this package freely in commercial and private projects, provided you include a copy of the license and state significant changes.

Usage

pip install clickhouse-connect
import clickhouse_connect
client = clickhouse_connect.get_client(host='localhost')
result = client.query('SELECT 1')
print(result.result_rows)

Requires Python 3.10 or higher; ClickHouse server must be running and accessible at the specified host/port.

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.

Needs verification

Whether the optional async, chdb, and alembic extras are commonly used and their stability/maturity
Performance characteristics compared to native ClickHouse client libraries under typical workloads

clickhouse python driverclickhouse pandas connectorsqlalchemy clickhouse dialectclickhouse http clientsuperset clickhouse integration