Sql Python Packages

sqlalchemy

The Database Toolkit for Python

342.1M 12K 2K

alembic

A database migrations tool for SQLAlchemy.

184.6M 4K 384

sqlparse

A non-validating SQL parser module for Python

109.4M 4K 770

snowflake-connector-python

Snowflake Connector for Python

103.6M 732 576

sqlglot

Python SQL Parser and Transpiler

73.8M 10K 1K

pyspark

Apache Spark - A unified analytics engine for large-scale data processing

48.6M 44K 29K

databricks-sql-connector

Databricks SQL Connector for Python

38.1M 235 159

sqlmodel

SQL databases in Python, designed for simplicity, compatibility, and robustness.

24.2M 18K 893

snowflake-sqlalchemy

Snowflake SQLAlchemy

24M 271 170

snowflake-snowpark-python

Snowflake Snowpark Python API

11.8M 341 158

jaydebeapi

JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.

10.3M 381 144

sqlfluff

A modular SQL linter and auto-formatter with support for multiple dialects and templated code.

9.6M 10K 1K

pypika

PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.

8.4M 3K 345

flask-appbuilder

Simple and rapid application development framework, built on top of Flask. includes detailed security, auto CRUD generation for your models, google charts and much more. Demo (login with guest/welcome) - http://flaskappbuilder.pythonanywhere.com/

5M 5K 1K

sql-metadata

Uses tokenized query returned by python-sqlparse and generates query metadata

3.9M 889 130

dbt-databricks

A dbt adapter for Databricks.

3.8M 380 221

sqlglotrs

Python SQL Parser and Transpiler

3.7M 10K 1K

chdb

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

3.4M 3K 136

ibis-framework

the portable Python dataframe library

3.3M 7K 778

sqlfluff-templater-dbt

A modular SQL linter and auto-formatter with support for multiple dialects and templated code.

2.5M 10K 1K

marimo

A reactive notebook for Python — run reproducible experiments, query with SQL, execute as a script, deploy as an app, and version with git. Stored as pure Python. All in a modern, AI-native editor.

2.5M 23K 1K

sqlalchemy-stubs

Mypy plugin and stubs for SQLAlchemy

2.1M 585 96

duckdb-engine

SQLAlchemy driver for DuckDB

2M 497 72

sqlglotc

Python SQL Parser and Transpiler

1.9M 10K 1K