Sql Python Packages

sqlalchemy

The Database Toolkit for Python

alembic

A database migrations tool for SQLAlchemy.

snowflake-connector-python

Universal driver

databricks-sql-connector

Databricks SQL Connector for Python

snowflake-sqlalchemy

Snowflake SQLAlchemy

sqlglot

Python SQL Parser and Transpiler

pyspark

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

snowflake-snowpark-python

Snowflake Snowpark Python API

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/

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.

sqlmodel

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

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.

sqlfluff

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

sql-metadata

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

dbt-databricks

A dbt adapter for Databricks.

sqlglotrs

Python SQL Parser and Transpiler

chdb

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

fugue

A unified interface for distributed computing. Fugue executes SQL, Python, Pandas, and Polars code on Spark, Dask and Ray without any rewrites.

sqlfluff-templater-dbt

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

eralchemy

Entity Relation Diagrams generation tool

duckdb-engine

SQLAlchemy driver for DuckDB

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.

modin

Modin: Scale your Pandas workflows by changing a single line of code

ibis-framework

the portable Python dataframe library