Agent Interface
REST API (PostgREST)GraphQL (pg_graphql)Realtime WebSocketManagement APIMCP Server (community)
What an agent can do
- ✓Full CRUD on any database table via auto-generated REST API
- ✓Run raw SQL queries via the SQL editor API
- ✓Manage authentication users and sessions
- ✓Upload and serve files from Supabase Storage
- ✓Subscribe to real-time database changes via WebSocket
- ✓Invoke Edge Functions (serverless TypeScript)
What it can't do
- ✗Modify database extensions or PostgreSQL config via REST
- ✗Access Supabase Dashboard UI settings programmatically
- ✗Manage organization billing via API
- ✗Create or modify database migrations via API (use CLI)
- ✗Access Supabase AI (pgvector) indexing controls via REST
Auth Model
API Key (anon + service_role)JWT (user auth)Management API Bearer Token
Builder Notes
Open-source Firebase alternative with a strong agent story. Auto-generated REST API from PostgreSQL schema eliminates manual endpoint maintenance. Realtime subscriptions enable event-driven agents. Row-Level Security provides fine-grained access control for multi-tenant agent systems.
Sources
Last verified: 2026-03-15