pgsql-test

What problem does it solve?

This Skill provides a comprehensive toolkit for writing reliable integration tests for PostgreSQL databases, ensuring data integrity, security, and correct application behavior.

Core Features & Use Cases

• RLS Policy Testing: Verify Row-Level Security policies to ensure proper data access control for different user roles.
• Test Data Seeding: Load fixtures efficiently using JSON, SQL, or CSV files.
• Exception Handling: Gracefully manage and test expected database errors and transaction rollbacks.
• Snapshot Testing: Create deterministic assertions by pruning dynamic values like IDs and dates.
• Use Case: You need to ensure that only authenticated users can access and modify their own records in a multi-tenant application. This Skill allows you to write tests that simulate various user roles and verify that RLS policies correctly enforce data isolation.

Quick Start

Use the pgsql-test skill to set up database connections and run your PostgreSQL integration tests.