PL/pgSQL procedures for simulating Supabase authenticated and anonymous roles while testing row-level security policies.
pgext.cloud · Documentation · Control file
| Package | mansueli-rls_helpers |
|---|---|
| Version | 1.0.0 |
| Repository | Unspecified |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | auth |
| Latest release | 2024-05-16 |
| Catalogue updated | 2026-07-30 |
| plpgsql | PL/pgSQL procedural language |
| custom_roles | Role-specific Supabase RLS tables and functions for managing user roles. |
| custom_properties | Supabase RLS helper tables and functions for managing user properties and custom claims. |
| supabase_auth_apikey | Supabase Auth API-key helpers for creating, deleting, validating, and authorizing user API keys. |
| keyhippo | RLS-compatible API keys for PostgreSQL |
| rls_oso | PoC postgres plugin to use oso authorization in row level security policies |
| pgho_permissions | Hierarchical RBAC and ABAC authorization for PostgreSQL and Supabase, designed for use in row-level-security policies. |
| pgzan | Proof-of-concept pgrx extension for evaluating Zanzibar-style authorization inside PostgreSQL row-level security policies. |
| supabase | A friendly playground for building and validating Supabase Row‑Level Security (RLS) |