Skip to main content

Connecting a client to a database on Render


This guide uses a database client called DBeaver, but the ideas still apply if you are using another client. If you are using another client, try looking for similarly named controls.

  1. Navigate to the Database tab and select New Database Connection

Creating a new Database Connection

  1. Select PostgreSQL then click the Next button

Selecting PostgreSQL from the available databases

  1. Often, after the first installation or use of a specific database type, you may encounter the download of relevant drivers modal. This is perfectly normal, just click Download and proceed to the next step. DBeaver will download and install the relevant drivers needed for using your specific database type

Downloading PostgreSQL drivers

  1. To the right of Main tab, Click on PostgreSQL tab. Check the Show all databases checkbox and return to Main tab

Enabling option to show all database

  1. Enter your database credentials into the form:
    1. URL: the External Database URL from your Environment Variables section on Render
    2. Host: the same External Database URL, except remove everything up to and including the @ sign then remove everything after .com. It should look something like:
    3. Database: the name you used for the Database field when creating the database
    4. Username: your username
    5. Password: your password

Form to fill out with your database credentials

  1. Click the Test Connection… button. You should see a modal displaying Connected message. Click OK, and then the Finish button

A successful connection test

  1. You are now connected to your Render PostgreSQL database on DBeaver!

Successfully connected DBeaver to Render Postgres

Warning/Failure messages

  • You may see warning/failure messages like the one below (I did!)
  • Not to worry, calmly step through the entire process slowly.
  • After a few tries, if you don’t succeed, ask for help in the relevant communication channels

A connection error message