---
id: clickhouse-pool
version: "0.6.1"
license: LGPL-3.0-or-later
license_treatment: copyleft
maintenance: aging
---

# clickhouse-pool — a thread-safe connection pool for ClickHouse

License: copyleft · Maintenance: aging · Downloads: 2.1M/mo

## 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 above — verify before relying.

Provides a thread-safe connection pool for ClickHouse using clickhouse-driver, allowing applications to reuse database connections efficiently.

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

pip install clickhouse-pool
uv add clickhouse-pool
poetry add clickhouse-pool

## Installing clickhouse-pool

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.

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()

Requires a running ClickHouse server instance accessible at the configured host and port.

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_current
- Install friction: low
- Maintenance: aging
- Downloads: 2.1M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

clickhouse connection pool, thread-safe database pooling, clickhouse client pooling, connection reuse clickhouse, clickhouse driver wrapper, database connection management, clickhouse pool python, connection-pooling, clickhouse, thread-safe

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