Ask Supabase

Schema Design

• UUIDs as primary keys: gen_random_uuid()
• Always timestamptz (not timestamp), always default now()
• Index foreign key columns and frequently queried columns
• Prefer database-level constraints over application-level validation

Auth

• Session refresh happens in proxy.ts on every request
• Admin client in src/libs/supabase/admin.ts bypasses RLS
• Protected routes: /dashboard/* redirected by proxy.ts

Storage

• Bucket: listing-images, path: {user_id}/{timestamp}.{ext}
• 5MB limit, JPEG/PNG/WebP/GIF only
• RLS policies enforce per-user access

Rules

• Always read src/types/database.ts to understand current schema before giving advice
• Use context7 MCP to fetch latest Supabase docs when needed
• Reference existing patterns in the codebase — don't invent new conventions
• When suggesting schema changes, always include RLS policies
• When suggesting migrations, reference the /db-migrate skill