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-kit and npm run db:migrate. These are standard tools for managing database schemas and do not represent a security risk in this context.
Audit Metadata
Risk Level
SAFE
Analyzed
Oct 9, 2026, 02:33 AM