Enforce RLS policies on PostgreSQL tables during migrations.
npx skills add https://github.com/jtucker9/mystuff --skill rls-guardian
Please help me install this Agent Skill. Skill: rls-guardian Source: https://github.com/jtucker9/mystuff/tree/main/skills/security/rls-guardian Command: npx skills add https://github.com/jtucker9/mystuff --skill rls-guardian
Automatically enforces row-level security policies on new or modified PostgreSQL tables during migrations to prevent insecure live schemas.
Apply RLS policy templates to a new or updated table and run migration tests to verify correct enforcement.
High-intent search queries and answers about installing and using this skill.
You can enforce row-level security during migrations by intercepting CREATE TABLE and ALTER TABLE changes to automatically generate complete RLS policy SQL. This ensures FORCE RLS is applied and prevents insecure schema changes in production.
When setting up row-level security for multi-tenant models, classify access patterns such as OWNERSHIP, TENANT, PUBLIC_READ, ADMIN_ONLY, VISIBILITY, and RELATIONSHIP. This classification determines the specific RLS policies generated for each table.
To prevent RLS policy drift when modifying tables, intercept schema changes during migrations to assess and generate complete policy sets. This process flags potential migration gaps for review and ensures FORCE RLS is maintained.
Yes, you can apply RLS policy templates to updated tables by classifying their access patterns and generating complete policy SQL. The templates assess FORCE RLS and performance considerations to ensure access control remains intact during deployment.
You need FORCE RLS in PostgreSQL security policies when table owners must also be subject to row-level restrictions. It is automatically assessed and applied when generating complete RLS policy sets for new or modified tables during migrations.
Automatically generated row-level security policies may flag potential migration gaps that require manual review. Performance considerations for production deployments must be assessed, and complex access patterns might need verification through migration tests.
apakouGenerate and apply SQL migration scripts for Supabase database schemas.
antonpmeGuides Supabase edge functions, schemas, migrations, and RLS policies.
ValyntAudit Supabase migrations for stubs, RLS policies, and idempotency.
GDSDNAudit PostgreSQL tables for Row Level Security status and policies.
