supabase-expert

Supabase authentication handles user sign-up, login, and session management through built-in auth providers and RLS policies. Configure auth flows using the JavaScript, Python, or Flutter client libraries, then enforce row-level security (RLS) on PostgreSQL tables to control data access by user role.

Supabase real-time subscriptions let you listen to database changes and stream updates to clients instantly. Use the client libraries to subscribe to table changes, and Supabase will broadcast INSERT, UPDATE, and DELETE events in real time across connected applications.

Supabase Storage provides object storage for files, images, and documents with built-in access controls. Upload, retrieve, and manage files through the client libraries, and combine storage with RLS to restrict file access by user or role.

Supabase supports pgvector for semantic search using embeddings. Store vector embeddings alongside your data, then query using similarity search to find semantically related results—ideal for recommendation engines and intelligent search features.

Supabase Edge Functions are serverless TypeScript functions deployed globally. Write functions that respond to HTTP requests or database triggers, deploy them through the Supabase CLI, and integrate them with your application for custom logic and webhooks.

Supabase is built on PostgreSQL and supports both SQL queries and client library abstractions. Use the JavaScript, Python, or Flutter SDKs for common operations, or write raw SQL directly for complex migrations, stored procedures, and performance-critical queries.