{"id":26836,"library":"clickhouse-toolset","title":"ClickHouse Toolset","description":"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.","status":"active","version":"0.37.dev0","language":"python","source_language":"en","source_url":"https://github.com/your-org/clickhouse-toolset","tags":["clickhouse","database","data-loading","utilities"],"install":[{"cmd":"pip install clickhouse-toolset","lang":"bash","label":"Install from PyPI"}],"dependencies":[{"reason":"Required for ClickHouse connectivity","package":"clickhouse-driver","optional":false},{"reason":"HTTP client for async operations","package":"aiohttp","optional":true}],"imports":[{"note":"Hyphen in package name vs underscore in import path","wrong":"from clickhouse-toolset import ClickHouseClient","symbol":"ClickHouseClient","correct":"from clickhouse_toolset import ClickHouseClient"},{"note":"Function is top-level, not in submodule","wrong":"from clickhouse_toolset.data import load_dataframe","symbol":"load_dataframe","correct":"from clickhouse_toolset import load_dataframe"}],"quickstart":{"code":"from clickhouse_toolset import ClickHouseClient\n\nclient = ClickHouseClient(host='localhost', port=9000, user='default', password='')\nresult = client.execute('SELECT version()')\nprint(result)","lang":"python","description":"Initialize a client and run a simple query."},"warnings":[{"fix":"Pin to a stable release like 0.36.x when available, or use a fork.","message":"The package is in development (0.37.dev0); APIs may break without notice. Avoid pinning to a dev version in production.","severity":"gotcha","affected_versions":">=0.37.dev0"},{"fix":"client.execute('SELECT 1', as_dict=True)","message":"The `execute` method returns raw tuples by default; future versions may return dicts. Use `as_dict=True` for consistency.","severity":"deprecated","affected_versions":">=0.35, <0.38"},{"fix":"For v0.36+: load_dataframe(client, table='my_table', dataframe=df). For older: load_dataframe(df, client, 'my_table').","message":"In version 0.36, the `load_dataframe` function changed its argument order: `table` and `dataframe` swapped positions.","severity":"breaking","affected_versions":"<0.36 vs >=0.36"}],"env_vars":null,"last_verified":"2026-04-27T00:00:00.000Z","next_check":"2026-07-26T00:00:00.000Z","problems":[{"fix":"Use `pip install clickhouse-toolset` and then `from clickhouse_toolset import ...`","cause":"Package name uses hyphen, but Python import uses underscore. Users often try `import clickhouse-toolset`.","error":"ModuleNotFoundError: No module named 'clickhouse_toolset'"},{"fix":"client = ClickHouseClient(host='...', user='default', password='') or password=None if no auth.","cause":"Default password is empty string but sometimes server requires no password, or a different user.","error":"clickhouse_driver.errors.ServerException: Code: 516. DB::Exception: ... Authentication failed: ..."},{"fix":"Convert None to 0 or use a nullable column type in ClickHouse.","cause":"Trying to insert a DataFrame cell with None/NaN into a non-nullable column.","error":"TypeError: Cannot interpret value of type 'NoneType' as a UInt64"}],"ecosystem":"pypi","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}