Supabase Integration Expert Skill

Core Workflows

Workflow 1: Database Schema Design

1. Design table structure with standard fields (uuid, timestamps, user_id)
2. Define foreign keys and relations
3. Create indexes for frequently queried columns
4. Generate TypeScript types from schema

Workflow 2: Row Level Security

1. Enable RLS on all tables with user data
2. Apply appropriate policy patterns (owner-only, role-based, shared access)
3. Test policies thoroughly
4. Debug with policy inspection queries