fastapi-database-setup

What problem does it solve?

This Skill provides a clean, reusable setup for an async SQLAlchemy 2.0 engine, a session factory, and a FastAPI dependency to access the database, simplifying database integration in FastAPI apps.

Core Features & Use Cases

• Async engine + session factory with SQLAlchemy 2.0 and PostgreSQL using asyncpg.
• A get_db dependency to inject a database session into FastAPI routers.
• Safe shutdown and explicit session lifecycle management to prevent leaks.

Quick Start

Create src/app/database.py and src/app/dependencies.py as described, then use get_db in your FastAPI routes with Depends(get_db).