Sql Python Packages

sqlalchemy

The Database Toolkit for Python

alembic

A database migrations tool for SQLAlchemy.

snowflake-connector-python

Snowflake Connector for Python

databricks-sql-connector

Databricks SQL Connector for Python

snowflake-sqlalchemy

Snowflake SQLAlchemy

snowflake-snowpark-python

Snowflake Snowpark Python API

sqlglot

Python SQL Parser and Transpiler

pyspark

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

sqlmodel

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

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.

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/

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

sqlfluff-templater-dbt

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

chdb

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

eralchemy

Entity Relation Diagrams generation tool

fugue

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

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

dataset

Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.