sqlalchemy-orm

SKILL.md

Python SQL toolkit and ORM with modern query builder, relationship mapping, and async support.

Supports SQLAlchemy 2.0 modern API with type hints, select() queries, and Mapped[T] declarative models; includes async support via AsyncSession and AsyncSessionLocal

Covers one-to-many and many-to-many relationships with eager loading patterns (selectinload, joinedload) to prevent N+1 query problems

Integrates with FastAPI via dependency injection, Alembic for schema migrations, and connection pooling with configurable pool size and recycling

Includes CRUD operations, transaction management, batch operations, and testing patterns with pytest and in-memory SQLite

SQLAlchemy ORM Skill

progressive_disclosure:
entry_point:
summary: "Python SQL toolkit and ORM with powerful query builder and relationship mapping"
when_to_use:
- "When building Python applications with databases"
- "When needing complex SQL queries with type safety"
- "When working with FastAPI/Flask/Django"
- "When needing database migrations (Alembic)"
quick_start:
- "pip install sqlalchemy"
- "Define models with declarative base"
- "Create engine and session"
- "Query with select() and commit()"
token_estimate:
entry: 70-85
full: 4500-5500