Supabase API
Supabase API
Supabase is open-source Firebase alternative — Postgres SQL database + auth + storage + realtime + edge functions + vector embeddings.
Real Postgres (not abstraction layer) — any PG tool works
Postgres connection limits (free 50, Pro 200)
Create project at supabase.com/dashboard for URL + anon key. JS SDK: const supabase = createClient(url, key); const { data } = await supabase.from("users").select();
Uptime · 30-day window
About this API
Supabase is an open-source BaaS platform founded 2020 in Australia, positioned clearly as "Firebase's SQL alternative". Unlike Firebase's NoSQL, Supabase centers on Postgres — each Supabase project is essentially a managed Postgres instance + value-add services (auth, storage, realtime, edge functions, Vector). Deep implications: (1) True relational data (foreign keys, JOINs, complex queries all supported, unlike Firestore's limitations); (2) Row Level Security (RLS) for fine-grained permissions written in SQL; (3) Any Postgres tool works (pgAdmin, DBeaver, Prisma ORM); (4) Easy data migration (any Postgres backup tool). Vector embedding via pgvector extension makes Supabase a popular AI app backend. 70k+ GitHub stars, 100%+ annual growth, hottest in open-source BaaS. Free tier 50000 MAU + 500MB DB more than enough for small projects.
What you can build
- 1Web / mobile app backend (auth + DB)
- 2SaaS startup product backend
- 3AI applications (vector embeddings via pgvector)
- 4Migrate Firebase projects wanting SQL relational data
Strengths & limitations
Strengths
- Real Postgres (not abstraction layer) — any PG tool works
- Open-source (Apache 2.0) + self-host option
- Real-time (Postgres logical replication to WebSocket)
- Generous free tier (50000 MAU)
Limitations
- Postgres connection limits (free 50, Pro 200)
- Some complex RLS policies are slow
- Storage slightly more expensive than S3
Example request
curl https://supabase.com/<endpoint> \
-H "Authorization: Bearer $ACCESS_TOKEN"Getting started
Create project at supabase.com/dashboard for URL + anon key. JS SDK: const supabase = createClient(url, key); const { data } = await supabase.from("users").select();
FAQ
Supabase vs. Firebase?+
SQL/complex queries/RLS: Supabase. NoSQL/Google ecosystem/mature mobile SDK: Firebase.
Self-host or cloud?+
Cloud (supabase.com) is hassle-free. Self-host requires docker + configuring a dozen services, suits compliance requirements.
Technical details
- Auth type
- jwt
- Pricing
- freemium
- Rate limit
- 免费 50000 月活;Pro $25/月起
- Protocols
- REST, WebSocket, PostgreSQL
- SDKs
- javascript, typescript, python, go, dart, swift, kotlin