Supabase Review

The pitch that made Supabase popular is simple and mostly true: you get Firebase's speed of setup without Firebase's lock-in, because underneath it is just Postgres. Your data lives in tables you can query with SQL, dump with pg_dump and move somewhere else.

That single design decision is why a lot of teams who once reached for Firebase now reach for this instead. This review covers what you actually get at each tier and where the bill surprises people.

Supabase is an open-source backend platform built on PostgreSQL.

Every project provisions a real Postgres database, then wraps it in the services an application needs: an auto-generated REST and GraphQL API, authentication with social and enterprise providers, row-level security policies enforced in the database itself, file storage, realtime subscriptions over websockets, edge functions running Deno, and vector search for AI features.

The whole stack is open source and self-hostable, which is the practical exit route if the hosted pricing stops working for you.

You create a project and get a Postgres instance plus a dashboard with a table editor and SQL editor. Client libraries for JavaScript, Flutter, Python, Swift and others talk to the auto-generated API, so a working CRUD app needs no backend code.

Access control is the part worth understanding: instead of writing an authorisation layer, you write row-level security policies in SQL that the database enforces on every query, no matter which client sends it.

Migrations are managed through the CLI and versioned in your repo, and edge functions handle the logic that does not belong in the client.

Supabase publishes list prices: a free plan at $0, Pro at $25 per month, and Team at $599 per month. Enterprise is a custom quote. Firebase Blaze is pay-as-you-go above the free Spark tier, Neon Launch bills $0.106 per CU-hour with no monthly minimum, and Appwrite Pro charges the same entry fee as Supabase, per project. PlanetScale has no free tier, and its single-node Postgres starts at $5 a month.

The cheapest entry is Supabase's free plan, then Pro at $25 a month, but that fee is a base, not a cap: overage is roughly $0.00325 per extra monthly active user, $0.125 per GB of disk, $0.09 per GB of egress, and $0.0213 per GB of file storage.

Costs jump on egress for image-heavy apps, and again on Team, where SOC 2 and ISO 27001 sit.

Supabase suits startups and product teams building a normal web or mobile application on relational data, particularly anyone who values SQL and wants an exit path. It is excellent for AI products, since pgvector lives in the same database as everything else.

It is also a strong choice for solo developers, because the free tier genuinely supports a real prototype.

It is a weaker fit for applications with unpredictable heavy egress on a tight budget, for teams needing hard multi-region write latency guarantees, and for organisations that require SOC 2 without paying $599 a month, since compliance sits on the Team tier.