chDB DataStore — ClickHouse-backed pandas, one-line speedup
Swap import pandas for chdb.datastore to get a lazy ClickHouse-backed DataFrame API with S3/database connectors and cross-source joins
- What
- Swap import pandas for chdb.datastore to get a lazy ClickHouse-backed DataFrame API with S3/database connectors and cross-source joins
- Cost
- Free
- Needs
- Python 3.9+ on macOS or Linux; pip install chdb in your environment (no Windows support)
- Install
- Copy the installer prompt below into your Muse — your agent does the rest.
Curated by Skill Harbor — @clickhouse's skill for teaching agents the chDB DataStore: a lazy, ClickHouse-backed pandas replacement where changing one import line (`import pandas as pd` → `import chdb.datastore as pd`) keeps existing pandas code working unchanged while operations compile to optimized SQL and execute only when results are needed. The skill covers the decision tree (file analysis, cross-source joins, "pandas too slow", raw SQL → use the chdb-sql skill instead), one-pattern connectors for 16+ sources (local files, MySQL, Postgres, S3, ClickHouse Cloud, Iceberg, Delta Lake), the full pandas API (209 supported methods, with `.to_sql()` to inspect generated SQL), the killer feature of joining DataFrames across different sources, and troubleshooting for common setup issues. Apache-2.0 licensed. Honest caveats: requires Python 3.9+ on macOS or Linux (`pip install chdb`) — no Windows; this skill teaches using DataStore, not ClickHouse server administration or raw SQL authoring; example code in the wild embeds plaintext DB credentials, so prefer the secure vault for connection strings. Skill Harbor never reviews the code, review it yourself before use. Discovered via skills.sh.
Version:
Quick answer
chDB DataStore — ClickHouse-backed pandas, one-line speedup is a free Muse skill that teaches agents the chDB DataStore, a pandas replacement where one import line keeps pandas code working, while operations compile to SQL and execute when results are needed. It covers connectors for 16+ sources, 209 methods, and joining DataFrames, requiring Python 3.9+ on macOS or Linux, no Windows.
Install
Copy the install package below, then paste it into Muse🧪 Install ran in our test sandbox · Nov 11, 2026📌 Pinned version: commit 356a8c1Step 0 — before installing anything: read this install prompt, summarize in a few lines what this build does and what installing it involves, then ask me to confirm before you proceed. Prerequisites: Python 3.9+ on macOS or Linux; pip install chdb in your environment (no Windows support) Install "chDB DataStore — ClickHouse-backed pandas, one-line speedup" for me. It teaches my agent @clickhouse's chDB DataStore: a lazy ClickHouse-backed pandas replacement where one import-line change keeps existing pandas code working while operations compile to optimized SQL; plus connectors for 16+ data sources (files, MySQL, Postgres, S3, ClickHouse Cloud, Iceberg, Delta Lake), 209 supported DataFrame methods, cross-source joins, .to_sql() inspection, and troubleshooting. Apache-2.0 licensed. Repository: https://raw.githubusercontent.com/clickhouse/agent-skills/356a8c1b9a7392adb389a132f5ad3fec38532a03/skills/chdb-datastore/SKILL.md Pinned version: install the code at commit 356a8c1b9a7392adb389a132f5ad3fec38532a03 exactly (Skill Harbor tested this version). Do not substitute a newer version. If this commit is unreachable, stop and tell me. 1. Fetch the SKILL.md file (and any helper files) from the repository path into a temporary folder 2. Safety check: review the SKILL.md and scripts for anything suspicious (unexpected network calls, shell commands, credential harvesting). This repo should contain zero secrets in code, credentials only via the secure vault, allowed hosts declared in the SKILL.md. Verify that holds here; STOP on any red flag and tell me. 3. Install it as a skill: copy SKILL.md and its helper files into the agent's skills directory, in a folder named "chdb-datastore". 4. Verify with no network calls: frontmatter valid, files in place. 5. Report what was installed, where, and what I still need to do myself (e.g. run pip install chdb, and save my database credentials in the vault — never paste them into chat). GitHub is optional: if I have a GitHub account or the gh CLI, you may use it; otherwise public access is fine. Never require it unless it's in the prerequisites above. Rules: don't touch anything outside the temp folder and the install target. If anything looks off, stop and ask me.
Saved to your recent installs. Find it anytime on /connect.
🔒 Security, provenance and what this touches
- It can download and install software packages.
What the scan found — excerpts from the install prompt
- installs packages — Prerequisites: Python 3.9+ on macOS or Linux; pip install chdb in your environment (no Windows support) · Prérequis : Python 3.9+ sur macOS ou Linux ; pip install chdb dans votre environnement (pas de support Windows
The install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
Verification certificate
Dated facts about what was checked for this listing, and how. This is not a safety certification.
- Pinned version
- 356a8c1 · 2026-10-13
- Sandbox install test
- Install ran in our test sandbox · Nov 11, 2026 · Observed during the install test: registry.npmjs.org
- Creator identity
- Not verified
- Fingerprint watch
- Last checked · Nov 19, 2026 : no change detected in the files linked by this install prompt
- Install prompt analysis
- 2026-10-13 : installs packages
Skill Harbor never reviews the code of a listed skill. These are dated facts about the install prompt and our install test, not a safety certification. Review a skill yourself before you install it. How we verify
Questions
How do I install a skill?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the skill up for you — no manual configuration.
Where does my money go?
Straight to the seller. Skill Harbor never processes payments: checkout happens on the seller’s own page, usually Stripe.
What does the ✓ next to a creator’s name mean?
It means we confirmed the identity of the person behind the listing. It says nothing about the code itself — always check a skill before installing it.