sqlalchemy - Build async SQLAlchemy 2.0 data layers
Provides patterns for defining ORM models, writing async queries, managing sessions and transactions, loading relationships, and handling Alembic migrations.
Tags
Updated: 2026-09-28Typical Outputs
What this skill does
- Define ORM models
- Write async queries
- Manage async sessions
- Load relationships explicitly
- Manage database transactions
- Perform bulk operations
- Create Alembic migrations
- Debug Alembic migrations
- Convert ORM entities
Inputs
- Database connection URL
- ORM model definitions
- Query requirements
- Relationship loading requirements
- Migration changes
Outputs
- ORM model code
- Query results
- Transaction state changes
- Alembic migration scripts
- Database schema changes
Requirements
- Python environment
- SQLAlchemy 2.0
- Async database driver
- asyncpg for PostgreSQL
- Alembic for migrations