Skip to content

pleasefixai/clickhouse-best-practices

v1.0.1Apache-2.0

Guides for ClickHouse schemas, queries, ingestion and Cloud services, chDB and ClickStack.

chdb-datastore

Use when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas. Provides chDB DataStore — same pandas API, ClickHouse engine underneath. Also handles reading from S3, MySQL, PostgreSQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake as DataFrames and joining across sources. TRIGGER when: user mentions DataFrame, parquet, csv, "fast pandas", "speed up pandas", or cross-source DataFrame joins; user imports chdb.datastore or from datastore import DataStore. SKIP this skill for raw SQL syntax (use chdb-sql instead), ClickHouse server administration, or non-Python DataStore API work.

Version
4.1
License
Apache-2.0
Compatibility
Requires Python 3.9+, macOS or Linux. pip install chdb.
Read SKILL.md at the source

Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.

Files

Every link opens the file at its source, pinned to the revision this page describes.