Supabase: a ready backend on Postgres
Supabase is an open-source backend platform. Every project comes with a full Postgres database, user authentication, file storage, an automatic API and edge functions. It is used from MVPs to large applications.
- Type
- Backend platform (BaaS)
- Price
- Free plan, paid plans
- Database
- PostgreSQL
- Code
- Open source
What is Supabase?
When you create a table in Supabase you get a REST and real-time API automatically. Security is built into the database itself with Row Level Security rules: each user sees only the rows they are allowed to.
Because it is Postgres, data can be analysed with SQL and connected to any BI tool. Supabase is also planned for this site's CMS and forms.
What Supabase makes possible
Postgres database
Full SQL and extensions.
Auth
E-mail, OAuth and magic link sign-in.
Automatic API
REST and real time.
Storage
File and image storage.
Edge Functions
Server logic and webhooks.
Row Level Security
Row-level permissions.
What Supabase works with
- Open the guide
WeWeb
A visual front-end builder. Web apps with Xano and Supabase.
- Open the guide
GitHub
Code hosting, version control, teamwork and CI/CD.
- Open the guide
Claude Code
Anthropic's agentic coding tool. Works directly in your codebase.
- Open the guide
SendGrid
An API and SMTP service for transactional e-mail.
- Open the guide
Power BI
Microsoft's BI platform. Corporate reporting and data models.
My experience
Projects where I used Supabase:
- [Project: brand, what I built, result %]
- [Project: brand, what I built, result %]
Supabase resources
Questions about Supabase
Is Supabase free?
There is a free plan for small projects. A paid plan is recommended for production apps.
Supabase or Xano?
Supabase for a team comfortable with SQL and code. Xano for a no-code team that wants visual backend logic.
Is the data secure?
Yes, when RLS rules are written correctly. The service key must never be used in the front end.