What is Supabase?
Supabase is an open-source backend platform built on PostgreSQL. Every project gets a full Postgres database plus the services most apps need around it: authentication, auto-generated APIs, realtime subscriptions, file storage and serverless Edge Functions. It is often described as an open-source alternative to Firebase, but because the core is standard Postgres, you keep full SQL, extensions and the option to move your data elsewhere.
Key features
- Postgres database: a dedicated Postgres instance with SQL access, extensions, row level security and a table editor in the dashboard.
- Auto-generated APIs: REST (via PostgREST) and GraphQL APIs are generated from your schema, so you can query tables from the client libraries without writing a backend.
- Authentication: email/password, magic links, phone logins and social OAuth providers, tied into Postgres row level security.
- Realtime: listen to database changes, broadcast messages and track presence over WebSockets.
- Storage: store and serve files and images with access policies.
- Edge Functions: TypeScript functions that run on Deno close to your users.
- Vector and AI: the pgvector extension lets you store embeddings and run similarity search in the same database.
- CLI and local development: the Supabase CLI runs the full stack locally and manages migrations.
Who is it for?
Supabase suits frontend and full-stack developers who want a production backend without managing servers, startups building MVPs quickly, and teams that prefer relational data and SQL over a document store. Because it is open source, teams with strict requirements can also self-host it.
Use cases
- SaaS apps with user accounts, teams and permissions
- Realtime features such as chat, live dashboards and collaborative tools
- AI apps that need embeddings and retrieval next to app data
- Mobile backends for Flutter, React Native and Swift apps
- Internal tools on top of an existing Postgres schema
Pricing
Supabase has a free plan for small projects and paid plans that add more resources, backups and support, with enterprise options for larger organizations. Limits and compute add-ons change over time, so check the official Supabase pricing page for current details.
What's new and trending
The Supabase CLI is moving fast: v3.0.0-next.24 was published on October 26, 2026 (release notes), alongside the ongoing 2.x line. The self-hosted platform release v1.26.08 came out on August 7, 2026 (release notes).
Getting started
- Create a free project at supabase.com and pick a region.
- Design tables in the Table Editor or with SQL, and turn on row level security.
- Install the client library for your stack (for example
supabase-js) and connect with your project URL and anon key. - Add authentication and storage as needed.
- Use the Supabase CLI for local development and migrations.
Alternatives
Neon and PlanetScale focus on managed serverless databases, while Appwrite and PocketBase are open-source backend-as-a-service options. Convex offers a reactive TypeScript backend, and MongoDB Atlas is the main managed document-database choice.
FAQ
Is Supabase free? Supabase has a free plan that is suitable for prototypes and small projects. Paid plans add capacity and features; see the official pricing page for current limits.
Is Supabase open source? Yes. Supabase's components are open source, and you can self-host the stack with Docker.
Is Supabase a Firebase alternative? It is often used as one. The main difference is that Supabase is built on relational Postgres rather than a NoSQL document store.
Can I use Supabase for AI apps? Yes. With pgvector you can store embeddings and run vector similarity search alongside your normal data.
Does Supabase work with Next.js? Yes. Supabase provides client libraries and guides for Next.js, including server-side auth helpers.

