Design PostgreSQL Row-Level Security policies with USING and WITH CHECK.
npx skills add https://github.com/juburr/mad-skills --skill postgres-rls-juburr
Please help me install this Agent Skill. Skill: postgres-rls Source: https://github.com/juburr/mad-skills/tree/main/postgres-rls Command: npx skills add https://github.com/juburr/mad-skills --skill postgres-rls-juburr
PostgreSQL Row-Level Security (RLS) enables per-row access control by policies, ensuring sensitive data is only visible or modifiable by authorized users.
Enable RLS on a sample table and implement a basic owner-based policy to observe row-level filtering.
High-intent search queries and answers about installing and using this skill.
PostgreSQL row-level security filters rows per user by combining USING and WITH CHECK policies. You enable RLS on a table and define policies that evaluate ownership constraints to restrict row visibility and validate writes.
Permissive RLS policies use OR logic, allowing access if any policy passes, while restrictive policies use AND logic, requiring all conditions to be met. Combining them enforces complex classification-like gates across tables and views.
Test PostgreSQL RLS policies by enabling row-level security, checking active status with row_security_active(), and running EXPLAIN ANALYZE to validate query plans and security barriers under diverse roles and environments.
PostgreSQL row-level security applies to views and partitions by enforcing policies across underlying data structures. You can implement ownership, group-based access, and classification-like gates spanning tables, views, and partitions.
PostgreSQL RLS performance depends on indexing strategies and security barrier optimization. Use EXPLAIN ANALYZE to validate query plans, ensuring policies do not degrade performance when filtering rows across diverse roles and environments.
Group-based permissions in PostgreSQL RLS are enforced by writing policies that evaluate role membership. Combining permissive and restrictive policies implements fine-grained access control for groups across tables and views.
hyagovianaArchitect Supabase/PostgreSQL schemas with RLS policies and versioned migrations.
rdimascioAnalyze EXPLAIN ANALYZE outputs and optimize Supabase PostgreSQL queries.
LuohaothuIdentify and apply PostgreSQL design patterns for optimized Supabase schemas and queries.
zinohomeEnforce PostgreSQL Row Level Security policies for multi-tenant data isolation.
