The default for small-to-mid full-stack apps in 2026. Postgres + Auth + Storage + Realtime + Edge Functions in one box, with a sane free tier and a clear self-host path. Pairs especially well with Next.js or Astro hybrid apps. Loses to specialized providers (Neon for serverless branching, Clerk for auth ergonomics) on each individual axis; wins on integration and total cost of ownership.
Supabase is the open-source Firebase alternative that earned its positioning by being good at Postgres first. The bundled auth, storage, realtime, and edge functions are why teams adopt it; the underlying Postgres is why they stay.
What’s in the box
Postgres + Auth (including SSO, MFA, social providers) + Storage (S3-compatible) + Realtime (subscriptions over websockets) + Edge Functions (Deno-based). The Studio UI is the friendliest Postgres admin we’ve worked with.
Where it falls short
Realtime feature parity with Firebase’s mobile SDKs is still catching up. Cold-start latency on the free tier can surprise. Neon beats it on serverless branching ergonomics; Clerk beats it on pure auth UX. For all-in-one full-stack work, the integration trade is usually worth it.