Connect with the Neon Vercel Integration

This guide describes how to connect using the Neon Vercel Integration from the Vercel marketplace. The integration connects your Vercel project to a Neon database and creates a database branch for each preview deployment.

About the Neon Vercel Integration

Vercel preview deployments enable teams to collaborate effectively by automatically creating an isolated, production-like environment for every commit. This allows changes to be previewed before they are merged into production.

However, when databases are involved, teams often use a single database containing dummy data for all preview deployments. This setup is not ideal for these reasons:

• If the shared database encounters an issue, so will all preview deployments.
• Changes to the shared database schema might break all previously created preview deployments, making it a productivity bottleneck.

Neon’s branching feature addresses these challenges. A branch is a copy-on-write clone of your data, so creating it only takes a few seconds. This makes it a scalable and cost-effective solution for preview deployments, enabling you to create a branch for each pull request.

When you push changes to the repository associated with your Vercel project, triggering a preview deployment, the integration automatically creates a branch in Neon and connects it to your preview deployment by setting Vercel preview environment variables.

Add the Neon Vercel Integration

This section describes how to add the Neon Vercel Integration to your Vercel project.

Prerequisites:

• A Vercel account.
• A Vercel project. If you do not have one, see Creating a project, in the Vercel documentation.
• The integration initially sets the DATABASE_URL and DATABASE_URL_UNPOOLEDenvironment variables for your Vercel Production and Development environments. When you create a preview deployment, the integration will also set these variables for your Preview environment. Variables of the same name will be overwritten. To use different Postgres variables with the Neon integration, see Manage Vercel environment variables.

To add the integration:

1. Navigate to the Neon Vercel Integration page, and click Add integration.

2. Select a Vercel Account to add the integration to.

3. Select the Vercel projects to add the integration to. You can select All Projects or Specific Projects but be aware that you can only connect one Vercel project to one Neon project and vice versa. By selecting All projects, you are simply making the integration available to other Vercel projects.

4. Review the permissions required by the integration, and click Install.

5. In the Integrate Neon dialog:

   1. Select a Vercel project.

   2. Select the Neon project that you want to connect to your Vercel project by selecting the Neon project, database, and role that Vercel will use to connect.

      The Create a branch for your development environment option creates a branch named vercel-dev and sets Vercel development environment variables for it. The vercel-dev branch is a clone of your project's primary branch (main) that you can modify without affecting data on your primary branch.

      With Automatically delete obsolete Neon branches enabled, Neon preview branches will be deleted whenever the git branch that triggered its creation is merged or deleted.

      note

      Branches created for preview deployments are created from the primary branch of your Neon project. Earlier versions of the integration created branches from the initial root branch of your Neon project, which is designated as the primary branch by default. Neon lets you change the primary branch. If you have an older version of the integration that creates branches from your project's root branch, and you want branches created from your primary branch instead, you can upgrade your integration by reinstalling it from the Vercel Marketplace.

      When you finish making selections, click Continue.

   3. Confirm the integration settings. This allows the integration to:

      • Set environment variables for your Vercel project's production, development, and preview environments.
      • Create database branches for preview deployments.
      • Create a development branch for your Vercel development environment.

   4. Click Connect to confirm and proceed with the integration. If you encounter a connection error, see Troubleshoot connection issues.

      After the settings are configured, you are presented with a Success dialog.

   5. Click Done to complete the installation.

6. To view the results of the integration in Neon:

   1. Navigate to the Neon Console.
   2. Select the project you are connected to.
   3. Select Branches. You will see the primary branch of your project (main). If you created a development branch, you will also see a vercel-dev branch.

7. To view the results of the integration in Vercel:

   1. Navigate to Vercel.
   2. Select the Vercel project you added the integration to.
   3. Select Settings > Environment Variables. You should see the DATABASE_URL and DATABASE_URL_UNPOOLED variable settings added by the integration.

   note

   The DATABASE_URL variable set by the integration is set to a pooled Neon database connection string. The DATABASE_URL_UNPOOLED variable is set to an unpooled connection string for tools or applications that require a direct connection to the database. For more information, see Manage Vercel environment variables.

Use the Neon Vercel Integration

After you add the integration to a Vercel project, Neon creates a database branch for each preview deployment. The branch is created when you push commits made on your local branch to your application's source code repository. To see the integration in action, follow these steps:

1. Create a branch in your local source code repository.

   cd myapp
   git checkout -b patch-1

2. Make changes to your application on the local branch.

3. Commit the changes. For example:

   git commit -a -m "Update my app"

4. Push your commit to the remote repository:

   git push

   Pushing the commit triggers the following actions:

   • The commit triggers a preview deployment in Vercel, as would occur without the Neon integration.
   • The integration creates a branch in Neon. This branch is an isolated copy-on-write clone of your primary branch, with its own dedicated compute endpoint. The branch is created with the same name as your git branch but includes a /preview prefix.
   • The integration sets Vercel preview environment variables to connect the preview deployment to the new branch.

Manage branches created by the integration

The Neon Vercel Integration creates a branch for each preview deployment. To avoid using up your storage allowances or hitting branch limits, you should delete branches that are no longer required. Different options are supported for branch deletion.

Automatic deletion

The integration supports automatic deletion of obsolete preview branches when the corresponding Git branch is merged or deleted. If you did not select the Automatically delete obsolete Neon branches option when installing the integration, you can do so from the Branches tab the Vercel integration drawer.

1. In the Neon Console, select your project.
2. Select the Integrations page.
3. Find the Vercel integration under the Manage heading, and click Manage.
4. In the Vercel integration drawer, select the Branches tab.
5. Check Automatically delete obsolete Neon branches.

Manual deletion from the Vercel integration drawer

To remove branches created by the integration manually:

1. In the Neon Console, select your project.
2. Select the Integrations page.
3. Find the Vercel integration under the Manage heading, and click Manage.
4. In the Vercel integration drawer, select the Branches tab.
5. Remove individual preview branches by clicking on the delete icon, or select Delete all to remove all preview branches.

Manual deletion via the Neon Console, CLI, or API

To remove branches from your Neon project using the Console, CLI, or API, see Delete a branch.

Manage integration settings

You can manage Vercel environment variables as well as the default database and role used by the integration from the Neon Console.

Configure environment variables

The Neon Vercel Integration automatically sets the environment variables DATABASE_URL (pooled connection) and DATABASE_URL_UNPOOLED (direct connection) for your Vercel Production and Development environments. See Connection pooling for more information. When you create a preview deployment, the integration also sets these same variables for the Vercel Preview environment. If you want to define your database connection using different Postgres environment variables, the integration also supports the following:

• PGHOST (set to a pooled Neon database connection string)
• PGHOST_UNPOOLED (set to a direct Neon database connection string)
• PGUSER
• PGDATABASE
• PGPASSWORD

You can choose the variables you want to use from the Neon Console:

1. In the Neon Console, select your project.
2. Select the Integrations page.
3. Find the Vercel integration under the Manage heading, and click Manage.
4. In the Vercel integration drawer, select the Settings tab.
5. Select the environment variables you need.
6. Click Save changes. Your variable selection is saved to your Vercel project and will be applied on your next deployment. Existing variables of the same name in Vercel will be overwritten. Viewing your new variable selection in Vercel may require refreshing your project's Environment Variables page.

Change the database and role for preview branches

When you install the integration, you select a database and role for your Neon project. These details are used to define the database connection details in the Vercel environment variables mentioned above. From the Vercel integration drawer in the Neon Console, you can choose a different database and role for new preview deployment branches.

To change the database and role for new preview deployment branches:

1. In the Neon Console, select your project.
2. Select the Integrations page.
3. Find the Vercel integration under the Manage heading, and click Manage.
4. In the Vercel integration drawer, select the Settings tab.
5. Under Default database and role, select a new Database and Role.

Your change will be reflected in your Vercel Preview environment variables on the next preview deployment.

Disconnect the integration

If you want to disconnect the Neon Vercel Integration from your Vercel project, you can do so from the Neon Console. Disconnecting stops the integration from creating preview branches and setting environment variables for those branches in Vercel. It does not remove the integration from your Vercel project. To fully remove the integration from your Vercel project, you must do so in Vercel. See Manage the Neon Postgres integration in Vercel for instructions.

To disconnect the Neon integration from your Vercel project:

1. In the Neon Console, select your project.
2. Select the Integrations page.
3. Find the Vercel integration under the Manage heading, and click Manage.
4. In the Vercel integration drawer, select the Disconnect tab.
5. Click Disconnect.

Make the integration available to other Vercel projects

If you added the Neon Vercel Integration to a single Vercel project but would like to make it available for use with your other Vercel projects, complete the steps outlined below.

1. Make sure the Neon Vercel Integration that you added previously has access to the Vercel project that you want to use with the Neon Vercel Integration.
   1. On the Vercel Dashboard, select Integrations.
   2. Find the Neon Postgres integration, and select Manage.
   3. On the Neon Postgres integration page, select Manage Access.
   4. On the Manage Access for Neon Postgres modal, make sure that the Neon Postgres integration has access to the Vercel project. You can do so by selecting Specific Projects and choosing a Vercel project or by granting access to All Projects. If you previously granted access to All Projects, no change is necessary.
   5. Click Save.
2. Navigate to this URL: https://vercel.com/integrations/neon/new.
3. Follow the prompts. When you reach the Integrate Neon dialog, select the Vercel project you want to add the integration to. Vercel projects that are already integrated with Neon are identified as CONNECTED.
4. Continue following the prompts to complete the setup. These are the same steps described above, in Add the Neon integration. When you select a Neon project to connect to, make sure to select one that is not already connected to a Vercel project, as you cannot connect a Vercel project to multiple Neon projects or vice versa.

Manage the integration in Vercel

To view permissions, manage which Vercel projects your integration has access to, or uninstall the Neon integration from Vercel:

1. On the Vercel dashboard, select Settings > Integrations.

2. Find the Neon integration and select Configure.

   note

   Removing the Neon Vercel Integration removes the Vercel environment variables set by the integration. It does not remove Neon branches created by the integration. To remove Neon branches, see Delete a branch.

Troubleshoot connection issues

This section describes commonly encountered connection issues for the Neon Vercel Integration.

Failed to set environment variables

If the environment variables configured by the Neon integration already exist, you may encounter the following error due to an existing integration that sets one or more of the same environment variables.

Failed to set environment variables in Vercel. Please make sure that the following environment variables are not set: PGHOST, PGUSER, PGDATABASE, PGPASSWORD, DATABASE_URL

In this case, you can remove or rename the existing environment variables in your Vercel project settings and retry the Neon integration.

1. From the Vercel project page, select Settings.

2. Locate the environment variables required by the Neon integration and remove or rename them.

   note

   Alternatively, you can remove the conflicting integration, assuming it is no longer required. This may be a previous Neon integration or another integration. Removing the integration removes the variables set by the integration.

3. Try adding the integration again. See Add the Neon Vercel Integration.

DATABASE_URL not set on first preview deployment

In earlier versions of the integration, the preview environment DATABASE_URL is not set by the Neon Vercel Integration on the first preview deployment after adding the integration to a Vercel project.

To avoid this issue, you can reinstall the integration to update to the latest version. Alternatively, a workaround is to redeploy your preview deployment in Vercel. The preview environment DATABASE_URL is set on the next deployment. For redeploy instructions, see Managing Deployments, in the Vercel documentation.

Stored passwords missing in the selected Neon project

Neon projects created after March, 2023 store role passwords in a secure storage vault associated with the project, allowing passwords to be retrieved by the Neon Vercel integration for the purpose of setting Postgres connection environment variables in Vercel. Projects created before March 2023, do not store role passwords, and are therefore not compatible with the Neon Vercel integration. The current workaround for this issue is to migrate your data to a new Neon project. See Import data from another Neon project.

Video: A Postgres database for Every Preview Deployment

Watch this video from the Neon DevRel team for an overview of the Neon Vercel Integration.