sdlc-fastapi-sqlalchemy-patterns

FastAPI-specific delta on top of sdlc-sqlalchemy-patterns: async engine and AsyncSession lifecycle, get_db dependency injection, async-safe lazy loading rules, async Alembic env.py wiring. Used by fastapi-architect (model definitions) and alembic-specialist (column type finalization and migration generation). Activated automatically by fastapi-plugin/stack.md. Use this skill to: - Manage async database sessions with AsyncSession and async_sessionmaker. - Inject sessions into routes via the get_db() dependency. - Apply async-safe lazy loading (lazy="selectin" or "raise"; never sync lazy loads). - Integrate async Alembic env.py for migration autogeneration. Do NOT use this skill for: - Framework-agnostic model, column, relationship, and querying rules — see sdlc-sqlalchemy-patterns (load it first). - FastAPI routing and Pydantic schemas — see sdlc-fastapi-conventions. - Alembic migration execution (that's alembic-specialist's job) — this skill covers definitions.