async-sqlmodel

What problem does it solve?

Build an async-first database layer for FastAPI using SQLModel and SQLAlchemy's async features. This skill guides creating async engines, sessions, models, relationships, migrations, and production patterns, enabling scalable, reliable data access in modern Python web apps.

Core Features & Use Cases

• Efficient async models and CRUD operations using SQLModel and AsyncSession.
• Eager loading patterns (selectinload/joinedload) to prevent N+1 queries.
• Production-ready patterns: connection pooling, Alembic migrations, error handling, and FastAPI integration.

Quick Start

Define an async SQLModel model, set up an async engine and session, implement a ServiceBase-based CRUD layer, and wire it into FastAPI endpoints to enable end-to-end async data access.