> ## Documentation Index > Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-fbfa8bee.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # chDB > chDB is an in-process SQL OLAP Engine powered by ClickHouse export const Image = ({img, alt, size}) => { return {alt} ; }; chDB is a fast in-process SQL OLAP Engine powered by [ClickHouse](https://github.com/clickhouse/clickhouse) v25.8.2.1. You can use it when you want to get the power of ClickHouse in a programming language without needing to connect to a ClickHouse server.

Key features

* **In-process SQL OLAP Engine** - Powered by ClickHouse, no need to install ClickHouse server * **Multiple data formats** - Input & Output support for Parquet, CSV, JSON, Arrow, ORC and [70+ more formats](/reference/formats/index) * **Minimized data copy** - From C++ to Python with [python memoryview](https://docs.python.org/3/c-api/memoryview.html) * **Rich Python Ecosystem Integration** - Native support for Pandas, Arrow, DB API 2.0, seamlessly fits into existing data science workflows * **Zero dependencies** - No need for external database installations * **DataStore API** - Pandas-compatible API with SQL optimization, supporting 630+ methods

DataStore: Pandas-Compatible API

**NEW!** DataStore provides a pandas-compatible API that combines familiar pandas syntax with ClickHouse performance. **Get Started on Hex** * 📖 Getting Started Tutorial — set up your first connection * 🚀 Extended 30-day Hex Trial — full access to ClickHouse integrations

One-Line Migration

```python theme={null} # Just change your import - your pandas code works unchanged - import pandas as pd + from chdb import datastore as pd df = pd.read_csv("data.csv") result = df[df['age'] > 25].groupby('city')['salary'].mean() ```

Performance Highlights

| Operation | pandas | DataStore | Speedup | | ---------------- | ------- | --------- | ---------- | | GroupBy count | 347ms | 17ms | **19.93x** | | Complex pipeline | 2,047ms | 380ms | **5.39x** | | Filter+Sort+Head | 1,537ms | 350ms | **4.40x** | *Benchmarks on 10M rows*

DataStore Features

* **630+ API methods** - 209 pandas DataFrame methods, 185+ accessor methods * **Lazy evaluation** - Operations compile to optimized SQL * **SQL pushdown** - Filters and aggregations run at the data source * **Universal data sources** - Read from files, S3, databases, data lakes Learn more: [DataStore Documentation](/products/chdb/datastore/index)

What languages are supported by chDB?

chDB has the following language bindings: * [Python](/products/chdb/install/python) - [API Reference](/products/chdb/api/python) * [Go](/products/chdb/install/go) * [Rust](/products/chdb/install/rust) * [NodeJS](/products/chdb/install/nodejs) * [Bun](/products/chdb/install/bun) * [C and C++](/products/chdb/install/c)

How do I get started?

* If you're using [Go](/products/chdb/install/go), [Rust](/products/chdb/install/rust), [NodeJS](/products/chdb/install/nodejs), [Bun](/products/chdb/install/bun) or [C and C++](/products/chdb/install/c), take a look at the corresponding language pages. * If you're using Python, see the [getting started developer guide](/products/chdb/getting-started) or the [chDB on-demand course](https://learn.clickhouse.com/user_catalog_class/show/1901178).

For pandas Users

Start with the DataStore API for a familiar pandas experience with ClickHouse performance: * [DataStore Quickstart](/products/chdb/datastore/quickstart) - Installation and one-line migration * [Migration from pandas](/products/chdb/guides/migration-from-pandas) - Step-by-step migration guide * [Pandas Cookbook](/products/chdb/guides/pandas-cookbook) - Common patterns * [Key Differences](/products/chdb/guides/pandas-differences) - Important differences from pandas * [Performance Guide](/products/chdb/guides/pandas-performance) - Optimization tips

DataStore API Reference

* [Factory Methods](/products/chdb/datastore/factory-methods) - Create from files, databases, cloud storage * [Query Building](/products/chdb/datastore/query-building) - SQL-style operations * [Pandas Compatibility](/products/chdb/datastore/pandas-compat) - 209 compatible methods * [Accessors](/products/chdb/datastore/accessors) - .str, .dt, .arr, .json, .url, .ip, .geo * [Configuration](/products/chdb/configuration/index) - Engine, logging, profiling * [Debugging](/products/chdb/debugging/index) - explain(), profiling, logging

SQL API Guides

* [Python API Reference](/products/chdb/api/python) - Complete SQL API documentation * [JupySQL](/products/chdb/guides/jupysql) * [Querying Pandas](/products/chdb/guides/querying-pandas) * [Querying Apache Arrow](/products/chdb/guides/querying-apache-arrow) * [Querying data in S3](/products/chdb/guides/querying-s3-bucket) * [Querying Parquet files](/products/chdb/guides/querying-parquet) * [Querying remote ClickHouse](/products/chdb/guides/query-remote-clickhouse) * [Using clickhouse-local database](/products/chdb/guides/clickhouse-local)

An introductory video

Watch a brief introduction to chDB and learn how it brings ClickHouse's power to your Python environment: