Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more! Learn more →
Top 16 Python Clickhouse Projects
-
Project mention: Show HN: SQL-tString a t-string SQL builder in Python | news.ycombinator.com | 2025-05-16
https://github.com/tobymao/sqlglot :
> SQLGlot is a no-dependency SQL parser, transpiler, optimizer, and engine [written in Python] . It can be used to format SQL or translate between 24 different dialects like DuckDB, Presto / Trino, Spark / Databricks, Snowflake, and BigQuery. It aims to read a wide variety of SQL inputs and output syntactically and semantically correct SQL in the targeted dialects.
-
Sevalla
Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!
-
Project mention: Why Pandas feels clunky when coming from R (2024) | news.ycombinator.com | 2025-06-07
pandas* per the style guide (nobody follows it)
also I recommend trying Ibis. created by the creator of pandas originally and solves so many of the issues
https://ibis-project.org
-
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.
OpenLIT is an OpenTelemetry-native observability tool built for AI Engineering and LLM applications. It focuses on easy, vendor-neutral instrumentation for LLMs, vector databases, and other AI stack components. OpenLIT is ideal for teams already heavily invested in OpenTelemetry and GPU monitoring but offers fewer features for LLM prompt evaluation and experimentation.
-
-
-
-
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
-
boxball
Prebuilt Docker images with Retrosheet's complete baseball history data for many analytical frameworks. Includes Postgres, cstore_fdw, MySQL, SQLite, Clickhouse, Drill, Parquet, and CSV.
-
-
quackflight
DuckDB API Server with Arrow Flight SQL Airport support and concurrent writes/reads (quackpipe)
-
-
Project mention: Show HN: DbCls is a versatile terminal client that supports various databases | news.ycombinator.com | 2025-04-09
-
insert-tools
CLI tool for inserting SELECT query results into ClickHouse with automatic schema matching and type-safe casting. Ideal for ETL pipelines and SQL-driven data flows.
Project mention: Show HN: Insert-tools – bulk insert with schema check and column match in CH | news.ycombinator.com | 2025-05-17 -
csv2clickhouse
Fast way to upload data from CSV files into ClickHouse. This script automates the process of creating database and tables in ClickHouse and uploading data from CSV files into those tables.
-
analytics_benchmark
Benchmark suite for analytical DBs using real-world SQL queries, Docker-based automation, and reproducible tests. Tailored for comparing systems like Apache Doris and ClickHouse with realistic datasets and actionable insights.
Project mention: New Benchmark suite for analytical DBs using real-world SQL queries | news.ycombinator.com | 2025-07-15 -
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
Python Clickhouse discussion
Python Clickhouse related posts
-
Revival Hijacking: How Deleted PyPI Packages Become Threats
-
Show HN: DbCls is a versatile terminal client that supports various databases
-
Modern Polars – A side-by-side comparison of the Polars and Pandas libraries
-
The Polars vs. Pandas difference nobody is talking about – Labs
-
DuckDB over Pandas/Polars
-
SQL Tips and Tricks
-
tea-tasting: a Python package for the statistical analysis of A/B tests
-
A note from our sponsor - Sevalla
sevalla.com | 1 Sep 2025
Index
What are some of the best open-source Clickhouse projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | sqlglot | 8,218 |
| 2 | ibis | 6,065 |
| 3 | openlit | 1,832 |
| 4 | clickhouse-driver | 1,271 |
| 5 | jupysql | 795 |
| 6 | clickhouse-grafana | 752 |
| 7 | dbt-clickhouse | 309 |
| 8 | clickhouse-sink-connector | 277 |
| 9 | boxball | 126 |
| 10 | django-clickhouse | 106 |
| 11 | quackflight | 97 |
| 12 | pgwarehouse | 84 |
| 13 | dbcls | 23 |
| 14 | insert-tools | 8 |
| 15 | csv2clickhouse | 6 |
| 16 | analytics_benchmark | 6 |
Sponsored
Deploy and host your apps and databases, now with $50 credit!
Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!
sevalla.com