supabase-rls · git:20260330.dd1a8a9 · 2026-03-30 · sha256 ed44abc31c3cb7ff
supabase-rls git:20260330.dd1a8a9A
Immutable. This exact content never changes and is served at /api/v1/blob/ed44abc31c3cb7ff.
---
description: Supabase Row Level Security enforcement
globs: ["**/*.sql", "**/supabase/**"]
---
# Supabase Row Level Security (RLS)
ALWAYS assume RLS is enabled. NEVER generate queries that assume admin access by default.
RLS Policy Patterns:
-- Own record only:
```sql
create policy "Users own data" on todos
for all using (auth.uid() = user_id);
```
-- Read-only public:
```sql
create policy "Public read" on posts
for select using (published = true);
```
Code rules:
- ALWAYS use anon/authenticated clients (not `service_role`) for user operations
- Service role client: ONLY use in server-to-server operations (webhooks, cron jobs)
- NEVER pass `service_role` key to the browser
- Use `select('specific, columns')` not `select('*')` for performance