clickhouse-pool
a thread-safe connection pool for ClickHouse
Decision gist · record as of 2026-08-14
Yes, with conditions. The package solves a real problem—connection pooling for ClickHouse—and has low install friction. However, the aging maintenance status (no release in over a year, last commit in early 2026) means you should verify that it remains compatible with your ClickHouse server version and clickhouse-driver release before adopting it in production. The copyleft license requires that your application source be available under compatible terms if distributed.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires a running ClickHouse server instance accessible at the configured host and port.
- Low install friction with a single pure-Python dependency.
- Maintenance status is aging—last commit was 2026-01-08 and no release in the past year, though the repository remains active and not archived.
License · maintenance · safety
LGPL-3.0-or-later (copyleft) — Licensed under LGPL-3.0-or-later (copyleft). Any application linking this package must make its own source code available under compatible terms if distributed.
last release 2025-08-19 (360 days) · last repo commit 2026-01-08 · 42 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 2,101,283 downloads/mo, #3,295 on PyPI
Alternatives
Verify before relying
from clickhouse_pool import ChPool
pool = ChPool(host="localhost")
with pool.get_client() as client:
result = client.execute("SELECT * FROM system.numbers LIMIT 5")
print(result)
pool.cleanup()- Whether the aging maintenance status (no release since 2025-08-19) indicates active development or dormancy.
- Performance characteristics and scalability limits of the pool under high concurrency.
- Compatibility with recent ClickHouse server versions and breaking changes in clickhouse-driver.
What it is and what it does
clickhouse-pool wraps the clickhouse-driver library to provide a thread-safe connection pool for ClickHouse databases, similar to psycopg2's pooling model. It manages a configurable minimum and maximum number of persistent connections, allowing applications to acquire and release clients without creating new connections for each query. The pool handles connection lifecycle management and cleanup.
The package is designed for Python applications that need to execute multiple queries against ClickHouse and want to avoid the overhead of establishing new connections repeatedly. It supports Python 3.9 through 3.12 and requires explicit cleanup via pool.cleanup() when the application shuts down.
Use it for
- Web services or APIs that execute multiple ClickHouse queries per request and need connection reuse.
- Batch processing jobs that run many sequential queries and benefit from a pre-warmed connection pool.
- Multi-threaded applications where concurrent ClickHouse access requires thread-safe connection management.
- Data pipeline applications that need to balance connection overhead against resource limits.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, with conditions.
The package solves a real problem—connection pooling for ClickHouse—and has low install friction. However, the aging maintenance status (no release in over a year, last commit in early 2026) means you should verify that it remains compatible with your ClickHouse server version and clickhouse-driver release before adopting it in production. The copyleft license requires that your application source be available under compatible terms if distributed.
Install
clickhouse-pool on PyPI
Before you install
Low install friction with a single pure-Python dependency. Maintenance status is aging—last commit was 2026-01-08 and no release in the past year, though the repository remains active and not archived.
Requires a running ClickHouse server instance accessible at the configured host and port.
License in practice
Licensed under LGPL-3.0-or-later (copyleft). Any application linking this package must make its own source code available under compatible terms if distributed.
Quickstart
from clickhouse_pool import ChPool
pool = ChPool(host="localhost")
with pool.get_client() as client:
result = client.execute("SELECT * FROM system.numbers LIMIT 5")
print(result)
pool.cleanup()Verify before relying
- Whether the aging maintenance status (no release since 2025-08-19) indicates active development or dormancy.
- Performance characteristics and scalability limits of the pool under high concurrency.
- Compatibility with recent ClickHouse server versions and breaking changes in clickhouse-driver.
Package facts
| License | LGPL-3.0-or-later copyleft |
| Python support | Supports the current Python release <4.0,>=3.9 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 1 packageclickhouse-driver |
| Maintenance | Aging 360 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 2,101,283 / month, #3,295 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | License :: OSI Approved :: GNU Lesser General Public License v3 or later (LGPLv3+)Programming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.9 |
Evidence: clickhouse_pool-0.6.1-py3-none-any.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 › “clickhouse connection pool”
- clickhouse-poolProvides a thread-safe connection pool for ClickHouse using…
- asynchasynch is an asynchronous ClickHouse driver with native TCP support,…
- clickhouse-driverA native TCP driver for ClickHouse that executes queries and returns…
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 asynch · connection_pool · clickhouse-driver · psycopg2-pool · DBUtils · pondpond · django-clickhouse-backend · clickhouse-sqlalchemy · aiochclient · adafruit-circuitpython-connectionmanager