Python Clickhouse

Open-source Python projects categorized as Clickhouse

Top 11 Python Clickhouse Projects

  • MindsDB

    MindsDB is a Server for Artificial Intelligence Logic. Enabling developers to ship AI powered projects to production in a fast and scalable way.

    Project mention: Eva AI-Relational Database System | | 2023-05-12
  • sqlglot

    Python SQL Parser and Transpiler

    Project mention: Need help in converting Presto SQLs to Hive SQL | | 2023-05-08

    ONLYOFFICE Docs — document collaboration in your environment. Powerful document editing and collaboration in your app or environment. Ultimate security, API and 30+ ready connectors, SaaS or on-premises

  • ibis

    The flexibility of Python with the scale and performance of modern SQL.

    Project mention: Thoughts About Snowpark? | | 2023-05-16

    Use Ibis and you won't have to worry about migrating to a vendor-specific python framework anymore. It connects to Snowflake, Spark, and many other engines you may want to interact with.

  • clickhouse-driver

    ClickHouse Python Driver with native interface support

  • jupysql

    Better SQL in Jupyter. 📊

    Project mention: Evidence – Business Intelligence as Code | | 2023-04-20

    If anyone is looking for something like this in Python/Jupyter, check out JupySQL:

  • dbt-clickhouse

    The Clickhouse plugin for dbt (data build tool)

  • django-clickhouse

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

    Project mention: how do I store and process user interactions and footprint via DRF | | 2022-08-16

    Clickhouse would be a good open source alternative for analytics data. There's a django package for it here

  • InfluxDB

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  • 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.

  • pgwarehouse

    Easily sync your Postgres database to a Snowflake, ClickHouse, or DuckDB warehouse.

    Project mention: Easy way to get Postgres data into Snowflake | | 2023-03-22

    I recently open sourced this package to sync Postgres tables into Snowflake:

  • chdb-server

    Demo Server for chDB, an in-process SQL OLAP Engine powered by ClickHouse

    Project mention: ServerLess OLAP with Chdb | | 2023-04-19
  • 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.

    Project mention: Fast way to upload several CSV files -> ClickHouse with create a database and tables | | 2023-04-20

    This is how this script was born, which I want to share. I hope it saves you some time, and it will give me the opportunity to receive a couple of feedbacks and ideas from you for improvement.

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). The latest post mention was on 2023-05-16.

Python Clickhouse related posts


What are some of the best open-source Clickhouse projects in Python? This list will help you:

Project Stars
1 MindsDB 16,266
2 sqlglot 3,294
3 ibis 2,765
4 clickhouse-driver 1,035
5 jupysql 310
6 dbt-clickhouse 152
7 django-clickhouse 95
8 boxball 81
9 pgwarehouse 36
10 chdb-server 8
11 csv2clickhouse 2
Write Clean Python Code. Always.
Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.