Sqlalchemy Python Packages

sqlalchemy

The Database Toolkit for Python

alembic

A database migrations tool for SQLAlchemy.

flask-sqlalchemy

Adds SQLAlchemy support to Flask

factory-boy

A test fixtures replacement for Python

pyathena

PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.

sqlmodel

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

aiomysql

aiomysql is a library for accessing a MySQL database from the asyncio

marshmallow-sqlalchemy

SQLAlchemy integration with marshmallow

pyhive

Python interface to Hive and Presto. 🐝

sqlalchemy-jsonfield

SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support

eralchemy

Entity Relation Diagrams generation tool

duckdb-engine

SQLAlchemy driver for DuckDB

clickhouse-sqlalchemy

ClickHouse dialect for SQLAlchemy

pyexcel-io

One interface to read and write the data in various excel formats, import the data into and export the data from databases

sqlalchemy-stubs

Mypy plugin and stubs for SQLAlchemy

databases

Async database support for Python. 🗄

sqlalchemy-trino

Trino (f.k.a PrestoSQL) dialect for SQLAlchemy.

flask-marshmallow

Flask + marshmallow for beautiful APIs

sqlalchemy-adapter

SQLAlchemy Adapter for PyCasbin

alembic-utils

An alembic/sqlalchemy extension for migrating sql views, functions, triggers, and policies

shillelagh

Making it easy to query APIs via SQL

elasticsearch-dbapi

A DBAPI and SQLAlchemy dialect for Elasticsearch

pytest-alembic

Pytest plugin to test alembic migrations (with default tests) and which enables you to write tests specific to your migrations.

sqladmin

SQLAlchemy Admin for FastAPI and Starlette