sqlalchemy-orm

Installation
Summary

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
SKILL.md

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

Related skills
Installs
871
GitHub Stars
43
First Seen
Jan 23, 2026