Supabase
An open-source Firebase alternative built on Postgres: database, auth, storage, and APIs with a hosted product and local dev story.
What it is
Supabase exposes a managed Postgres with auto-generated REST and realtime endpoints, auth, file storage, and dashboard tooling. You can also self-host the stack.
Why it matters
It gives you a full backend baseline quickly without designing every service from scratch. Good for MVPs and teams that want SQL and row-level security options.
When to use it
Use it when Postgres-centric data plus hosted auth and storage fits your product. Re-evaluate if you need exotic compliance, multi-region control, or non-Postgres data models as first-class.
How it fits in the stack
It is backend-as-a-service and data layer: sits behind your client apps and serverless functions. Your frontend framework remains separate; Supabase supplies APIs and policies.
Common confusion
Supabase is not “just auth” or “just a database.” It is an integrated backend surface. It also does not replace application logic in your tier. Business rules still live in your code or DB as you design.