Supabase

Supabase gives you a full backend with PostgreSQL, user authentication, real-time data sync, and file storage—all open-source and self-hostable. It's built for developers who want a scalable backend without managing servers.

What it does

You create a PostgreSQL database in seconds, then use Supabase's client libraries to query it, authenticate users, listen to real-time changes, and store files. It includes a dashboard for SQL queries, row-level security, and auto-generated REST and GraphQL APIs.

Best for

• Startups building MVPs that need a full backend fast
• Developers who prefer SQL over NoSQL for relational data
• Teams wanting an open-source alternative to Firebase with PostgreSQL

Strengths

• PostgreSQL with row-level security gives fine-grained access control out of the box
• Real-time subscriptions let you sync data across clients without polling
• Self-hostable option for compliance or data sovereignty requirements

• PostgreSQL database — Full SQL database with extensions like PostGIS and pgvector for geospatial and vector search
• Authentication — Built-in user management with email/password, OAuth (Google, GitHub, etc.), and magic links
• Real-time subscriptions — Listen to database changes via WebSocket and update UI instantly
• Auto-generated APIs — REST and GraphQL endpoints created from your database schema
• File storage — Upload and serve files with CDN, resizing, and access control
• Edge Functions — Run serverless TypeScript functions at the edge for low-latency logic