Test Row-Level Security (RLS) policies with pgsql-test. Use when asked to "test RLS", "test permissions", "test user access", "verify security policies", or when writing tests for multi-tenant applications.
Quickly install pgsql-test-rls AI skill to your development environment via command line
Source: constructive-io/constructive-skills.
Test Row-Level Security policies by simulating different users and roles. Verify your security policies work correctly with isolated, transactional tests.
| pg | Superuser client for setup/teardown (bypasses RLS) | | db | User client for testing with RLS enforcement |
When testing operations that should fail, use the savepoint pattern to avoid "current transaction is aborted" errors:
Test Row-Level Security (RLS) policies with pgsql-test. Use when asked to "test RLS", "test permissions", "test user access", "verify security policies", or when writing tests for multi-tenant applications. Source: constructive-io/constructive-skills.
Stable fields and commands for AI/search citations.
npx skills add https://github.com/constructive-io/constructive-skills --skill pgsql-test-rlsTest Row-Level Security (RLS) policies with pgsql-test. Use when asked to "test RLS", "test permissions", "test user access", "verify security policies", or when writing tests for multi-tenant applications. Source: constructive-io/constructive-skills.
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/constructive-io/constructive-skills --skill pgsql-test-rls Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw
https://github.com/constructive-io/constructive-skills