SQLAlchemy
Pass
Audited by Gen Agent Trust Hub on Sep 5, 2026
Risk Level: SAFE
Full Analysis
- [SAFE]: The skill serves as a technical reference for SQLAlchemy 2.0 and FastAPI integration. It correctly demonstrates secure patterns for database interaction.
- [SAFE]: Database session management is handled via FastAPI's
Dependsfor request-scoped sessions, which prevents session leakage. - [SAFE]: Explicitly recommends against returning ORM models directly to API consumers, advocating for Pydantic mapping to prevent accidental data exposure.
- [SAFE]: Promotes the use of
lazy="raise"to prevent N+1 query issues and unintended lazy loading in asynchronous environments, which can lead to application instability.
Audit Metadata