Clickhouse Python Packages

sqlglot

Python SQL Parser and Transpiler

clickhouse-connect

Python driver/sqlalchemy/superset connectors

clickhouse-driver

ClickHouse Python Driver with native interface support

sqlglotrs

Python SQL Parser and Transpiler

asynch

An asyncio ClickHouse Python Driver with native (TCP) interface support.

chdb

chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse

clickhouse-sqlalchemy

ClickHouse dialect for SQLAlchemy

ibis-framework

the portable Python dataframe library

dbt-clickhouse

The Clickhouse plugin for dbt (data build tool)

openlit

Open source platform for AI Engineering: OpenTelemetry-native LLM Observability, GPU Monitoring, Guardrails, Evaluations, Prompt Management, Vault, Playground. 🚀💻 Integrates with 50+ LLM Providers, VectorDBs, Agent Frameworks and GPUs.

sqlglotc

Python SQL Parser and Transpiler

clickhouse-pool

a thread-safe connection pool for ClickHouse

airflow-clickhouse-plugin

The most popular ClickHouse plugin for Airflow. 🔝 Top-1% downloads on PyPI: https://pypi.org/project/airflow-clickhouse-plugin! Based on mymarilyn/clickhouse-driver.

clickhouse-migrations

Simple migration tool for clickhouse database

jupysql

Better SQL in Jupyter. 📊

django-clickhouse-backend

Django clickhouse database backend.

aiochclient

Lightweight async http(s) ClickHouse client for python 3.6+ with types converting

acryl-sqlglot

Python SQL Parser and Transpiler

aioch

aioch - is a library for accessing a ClickHouse database over native interface from the asyncio

django-clickhouse

This project's goal is to build Yandex ClickHouse database into Django project.

flyql

A lightweight, injection-proof query language for building type-safe SQL filters across Go, Python, and JavaScript.

drt-core

Reverse ETL for the code-first data stack

dltaf

Manifest-driven data loading framework with canonical SQLDB manifests, Airflow helpers, and pluggable private integrations.

pandahouse

Pandas interface for Clickhouse database