Cursor rule: Supabase data access & RLS

An auto-attached .mdc rule that enforces the Supabase client split, RLS-first policy work, and typed queries — with a copyable policy snippet.

---
description: Supabase data-access and RLS conventions for app code
globs: app/**/*.ts,app/**/*.tsx,lib/**/*.ts
alwaysApply: false
---

# Supabase access rules

- Server Components and route handlers import from `@/lib/supabase/server`;
  browser code imports from `@/lib/supabase/client`. Never cross the two.
- The service-role client (`@/lib/supabase/admin`) is reserved for webhook
  handlers. If a query fails under RLS, fix the policy - don't switch clients.
- Type every query result from `Database` in `@/lib/database.types`.
- New tables enable RLS in the same migration that creates them:

```sql
alter table public.notes enable row level security;

create policy "notes_owner_all" on public.notes
  for all using (auth.uid() = user_id) with check (auth.uid() = user_id);
```

- Follow @lib/queries/projects.ts for the query-helper pattern: typed arguments,
  narrow `select` lists, `throwOnError`.
- Migrations are append-only: one new numbered file per change.

Estes exemplos são publicados sob CC0. Use livremente, sem atribuição. São fornecidos como estão, sem garantia de qualquer tipo: revise e adapte ao seu projeto antes de usar, pois você é responsável pelo resultado de aplicá-los.