Supabase
Supabase gives your site a Postgres database, user sign-in and file storage, all in your own Supabase account. Pick it when you want the data in an account you own. Otherwise WebTwizz Cloud is included and needs no setup.
Connect
Supabase is a data source, so it connects through the Data panel. A project has one data source at a time.
- Open Settings > Connectors, click Supabase, then Connect. The Data panel opens on Supabase. You can also start there.
- Click Connect with Supabase, sign in and approve access.
- Pick a project, or choose + Create new project, and click Connect.
Once your Supabase account is connected, your other projects list it under Your accounts with Use in this project. More options, like pasting an access token instead, are in Data & CMS.
What you see
Open in Supabase next to the connector's name opens the project this site uses.
- Overview: your Supabase project with its region and table count, and Open Data. Open in Supabase opens the project.
- When the project isn't running, it says Paused, Pausing, Starting or Stopped, and what that means for the site. A paused project has Restore project: click Restore to confirm, and Supabase starts it again in a few minutes.
- Sign-up emails, marked Limited: shows when the project sends emails with Supabase's built-in email, which sends only a few an hour, so some users miss their emails. Set up Resend opens the Resend connector if it isn't connected yet, and SMTP settings opens the page in Supabase where you add it.
- Last backup: when Supabase last backed up the database, marked Point in time if that's on. It opens your backups in Supabase.
- Tables with their row counts, which open in the Data panel. Table editor opens Supabase.
- Storage buckets, each Public or Private, opening in Supabase. Storage opens them all.
- Users: how many users your site has and when the newest joined, which opens them in the Data panel. Below it, your newest users with when each joined, marked Blocked if they are. Show more loads 10 more, and Open in Supabase opens them there. Click a user to see their Email, Phone, Signs in with, Joined, Last signed in and Email confirmed, with:
- Send password reset: Supabase emails them a link to choose a new password. Click Send to confirm.
- Block: they can't sign in until you click Unblock. Click Block or Unblock again to confirm. They aren't emailed.
- Delete: removes them from Supabase for good, with their sign-in. Click Delete user to confirm.
- Settings: changes go to Supabase as you make them.
- Supabase project: where this project's data and users live. Pick another project, or Create a new project. Switching asks first: click Switch project, and the old project keeps everything in it.
- New users can sign up: on, so anyone can create an account, or off, so only existing users can sign in.
- Email confirmation: on, so new users confirm their email before signing in, or off.
- Site URL: where confirmation and password reset emails send users back to. If it still points at
localhost, or at another site's address, the row says so and offers Use with this site's address. - Redirect URLs: where sign-in may send users after it finishes. Edit opens the list, where Remove takes one out and Add adds one you type. If this site's addresses are missing, the button says Add this site, and Add this site in the list adds them.
- Sign in with Google: lets users sign in with their Google account, through your own Google app. Turning it on opens a form for your Google web client's Client ID and Client secret. How to set it up walks you through Google Cloud, with every address to paste ready to copy. When you turn it on, the AI adds a Continue with Google button to your sign-in and sign-up pages in a new chat. Once it's on, Change app swaps the Google app.
- Another Supabase account: Connect picks a project from a different account, and This project only connects one that only this project uses.
What the AI can do
- Build on your database: create tables, wire up sign-up and login, and read and write rows through the Data panel's tools.
- Read your sign-in settings: whether new users can sign up, whether email confirmation is on, where emails link to, and whether Sign in with Google is on. It notices when emails link to another site.
- Change those settings, for example pointing confirmation emails at your live domain. It asks first, and only changes them after you click Accept. Turning on Sign in with Google needs your Google app added under Settings first.
Secrets
NEXT_PUBLIC_SUPABASE_URL: your project's URLNEXT_PUBLIC_SUPABASE_PUBLISHABLE_KEY: the publishable key, safe to use in the browserSUPABASE_SERVICE_ROLE_KEY: full access to your database, server-side onlySUPABASE_ACCESS_TOKEN: lets WebTwizz manage the project for you, server-side only
Good to know
- A new Supabase project sends confirmation and reset emails to
http://localhost:3000until you change its Site URL. Click Use with your site's address under Settings, or ask the AI to. - One Supabase project can serve several of your sites, but it has one Site URL. If it points at another of your sites, emails from this site link there, and the row says so.
- A paused Supabase project can't be connected. Restore it in your Supabase dashboard first.
- Connecting another data source replaces Supabase in this project. Your data stays in Supabase.
- Removing Supabase from a project stops the site reading and writing through it. Nothing in Supabase is deleted.