> ## Documentation Index
> Fetch the complete documentation index at: https://thenile.dev/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Connecting to Postgres using DBeaver

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.

<img src="https://mintcdn.com/nile/ZhObK_CvFMgzM-yj/images/psql-1.png?fit=max&auto=format&n=ZhObK_CvFMgzM-yj&q=85&s=c0ffc9005b2f153d12ec89736f84dc00" alt="DBWeaver-1" width="2876" height="1464" data-path="images/psql-1.png" />

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

<img src="https://mintcdn.com/nile/ZhObK_CvFMgzM-yj/images/psql-2.png?fit=max&auto=format&n=ZhObK_CvFMgzM-yj&q=85&s=83d6573e2bcb6e0d85385d46e4d162eb" alt="DBWeaver-2" width="2858" height="1446" data-path="images/psql-2.png" />

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

<img src="https://mintcdn.com/nile/ZhObK_CvFMgzM-yj/images/psql-3.png?fit=max&auto=format&n=ZhObK_CvFMgzM-yj&q=85&s=372af70ef91b7b9a3474454abda050bd" alt="DBWeaver-3" width="2864" height="1450" data-path="images/psql-3.png" />

4. 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.

<img src="https://mintcdn.com/nile/PVqSPvIIF-xsKfJe/images/dbweaver-4.png?fit=max&auto=format&n=PVqSPvIIF-xsKfJe&q=85&s=5346e9f9933aae9914d52fa39d91262e" alt="DBWeaver-4" width="2876" height="1434" data-path="images/dbweaver-4.png" />

5. There are four parts of this url that is needed to connect to DBWeaver

```sql theme={null}
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
```

6. Navigate to DBWeaver. Select to connect to a new database

<img src="https://mintcdn.com/nile/PVqSPvIIF-xsKfJe/images/dbweaver-5.png?fit=max&auto=format&n=PVqSPvIIF-xsKfJe&q=85&s=c13cd9514e8fe484ee74af8686042304" alt="DBWeaver-5" width="2876" height="1620" data-path="images/dbweaver-5.png" />

7. Pick Postgres as the choice of database

<img src="https://mintcdn.com/nile/PVqSPvIIF-xsKfJe/images/dbweaver-6.png?fit=max&auto=format&n=PVqSPvIIF-xsKfJe&q=85&s=8d2907f2c5af0b40fc54909e03e0e923" alt="DBWeaver-6" width="1618" height="1340" data-path="images/dbweaver-6.png" />

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

<img src="https://mintcdn.com/nile/PVqSPvIIF-xsKfJe/images/dbweaver-7.png?fit=max&auto=format&n=PVqSPvIIF-xsKfJe&q=85&s=6243fbad0e36be6c1df694f18c279951" alt="DBWeaver-7" width="2872" height="1596" data-path="images/dbweaver-7.png" />

9. Press OK and DBWeaver should automatically connect to Nile's Postgres

<img src="https://mintcdn.com/nile/PVqSPvIIF-xsKfJe/images/dbweaver-8.png?fit=max&auto=format&n=PVqSPvIIF-xsKfJe&q=85&s=6813e1243af05eadbd9a27f3d34a5f85" alt="DBWeaver-8" width="1398" height="1292" data-path="images/dbweaver-8.png" />

10. Enjoy exploring Nile with DBWeaver
