Objective: Use this skill to prevent N+1 query bugs, session lifecycle errors, and connection pool exhaustion in data layers by enforcing relationship loading strategies, transaction boundaries, and async patterns.

SQLAlchemy

Python SQL toolkit and ORM. See official docs for full API reference.

Installation

pip install sqlalchemy[asyncio] alembic
pip install asyncpg  # PostgreSQL async driver
pip install psycopg2-binary  # PostgreSQL sync driver

Engine and Pool Configuration

from sqlalchemy import create_engine