This guide will walk you through the steps to connect to Nile using PSQL.

  1. Create a Nile’s Postgres database through the UI or use one of your existing databases to follow along.

  1. Once you are inside a specific database, click on the settings tab on the left and navigate to the connections screen

  1. Click on the Postgres icon to get the connection string

  1. Click “Generate credentials”. Use this if you really want to simplify the access. If not, you can replace the username and password manually and use that through commandline.

  1. There are four parts of this url that is needed to connect to DBWeaver
psql postgres://018bd797-ed9d-7c02-bec4-dac1179c29fd:d68af75e-47cb-4354-ada4-98abe7d8015c@db.thenile.dev:5432/diplomatic_axe

host:db.thenile.dev
database:diplomatic_axe
username:018bd797-ed9d-7c02-bec4-dac1179c29fd
password:d68af75e-47cb-4354-ada4-98abe7d8015c
  1. Navigate to DBWeaver. Select to connect to a new database

  1. Pick Postgres as the choice of database

  1. Enter the host, database, username and password from step 5

  1. Press OK and DBWeaver should automatically connect to Nile’s Postgres

  1. Enjoy exploring Nile with DBWeaver

Was this page helpful?