Connect Vercel and Neon manually

This guide describes how to manually connect a Vercel project to a Neon database.

Prerequisites

• A Neon project. If you do not have one, see Create a project.
• A Vercel account.
• A project deployed to Vercel. If you do not have one, see Creating a project, in the Vercel documentation.

Gather your Neon connection details

You can find the connection details for your database by clicking the Connect button on your Project Dashboard. Select a branch, a role, and the database you want to connect to. A connection string is constructed for you.

The connection string includes the role name, hostname, and database name. For example:

postgresql://alex:AbC123dEf@ep-cool-darkness-123456.us-east-2.aws.neon.tech/dbname
           ^              ^                                               ^
           |- <role>      |- <hostname>                                   |- <database>

• role name: alex
• hostname: ep-cool-darkness-123456.us-east-2.aws.neon.tech
• database name: dbname

Configure project environment variables in Vercel

The environment variables required to connect your application to Neon depend on your application. Some applications use a DATABASE_URL environment variable with a database connection string:

DATABASE_URL="postgresql://alex:AbC123dEf@ep-cool-darkness-123456.us-east-2.aws.neon.tech/dbname"

Other applications may use PG* environment variables to define database connection details:

PGUSER=alex
PGHOST=ep-cool-darkness-123456.us-east-2.aws.neon.tech
PGDATABASE=dbname
PGPASSWORD=AbC123dEf
PGPORT=5432

To configure the environment variables required by your application:

1. Navigate to the Vercel dashboard.
2. Select your Vercel project.
3. Select Settings.
4. Select Environment variables.
5. Enter the environment variable name in the Key field and add the value.
6. Click Add another if you need to add more variables.
7. Select the Vercel environments to which the variable(s) will apply (Production, Preview, Development).
8. Click Save.

You must redeploy your application in Vercel for the environment variable settings to take effect.