Supabase Template

Query rows via PostgREST. Filter with query params: 'column=eq.value', 'column=gt.5', 'column=in.(a,b,c)'. Select specific columns with 'select=id,name'. Order with 'order=created_at.desc'. RLS policies apply unless using service_key. Paginate with 'offset' and 'limit' (max 1000).

https://{project_ref}.supabase.co/rest/v1/{table}?select=*&limit=20

Admin endpoint: list all auth users with id, email, phone, provider (email/google/github), email_confirmed_at, last_sign_in_at, created_at, and user_metadata object. Requires service_role key. Paginate with 'page' and 'per_page' (default 50, max 1000).

https://{project_ref}.supabase.co/auth/v1/admin/users

List all storage buckets with id, name, public flag (true = no auth for downloads), file_size_limit (bytes), allowed_mime_types array, and created_at. Public buckets serve files at /storage/v1/object/public/{bucket}/{path}.

https://{project_ref}.supabase.co/storage/v1/bucket

List objects in a bucket. Returns name, id, size (bytes), content_type, created_at, and last_accessed_at. Pass 'prefix' in body to filter by folder path. Nested folders appear as objects with metadata.mimetype = null. Max 100 per request, paginate with 'offset'.

https://{project_ref}.supabase.co/storage/v1/object/list/{bucket}

Insert a row into any table. Body is JSON with column:value pairs matching your schema. 'Prefer: return=representation' returns the created row with auto-generated columns (id, created_at). For bulk insert, pass an array of objects. Unique constraint violations return 409.

https://{project_ref}.supabase.co/rest/v1/{table}