fastapi-sqlalchemy

What problem does it solve?

Senior developers often struggle to implement robust, asynchronous data access in FastAPI with SQLAlchemy 2.0 and consistently manage migrations. This skill provides a curated set of patterns and practices to streamline session lifecycles, repository usage, and zero-downtime migrations.

Core Features & Use Cases

• Async-first data access using create_async_engine and async_sessionmaker for non-blocking I/O.
• Repository pattern and type-safe queries to keep business logic clean and testable.
• Alembic-based migrations with best practices for safe, zero-downtime schema changes.
• Use cases include building reliable FastAPI endpoints that interact with PostgreSQL/SQL databases and migrating schemas in production.

Quick Start

Create a FastAPI app that uses Async SQLAlchemy 2.0, then wire a repository into a route to perform a simple CRUD flow.