sqlmodel

SQLModel unifies SQLAlchemy ORM models and Pydantic schemas into a single source of truth for FastAPI projects. This eliminates boilerplate by allowing one model definition to serve both database operations and API data validation.

Setting up async database sessions with SQLModel involves integrating FastAPI routes with async session handlers to execute CRUD operations. This approach supports type-safe models and automatic API documentation across small to large codebases.

SQLModel supports defining one-to-many and many-to-many relationships within your data models. You can create minimal models with these relationships to structure relational data effectively before scaffolding FastAPI routes.

Alembic database migrations work with FastAPI and SQLModel to manage schema changes across large codebases. You apply Alembic to generate and run migrations after creating your unified SQLModel definitions.

Avoid a unified ORM and API schema approach when your API validation requirements drastically diverge from your database structure. If your endpoints need highly distinct data transformations, separating Pydantic schemas from SQLAlchemy models reduces model coupling.

Rapidly scaffold end-to-end APIs by installing SQLModel, creating minimal models with relationships, and building FastAPI routes for CRUD operations. This yields type-safe models and automatic documentation without separate schema boilerplate.