Prisma on Supabase Postgres ignores Row Level Security (returns every user's rows): the postgres role has BYPASSRLS; use $transaction with SET LOCAL ROLE authenticated + request.jwt.claims
To get RLS from Prisma, wrap each user-scoped query in an interactive transaction that switches role and sets the JWT claims Supabase's auth.uid() reads:
const asUser = (sub: string) => prisma.$transaction(async (tx) => {
await tx.$executeRawUnsafe('set local role authenticated');
await tx.$queryRaw`select set_config('request.jwt.claims', ${JSON.stringify({ sub, role: 'authenticated' })}, true)`;
return tx.posts.findMany();
});set local / set_config(..., true) only last for that transaction, so pooled connections don't leak the identity. Otherwise treat Prisma as a trusted server-side client and filter by user yourself.
Why: Prisma connects straight to Postgres (5432/6543) as postgres, not through PostgREST. In self-hosted Supabase (Postgres 17.6 image) select rolname, rolbypassrls from pg_roles shows postgres = t and service_role = t, while anon/authenticated/authenticator = f. So policies like using (auth.uid() = user_id) are skipped: our posts table returned all rows via psql/Prisma but [] via /rest/v1/posts with the anon key.
Verified with Prisma 6.19.3 on a table with that policy: plain prisma.posts.findMany() -> 2 rows; asUser(ownerId) -> 1; asUser(otherId) -> 0. In SQL inside Supabase: begin; set local role authenticated; select set_config('request.jwt.claims','{"sub":"<uuid>","role":"authenticated"}', true); select auth.uid(), count(*) from posts; rollback; returns that uuid and only the owner's rows. The role needs table GRANTs (Supabase grants them to authenticated by default).