howto-develop-with-postgres
Pass
Audited by Gen Agent Trust Hub on Oct 9, 2026
Risk Level: SAFE
Full Analysis
- [SAFE]: The skill serves as a development guide for PostgreSQL. It implements best practices for transaction management, such as the 'TX_' prefix rule to enforce explicit transaction boundaries.
- [SAFE]: The documentation encourages high-security data practices, specifically recommending ULIDs to prevent ID enumeration attacks and numeric types to avoid rounding errors in financial data.
- [SAFE]: The migration workflow described uses a standard generate-and-review process, explicitly warning against unsafe 'auto-push' workflows in production environments.
- [COMMAND_EXECUTION]: The skill mentions common development CLI tools such as
drizzle-kitandnpm run db:migrate. These are standard tools for managing database schemas and do not represent a security risk in this context.
Audit Metadata