Skip to main content
Next, you’ll need to set up any PostgreSQL database (e.g. Supabase). This will be used to store application data (e.g. user sessions, user data, etc.).
1

Create Supabase database

In your Supabase account, create a new database.Make sure to copy the password you write to use for the next step.
Supabase create database
2

Set up Supabase environment variables

Then, click on the Connect button on the top left, navigate to the ORMs tab, and select Prisma.After that, copy the DATABASE_URL and DIRECT_URL into your .env file. And make sure to replace [YOUR-PASSWORD] with the password you wrote down in the previous step.
Supabase connection
3

Apply migrations

In the terminal, run the following command to generate the Prisma client:
Terminal
pnpm run db:generate
Then, run the following command to apply the database migrations:
Terminal
pnpm run db:deploy

Next Steps

Once you’ve completed the Supabase setup, proceed to Step 6: GitHub OAuth to enable authentication.