Registry / database / clickhouse-toolset

clickhouse-toolset

library0.37.dev0pypypiunverified

A collection of tools and utilities for working with ClickHouse databases, including data loading, schema management, and query helpers. Current version 0.37.dev0 (development), with regular releases. Targets Python >=3.8, <3.14.

database

pip install clickhouse-toolset

package ↗homepage ↗

INSTALL

IMPORT

SIG · CLICKHOUSE-TOOLSET

clickhouse-toolset

databasepythonv0.37.dev0

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

ClickHouseClient

✓ from chtoolset import ClickHouseClient

✗ from chtoolset import ClickHouseClient

Initialize a client and run a simple query.

from clickhouse_toolset import ClickHouseClient client = ClickHouseClient(host='localhost', port=9000, user='default', password='') result = client.execute('SELECT version()') print(result)

clickhouse-toolset --version

Debug

Known issues

gotchaThe package is in development (0.37.dev0); APIs may break without notice. Avoid pinning to a dev version in production.

fix

Pin to a stable release like 0.36.x when available, or use a fork.

affects: >=0.37.dev0

deprecatedThe `execute` method returns raw tuples by default; future versions may return dicts. Use `as_dict=True` for consistency.

fix

client.execute('SELECT 1', as_dict=True)

affects: >=0.35, <0.38

breakingIn version 0.36, the `load_dataframe` function changed its argument order: `table` and `dataframe` swapped positions.

fix

For v0.36+: load_dataframe(client, table='my_table', dataframe=df). For older: load_dataframe(df, client, 'my_table').

affects: <0.36 vs >=0.36

Upgrade

Version history

0.37.dev0latest on PyPI · released Apr 28, 2025

Audit

Dependencies

clickhouse-driverrequiredRequired for ClickHouse connectivity

aiohttpoptionalHTTP client for async operations

Agent activity

5 hits · last 30 days

node

OpenAI (training)

Resources

packagehttps://pypi.org/project/clickhouse-toolset/ ↗

homepagehttps://gitlab.com/tinybird/clickhouse-toolset ↗