chdb
chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse
chDB is an in-process OLAP SQL engine powered by ClickHouse that can be integrated into AI coding agents through dedicated agent skills. It provides two distinct skills—chdb-datastore (a pandas-compatible API) and chdb-sql (direct SQL querying)—that enable AI assistants like Cursor, Claude Code, and Codex to generate correct chdb code out of the box. The skills allow agents to perform high-performance analytics on Parquet, CSV, JSON, Arrow files, and databases without installing a separate server. chDB also supports WebAssembly execution, UDFs, streaming queries, and direct integration with frameworks like LlamaIndex, Pydantic AI, and MCP.
Key Features
Use Cases
- 01Teach AI coding assistants to generate high-performance data analysis code using chdb
- 02Enable agents to query large datasets (Parquet, CSV, JSON) with ClickHouse performance without server setup
- 03Replace pandas in existing AI-generated code to achieve SQL-level speed on large data
- 04Build AI-powered data pipelines that query S3, databases, and local files using natural language
- 05Create browser-based SQL analytics tools using the WebAssembly build
- 06Integrate ClickHouse analytics capabilities into agent frameworks like LlamaIndex and Pydantic AI
Related Skills
View moresuperpowers
An agentic skills framework & software development methodology that works.
skills
Skills for Real Engineers. Straight from my .agents directory.
skills
Public repository for Agent Skills
ponytail
Makes your AI agent think like the laziest senior dev in the room. The best code is the code you never wrote.
chdb — FAQ
What are the chdb AI agent skills?+
chDB provides two agent skills: chdb-datastore, which teaches agents to use the pandas-compatible DataStore API, and chdb-sql, which teaches in-process SQL querying. These skills enable AI coding assistants to generate correct chdb code automatically.
How do I install the chdb agent skills?+
Run the installation script with 'curl -sL https://raw.githubusercontent.com/chdb-io/chdb/main/install_skill.sh | bash' to install both skills for your AI assistant. For project-level installation (shared with your team), add the '--project' flag.
Which AI assistants work with chdb skills?+
chDB skills work with Cursor, Claude Code, Codex, Windsurf, and other AI coding agents that support skill/capability systems. The package also integrates with LlamaIndex, Pydantic AI, smolagents, and MCP-compatible agents.
Do I need API keys or a ClickHouse server?+
No API keys or ClickHouse server installation are required. chDB runs entirely in-process. The optional AI-assisted SQL generation feature requires an OpenAI or Anthropic API key, configured via environment variables.
Is chdb free to use?+
Yes, chDB is open source under the Apache 2.0 license. The Python package can be installed via pip for free, and the WebAssembly version runs in browsers with no cost.
What file formats and data sources does chdb support?+
chDB supports 60+ formats including Parquet, CSV, JSON, Arrow, and ORC. It can query local files, S3 buckets, MySQL, PostgreSQL, SQLite, MongoDB, ClickHouse, HDFS, Azure, and GCS without data movement.
How do I install chdb?+
Open the source repository on GitHub and follow its README. chdb is a skill — MCP Agents Market links you directly to the official repo.
Is chdb free?+
chdb is an open-source project hosted on GitHub. Check the repository for its license and any usage requirements.