Audit RLS policies in Postgres
audit_policiesAudit database security policies to identify RLS disabled tables, permissive policies, PUBLIC access, and risky SECURITY DEFINER functions.
Instructions
Connects to the database (read-only queries on pg_class, pg_policies, pg_proc, information_schema) and flags: tables with RLS off but granted to anon/authenticated, policies with using(true) / with check(true), policies without a TO clause (apply to PUBLIC), and SECURITY DEFINER functions executable by anon/authenticated. Needs a Postgres connection string.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| databaseUrl | No | postgres://... connection string (Supabase → Project Settings → Database). Or env DATABASE_URL |