Repair and optimize SQLAlchemy 2.x ORM and Core code for performance and transactions.
npx skills add https://github.com/led8/.codex --skill sqlalchemy-led8
Please help me install this Agent Skill. Skill: sqlalchemy Source: https://github.com/led8/.codex/tree/main/skills/sqlalchemy Command: npx skills add https://github.com/led8/.codex --skill sqlalchemy-led8
Provide clear, actionable guidance to design, review, and troubleshoot SQLAlchemy 2.x ORM and Core code, reducing runtime errors, N+1 queries, session/transaction misuse, and async/sync pitfalls.
Review this SQLAlchemy code for N+1 issues, incorrect transaction/session usage, and async/sync mixing, then provide corrected examples and recommended loader strategies.
High-intent search queries and answers about installing and using this skill.
Resolve N+1 queries in SQLAlchemy 2.x by applying loader strategies like selectinload and joinedload to optimize relationship loading and eliminate redundant database queries during code review.
Configure async SQLAlchemy by using async_sessionmaker for consistent session creation and tuning connection pool settings to prevent pool exhaustion and avoid async/sync mixing in request handlers.
Manage transaction boundaries in SQLAlchemy by using explicit transaction controls and proper session lifecycle handling to prevent transactional errors and ensure database integrity in backend Python services.
Use SQLAlchemy Core instead of the ORM when executing bulk operations or tuned SQL queries that require direct database interaction without the overhead of object-relational mapping abstractions.
SQLAlchemy async sessions throw errors when mixing sync and run_sync operations due to improper async engine configuration, requiring run_sync bridging to safely execute blocking database calls within async request handlers.
Review SQLAlchemy code for performance regressions by checking select() and Session.execute() usage, validating explicit transaction boundaries, and diagnosing session lifecycle issues to ensure production stability.
roderikDefine Drizzle ORM schemas and migrations for PostgreSQL databases.
sigmadigitalzaReview database schemas, migration files, and query performance.
knopkiImplement FastAPI async route handlers, background tasks, and streaming responses.
cathayriskProvide SQLAlchemy patterns for safe database operations in Python.
