What problem does it solve?
Building Supabase backends securely is hard because authorization must be enforced consistently across SQL tables, API access, auth contexts, and server-side logic.
Core Features & Use Cases
- Row Level Security (RLS) by default: Enforces per-user and per-team access at the database layer to prevent accidental data leaks.
- Edge Functions with authenticated context: Implements server logic in Deno using the caller’s JWT so RLS rules remain effective.
- Auto-generated APIs and typed data: Uses PostgREST and generated TypeScript types to reduce boilerplate and improve correctness.
- Real-time subscriptions and storage access: Supports database change streams plus bucket policies for controlled file operations.
Use case example: you need a multi-tenant app where users can only read and write their own records, trigger server-side workflows for orders, and update clients in real time when their data changes.
Quick Start
Use the supabase skill to design RLS policies for every public table and implement an authenticated Edge Function that updates only rows belonging to the caller.