pgsql-test (PostgreSQL Integration Testing)

pgsql-test provides a complete testing toolkit for PostgreSQL — from RLS policy verification and test seeding to snapshot utilities and complex multi-client scenario management. All tests run in transactions with savepoint-based isolation.

When to Apply

Use this skill when:

• Testing RLS policies: Verifying user isolation, role-based access, multi-tenant security
• Seeding test data: Loading fixtures with loadJson, loadSql, loadCsv
• Testing exceptions: Handling aborted transactions when operations should fail
• Snapshot testing: Deterministic assertions with pruneIds, pruneDates, etc.
• Building helpers: Reusable test functions, constants, assertion utilities
• JWT context: Simulating authenticated users with claims for RLS
• Complex scenarios: Multi-client patterns, transaction management, cross-connection visibility

Quick Start