Automate Supabase Row Level Security validation with pgTAP tests.
npx skills add https://github.com/nghiahsgs/taw-kit --skill testing-rls-pgtap
Please help me install this Agent Skill. Skill: testing-rls-pgtap Source: https://github.com/nghiahsgs/taw-kit/tree/main/skills/testing-rls-pgtap Command: npx skills add https://github.com/nghiahsgs/taw-kit --skill testing-rls-pgtap
Validate Supabase Row Level Security policies by automatically generating and executing pgTAP tests to ensure correct data access boundaries for tenants, admins, and anonymous users.
Run the pgTAP test suite against your Supabase project to verify RLS policy behavior.
High-intent search queries and answers about installing and using this skill.
To test Supabase Row Level Security policies, you can use pgTAP to automate validation of data access boundaries. This Skill generates deterministic test suites that verify owner vs. non-owner access and admin visibility for authenticated and anonymous users.
Automating pgTAP tests for Postgres RLS policies involves auto-detecting tables and policies from your Supabase migrations. This approach builds targeted tests to ensure correct data access boundaries for tenants and admins, producing deterministic results runnable via Supabase CLI or local PostgreSQL.
Yes, you can run pgTAP tests for Supabase RLS in a local PostgreSQL environment. The generated test suites are deterministic and can be executed using either the Supabase CLI or a local PostgreSQL setup, provided pgTAP and Supabase config are present.
Yes, you need pgTAP installed to validate Supabase database security policies using this approach. The Skill requires a project with Supabase configuration and the pgTAP extension to auto-detect tables and generate test suites for RLS policy validation.
Supabase RLS policies allowing access for non-owner users indicate a misconfiguration in data access boundaries. Using pgTAP tests to validate owner vs. non-owner access for authenticated users helps identify and isolate these policy failures across your database tables.
SaschaLehAutomate Supabase PostgreSQL database testing with pgTAP.
marvinbissCreate a Supabase test user to audit authenticated access and detect IDOR vulnerabilities.
CenredJunDesign and debug Supabase Row Level Security policies and database migrations.
dirnbauerApply PostgreSQL and Supabase best practices for query optimization, indexing, RLS policies, and diagnostics.
