fix-sqlalchemy-pending-rollback-loop

What problem does it solve?

Addresses the issue of PersistentRollbackError loops in FastAPI/SQLAlchemy async services, caused by unhandled exceptions not properly rolling back transactions.

Core Features & Use Cases

• Automatic Rollback on Exception: Ensures the session is rolled back on error to maintain a clean session state.
• Prefer Transaction Context Managers: Encourages using transaction context managers for multi-step operations for automatic rollback and commit.
• API Layer Exception Handling: Adds error handling in API endpoints to manage session issues without cascading to subsequent requests.
• Dependency-Level Defense: Implements rollback logic in session dependencies to prevent issues when services are called in rapid succession.

Quick Start

Add this Skill to your FastAPI/SQLAlchemy application to automatically manage and resolve session rollbacks caused by unhandled exceptions.