Migrate from Neon to Supabase
Migrate your existing Neon database to Supabase.
This guide demonstrates how to migrate your Neon database to Supabase to get the most out of Postgres while gaining access to all the features you need to build a project.
Retrieve your Neon database credentials
- Log in to your Neon Console https://console.neon.tech/login.
- Select Projects on the left.
- Click on your project in the list.
- From your Project Dashboard find your Connection string and click Copy snippet to copy it to the clipboard (do not check "pooled connection").
Example:
_10postgresql://neondb_owner:xxxxxxxxxxxxxxx-random-word-yyyyyyyy.us-west-2.aws.neon.tech/neondb?sslmode=require
Set your OLD_DB_URL environment variable
Set the OLD_DB_URL environment variable at the command line using your Neon database credentials from the clipboard.
Example:
_10export OLD_DB_URL="postgresql://neondb_owner:xxxxxxxxxxxxxxx-random-word-yyyyyyyy.us-west-2.aws.neon.tech/neondb?sslmode=require"
Retrieve your Supabase connection string
-
If you're new to Supabase, create a project. Make a note of your password, you will need this later. If you forget it, you can reset it here.
-
Go to the Database settings for your project in the Supabase Dashboard.
-
Under Connection string, select URI, make sure Display connection pooler is checked, and Mode: Session is set.
-
Click the Copy button to the right of your connection string to copy it to the clipboard.
Set your NEW_DB_URL environment variable
Set the NEW_DB_URL environment variable at the command line using your Supabase connection string. You will need to replace [YOUR-PASSWORD] with your actual database password.
Example:
_10export NEW_DB_URL="postgresql://postgres.xxxxxxxxxxxxxxxxxxxx:[YOUR-PASSWORD]@aws-0-us-west-1.pooler.supabase.com:5432/postgres"
Migrate the database
You will need the pg_dump and psql command line tools, which are included in a full PostgreSQL installation.
-
Export your database to a file in console
Use
pg_dumpwith your Postgres credentials to export your database to a file (e.g.,dump.sql).
_10pg_dump "$OLD_DB_URL" \_10 --clean \_10 --if-exists \_10 --quote-all-identifiers \_10 --no-owner \_10 --no-privileges \_10 > dump.sql
-
Import the database to your Supabase project
Use
psqlto import the Postgres database file to your Supabase project._10psql -d "$NEW_DB_URL" -f dump.sql
Additional options
- To only migrate a single database schema, add the
--schema=PATTERNparameter to yourpg_dumpcommand. - To exclude a schema:
--exclude-schema=PATTERN. - To only migrate a single table:
--table=PATTERN. - To exclude a table:
--exclude-table=PATTERN.
Run pg_dump --help for a full list of options.
-
If you're planning to migrate a database larger than 6 GB, we recommend upgrading to at least a Large compute add-on. This will ensure you have the necessary resources to handle the migration efficiently.
-
For databases smaller than 150 GB, you can increase the size of the disk on paid projects by navigating to Database Settings.
-
If you're dealing with a database larger than 150 GB, we strongly advise you to contact our support team for assistance in provisioning the required resources and ensuring a smooth migration process.
Enterprise
Contact us if you need more help migrating your project.