Open Source Packages
Libraries, frameworks, tools, and SDKs used by the apps in this directory — scored the same way as the apps themselves.
All Packages
Category
Sort:Used by Most Apps
SQLAlchemy
The Python SQL toolkit and Object Relational Mapper that gives developers the full power and flexibility of SQL.
Alembic
Database migrations tool for SQLAlchemy with autogenerate and transactional DDL
clickhouse-connect
ClickHouse's official high-performance Python driver, with native Pandas, NumPy, PyArrow, and Superset support
SQLModel
One model for SQLAlchemy and Pydantic, built by the creator of FastAPI to kill duplicate schema code.
Flask-SQLAlchemy
The official SQLAlchemy integration for Flask, adding scoped sessions, multi-database binds, and Flask-aware model conventions.
aiomysql
A pure-Python async MySQL and MariaDB driver for asyncio, built on top of PyMySQL.
factory_boy
A versatile test fixtures replacement for Python, providing declarative factories for building complex test objects.
duckdb_engine
A SQLAlchemy dialect that lets existing SQLAlchemy code query and manage DuckDB databases unmodified.
PyAthena
A Python DB API 2.0 (PEP 249) client for Amazon Athena, with SQLAlchemy and pandas integration.
Databases
Simple asyncio support for PostgreSQL, MySQL, and SQLite, with queries built using SQLAlchemy Core.
PyHive
Python DB-API and SQLAlchemy interfaces for querying Apache Hive, Presto, and Trino.
FastAPI Pagination
Add page-based and cursor pagination to FastAPI endpoints with a single paginate call.
alembic_utils
Autogenerate Alembic migrations for PostgreSQL views, functions, triggers, and policies straight from your SQLAlchemy models.
SQLAlchemy-JSON
Mutation-tracked JSON column types for SQLAlchemy, including deeply nested changes.
