{"id":"supabase-api","name":"Supabase REST API","homepage":"https://supabase.com","repo_url":"https://github.com/supabase/supabase","category":"database","subcategories":["postgres","backend-as-a-service","rest-api","realtime","auth"],"tags":["supabase","postgres","rest-api","postgrest","realtime","auth","storage","edge-functions","open-source","management-api","mcp-server"],"what_it_does":"Supabase is an open-source Firebase alternative built on PostgreSQL that auto-generates a RESTful API (via PostgREST) from your database schema. Every table and view immediately gets CRUD endpoints at your-project.supabase.co/rest/v1/. Supabase also provides a Management API for provisioning and managing projects programmatically, a Realtime API for subscribing to database changes, an Auth service (JWT-based), and an official MCP server for AI agent integration. The platform combines multiple services — database, auth, storage, edge functions, and realtime — behind a single project interface, making it particularly powerful for agents that need to manage the full application stack.","use_cases":["Auto-generated REST CRUD API over PostgreSQL tables without writing any backend code","Agent-driven schema changes using the Supabase Management API (create tables, add columns, run migrations)","Real-time data subscriptions for agents monitoring live database changes via WebSocket","User authentication and session management using Supabase Auth with JWT verification","File storage operations via Supabase Storage with auto-generated signed URLs","Multi-project provisioning for multi-tenant SaaS using the Management API"],"not_for":["Non-Supabase PostgreSQL databases (use direct pg drivers or PostgREST self-hosted instead)","Extremely high-throughput OLAP analytics (Supabase PostgreSQL is OLTP-optimized)","Teams requiring on-premise deployment without cloud connectivity","Applications needing sub-10ms latency without read replicas (Supabase has geo-routing but single region by default)"],"best_when":"You want a complete backend platform (database + auth + storage + realtime + API) on top of PostgreSQL, with excellent developer tooling, an auto-generated REST API, and MCP server support for AI agent workflows.","avoid_when":"You only need a PostgreSQL database without the platform features, or you're running on-premise without cloud access.","alternatives":[{"id":"neon-api","reason":"Neon is better for branching-focused workflows; Supabase has the richer full-stack platform"},{"id":"supabase-mcp","reason":"The MCP server variant — prefer supabase-api for REST API automation, supabase-mcp for agent chat integration"},{"id":"planetscale-api","reason":"PlanetScale offers similar branching but is MySQL-only and lacks the full platform features"}],"af_score":82.7,"security_score":80.0,"reliability_score":null,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":"current","last_evaluated":"2026-03-01T09:50:06.268248+00:00","performance":{"latency_p50_ms":30,"latency_p99_ms":200,"uptime_sla_percent":99.9,"rate_limits":"PostgREST API: configurable via max_rows setting. Management API: not publicly documented. Realtime: concurrent connections limited by plan.","data_source":"llm_estimated","measured_on":null}}