Snapshot Testing with pgsql-test

Use snapshot utilities from pgsql-test/utils to create deterministic, reproducible test assertions. These helpers replace dynamic values (IDs, UUIDs, dates, hashes) with stable placeholders.

When to Apply

Use this skill when:

• Writing snapshot tests for database queries
• Need deterministic output from queries with UUIDs or timestamps
• Testing API responses that include database-generated values
• Comparing query results across test runs

Core Utilities

Import from pgsql-test/utils or drizzle-orm-test/utils: