supabase-best-practices

Comprehensive security and performance optimization guide for Supabase applications with Clerk authentication integration. Contains 40+ rules across 10 categories, prioritized by impact to guide secure development and code review. Reference these guidelines when: Read individual rule files for detailed explanations and code examples: Each rule file contains: For the complete guide with all rules expanded: references/supabase-guidelines.md - Setting up a new Supabase project - Integrating Clerk authentication with Supabase - Writing Row Level Security (RLS) policies - Designing database schemas - Implementing real-time features - Configuring Storage buckets - Writing Edge Functions - Reviewing code for security issues - rls-always-enable - Always enable RLS on public schema tables - rls-wrap-functions-select - Wrap auth functions with (SELECT ...) for performance - rls-add-indexes - Add indexes on columns used in RLS policies - rls-specify-roles - Specify roles with TO authenticated clause - rls-security-definer - Use SECURITY DEFINER functions for complex policies - rls-minimize-joins - Minimize joins in RLS policies - rls-explicit-auth-check - Use explicit auth.uid() checks - rls-restrictive-policies - Use RESTRICTIVE policies for additional constraints - clerk-setup-third-party - Use Third-Party Auth integration (not JWT templates) - clerk-client-server-side - Use...