Context Async Sqlalchemy

It is framework-agnostic and works with any async Python web framework; commonly used with ASGI frameworks such as FastAPI and Starlette.

Middleware prepares a context container and sessions are created lazily; the middleware will automatically commit or roll back open transactions and close sessions after the request, while manual commit/rollback/close remains supported.

Yes. The library provides tools for running concurrent SQL queries and supports multiple databases, multiple sessions per database, and runtime host switching including master/replica setups.

Yes. Its lazy initialization and context-based session management make it convenient for tests, allowing either automatic lifecycle handling or explicit control when needed.