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.
- Navigate to the Database tab and select New Database Connection
- Select PostgreSQL then click the Next button
- 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
- To the right of Main tab, Click on PostgreSQL tab. Check the Show all databases checkbox and return to Main tab
- Enter your database credentials into the form:
- URL: the External Database URL from your Environment Variables section on Render
- 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:
- Database: the name you used for the Database field when creating the database
- Username: your username
- Password: your password
- Click the Test Connection… button. You should see a modal displaying Connected message. Click OK, and then the Finish button
- You are now connected to your Render PostgreSQL database on DBeaver!
- 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