Lesson 8 · How web apps workWhat is Supabase, and why connect it?
Your app’s backend, in your own account.
Supabase gives your app a backend: a full Postgres database, sign-up and login, and rules for who can see what, all in your own account. Learn what each part does, why owning it matters, and the right moment to connect it.
About 8 minutes to readLast updated
On this page
Supabase in plain words
In the last lesson you learnt to spot when a website needs a database. Supabase is where that database lives. It is a backend service: a home for your app’s information, with the tools around it that a real app needs, such as sign-up and login and rules about who may see what.
Under the hood is Postgres, one of the most widely used databases in the world. That means your app sits on proven, standard technology, and your data is kept in tidy tables that any developer would recognise.
The parts of Supabase your app uses
| Part | What it does | Example |
|---|---|---|
| Database (Postgres) | Keeps your app’s information in tables | A Bookings table with name, date, service and status |
| Accounts | Sign-up, login and remembering who is signed in | A customer logs in to see their bookings |
| Access rules | Decide who can read or change each row | Members see only their own bookings; the owner sees all |
| Your own dashboard | Lets you look at your data and settings in Supabase | Checking the latest bookings, or inviting someone to help |
Why your own account matters
In 3Edit, Supabase lives in your own account, not someone else’s. That has real benefits:
- Your data is yours. Customers, orders and bookings sit in an account you control, and you can see them in your own Supabase dashboard.
- Nothing is locked in. Your project is standard Next.js code and your database is standard Postgres, so a developer can pick up both.
- It grows with you. Supabase has a free plan to start on, and its own paid plans for when your app grows. The Supabase pricing page has the details.
- You can bring help in. You can invite someone to your Supabase organisation from its team settings when you want a hand.
When to connect it
Connect Supabase before you ask for the first feature that has to remember something: the first form that saves, the first login, the first order. Then the AI can build that feature properly, with its tables and access rules in place from the start.
A simple site needs no database at all, so there is no need to connect Supabase for a portfolio or a one-page business site. Many projects start without it and connect it the day they add bookings or logins.
What 3Edit builds in your Supabase
Once Supabase is connected, you keep describing what you want in plain words. The 3Edit Agent builds logins and roles, database tables and access rules in your own Supabase, along with server routes, and payments and email using your own keys.
Starting from a starter kit? The Ecommerce Store, Aurelle and Restaurant & Takeaway kits come with their backends already built, so connecting Supabase gives them their database, ready to use.
Good habits with Supabase
- Describe your records clearly: “Each enquiry has a name, email, message, date and status” becomes a clean table.
- Always say who may see what: access rules (row level security) are what keep one person’s data away from another. The security basics guide explains them.
- Keep secret keys on the server: some Supabase keys are made for the browser and some must never leave the server. Ask the AI to check, and never paste a secret key into a page.
- Test with two accounts: sign up as two people and make sure neither can see the other’s data. The testing guide shows how.
- Look after a free project: Supabase pauses free projects after a week with no activity, and you can restore one with a click from your Supabase dashboard.
Try it in 3Edit.
First connect Supabase to your project, following the connect guide. Then paste these prompts in order and check each result in the live preview.
- 1Plan the data
I’m building a website for Hilltop Bakery, a small bakery in Bristol that takes cake orders. Before you build anything, tell me which tables you would create in my Supabase database for cake orders, with the fields each one needs, and who should be able to see each table.
- 2Build the order form
Build a one-page website for Hilltop Bakery with a cake order form: name, email, phone, cake type (birthday, wedding or celebration), collection date and a message. Save every order in my database with the status “New”, and show the customer a friendly thank-you message.
- 3Check the access rules
Check the access rules on my orders table. Visitors should be able to send a new order but not read anyone’s orders. Explain in plain words what the rules allow, and fix anything that is too open.
Then send a test order and look for it in your own Supabase dashboard: seeing your first saved row is the moment the backend becomes real.
Do it step by step.
This lesson explains the what, the why and the when. These guides and pages show every click.
- Connect Supabase to 3EditCreate your free Supabase account and organisation, then connect it to 3Edit: 3Edit creates the database for you.Read the guide
- Security basics for vibe-coded appsKeep secret keys on the server, turn on row level security and check who can see what before launch.Read the guide
- Starter kits with a full backendEcommerce Store, Aurelle and Restaurant & Takeaway come with their backends already built.See the starter kits
Next: User login and accounts
About the author.
Written by Humayun Rashed, founder of 3Edit. He also runs 3Edit’s free in-person AI website building and vibe coding course in London.
Questions people ask.
Supabase gives an app its backend: a full Postgres database to keep information such as accounts, bookings and orders, sign-up and login, and access rules that decide who can see what.
Supabase has a Free plan that costs nothing and includes a 500 MB database and up to 50,000 monthly active users, and paid plans for when your app grows. Supabase’s own pricing page has the details.
No. A simple site that only shows information needs no database. Connect Supabase when visitors log in, or when the site has to remember something they did, such as a booking, an order or a message.
You do. In 3Edit, Supabase lives in your own Supabase account, so your customers, orders and bookings are in an account you control.
Sign in to Supabase and approve 3Edit, then choose an existing database or create a new one. The connect guide shows every click.
Start vibe coding today.
Download 3Edit for Mac or Windows and build your first professional website in minutes.