Connect Your Supabase Database

PlanB writes to your Supabase database over a standard Postgres connection. You'll paste a connection URI from Supabase into PlanB once, and PlanB will use it for every migration run after that.

Step 1 — Get the shared (Session) pooler URI from Supabase

1. Open your Supabase project and click Connect in the top bar.
2. Select Session pooler (not Direct connection, not Transaction pooler).
3. Turn ON the toggle labelled “Recommended when your network does not support IPv6”. This switches you to the IPv4 shared pooler that PlanB can reach.
4. Copy the URI. The host must end in pooler.supabase.com and the user looks like postgres.abcdefgh.

Step 2 — Replace [YOUR-PASSWORD]

The URI Supabase gives you contains a literal [YOUR-PASSWORD] placeholder. Replace it with your actual database password — and remove the square brackets. Example final URI:

postgresql://postgres.abcdefgh:[email protected]:6543/postgres

Step 3 — Optional: set a table prefix

PlanB lets you prepend a prefix to every exported table name (e.g. app1_user instead of user_). Reasons to use one:

• You're importing multiple Bubble apps into the same Supabase database and want to keep their tables separate.
• You're testing the migration and want to keep the test tables out of the way of your real ones.

Use a trailing underscore (e.g. import_, app1_) to keep names readable. Leave blank if you're only importing one Bubble app.

Step 4 — Paste into PlanB

1. In PlanB, open Migrate to Supabase from the sidebar.
2. Expand Supabase connection.
3. Paste the URI into Connection URI (Session Pooler).
4. Optionally set a Table prefix.
5. Click Save connection. PlanB validates the host and format before storing the credentials — if it rejects the URI, you most likely copied the IPv6-only db. direct connection instead of the shared pooler.

Next: prepare your Bubble app

Most failed migrations come from messy Bubble table or column names — emojis, spaces, SQL reserved words. Read Prepare your Bubble app before you run your first migration.