sqlalchemy-orm
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, andMapped[T]declarative models; includes async support viaAsyncSessionandAsyncSessionLocal - 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
More from bobmatnyc/claude-mpm-skills
drizzle-orm
Type-safe SQL ORM for TypeScript with zero runtime overhead
4.2Kplaywright-e2e-testing
Playwright modern end-to-end testing framework with cross-browser automation, auto-wait, and built-in test runner
2.7Kpydantic
Python data validation using type hints and runtime type checking with Pydantic v2's Rust-powered core for high-performance validation in FastAPI, Django, and configuration management.
2.2Ktailwind-css
Tailwind CSS utility-first framework for rapid UI development with responsive design and dark mode
1.2Ktrpc-type-safety
tRPC end-to-end type-safe APIs for TypeScript with React Query integration and full-stack type safety
1.1Kpytest
pytest - Python's most powerful testing framework with fixtures, parametrization, plugins, and framework integration for FastAPI, Django, Flask
899