clickhouse-connect
ClickHouse Database Core Driver for Python, Pandas, and Superset
Decision gist · record as of 2026-08-14
Yes. Active maintenance, no known vulnerabilities, permissive license, and broad Python version support (3.10–3.14) make it a solid choice. Medium install friction is typical for a compiled driver. Install if you need ClickHouse connectivity from Python, especially with Pandas or Superset; the SQLAlchemy dialect is best suited for Core usage and Superset, not full ORM workloads.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or higher; ClickHouse server must be accessible via HTTP on the specified host and port.
- Medium install friction due to compiled wheels across multiple platforms and Python versions (3.10–3.14).
- Active maintenance with a release 2 days ago and 514 repository stars.
License · maintenance · safety
Apache-2.0 (permissive) — Apache-2.0 permissive license allows commercial and private use with minimal restrictions; suitable for most projects.
last release 2026-08-12 (2 days) · last repo commit 2026-08-13 · 514 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 31,374,110 downloads/mo, #788 on PyPI
Alternatives
Verify before relying
pip install clickhouse-connect
import clickhouse_connect
client = clickhouse_connect.get_client(host='localhost')
result = client.query('SELECT * FROM my_table')
df = result.as_pandas()- Whether the experimental chDB backend (in-process engine) is production-ready or still under active development.
- Performance characteristics compared to other ClickHouse drivers or direct HTTP clients.
- Whether SQLAlchemy ORM limitations (no UPDATE, foreign keys, or cascade operations) affect your use case.
What it is and what it does
ClickHouse Connect is a Python driver that connects to ClickHouse databases via HTTP, designed for high performance with data science and analytics workflows. It integrates directly with Pandas DataFrames, NumPy arrays, PyArrow tables, and Polars DataFrames, making it natural to use in data pipelines. The package also includes a SQLAlchemy dialect for query building and schema management, and supports Apache Superset for visualization.
The driver requires Python 3.10 or higher and depends on compression (backports.zstd, lz4) and HTTP libraries (urllib3, certifi, tzdata). It offers optional async support via aiohttp and Alembic integration for schema migrations. SQLAlchemy support covers Core operations (SELECT, JOIN, DELETE) and basic ORM for insert-heavy workloads, though full ORM features like UPDATE and relationships are not implemented. An experimental chDB backend allows in-process queries as an alternative to HTTP.
Use it for
- Load Pandas DataFrames directly into ClickHouse or fetch query results as DataFrames for analysis.
- Build and execute SQL queries via SQLAlchemy Core for Superset dashboards and reporting.
- Manage ClickHouse schema changes using Alembic migrations with ClickHouse-specific table engines.
- Run async queries in concurrent Python applications using the optional aiohttp backend.
- Integrate ClickHouse as a data source in Apache Superset without external engine specs.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
Active maintenance, no known vulnerabilities, permissive license, and broad Python version support (3.10–3.14) make it a solid choice. Medium install friction is typical for a compiled driver. Install if you need ClickHouse connectivity from Python, especially with Pandas or Superset; the SQLAlchemy dialect is best suited for Core usage and Superset, not full ORM workloads.
Install
clickhouse-connect on PyPI
Before you install
Medium install friction due to compiled wheels across multiple platforms and Python versions (3.10–3.14). Active maintenance with a release 2 days ago and 514 repository stars. Five runtime dependencies including compression libraries (backports.zstd, lz4) and HTTP utilities (urllib3, certifi).
Requires Python 3.10 or higher; ClickHouse server must be accessible via HTTP on the specified host and port.
License in practice
Apache-2.0 permissive license allows commercial and private use with minimal restrictions; suitable for most projects.
Quickstart
pip install clickhouse-connect
import clickhouse_connect
client = clickhouse_connect.get_client(host='localhost')
result = client.query('SELECT * FROM my_table')
df = result.as_pandas()Verify before relying
- Whether the experimental chDB backend (in-process engine) is production-ready or still under active development.
- Performance characteristics compared to other ClickHouse drivers or direct HTTP clients.
- Whether SQLAlchemy ORM limitations (no UPDATE, foreign keys, or cascade operations) affect your use case.
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 packagescertifiurllib3tzdatabackports.zstdlz4 |
| Maintenance | Actively maintained 2 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 31,374,110 / month, #788 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | 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 |
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
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “pandas dataframe to clickhouse”
- clickhouse-connectA Python database driver for ClickHouse that supports DataFrames,…
- chdb-corechdb-core is an in-process SQL OLAP engine powered by ClickHouse that…
- connectorxConnectorX loads data from databases directly into Python dataframes…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also clickhouse-sqlalchemy · django-clickhouse-backend · clickhouse-migrations · django-clickhouse · mcp-clickhouse · chdb · chdb-core · dbt-clickhouse · connectorx · infi.clickhouse-orm