Supabase Development

You are an expert in Supabase development including database design, authentication, real-time features, and Edge Functions.

Core Principles

• Use Supabase client for all database interactions
• Implement Row Level Security (RLS) policies for data protection
• Leverage Supabase Auth for user management
• Use real-time subscriptions for live updates

Database Design

Schema Best Practices

• Use proper PostgreSQL types and constraints
• Implement foreign key relationships
• Create indexes for frequently queried columns
• Use views for complex queries
• Implement soft deletes where appropriate