> ## 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 PgAdmin

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

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

![PgAdmin-1](https://mintcdn.com/nile/ZhObK_CvFMgzM-yj/images/psql-1.png?fit=max\&auto=format\&n=ZhObK_CvFMgzM-yj\&q=85\&s=c0ffc9005b2f153d12ec89736f84dc00)

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

![PgAdmin-2](https://mintcdn.com/nile/ZhObK_CvFMgzM-yj/images/psql-2.png?fit=max\&auto=format\&n=ZhObK_CvFMgzM-yj\&q=85\&s=83d6573e2bcb6e0d85385d46e4d162eb)

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

![PgAdmin-3](https://mintcdn.com/nile/ZhObK_CvFMgzM-yj/images/psql-3.png?fit=max\&auto=format\&n=ZhObK_CvFMgzM-yj\&q=85\&s=372af70ef91b7b9a3474454abda050bd)

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.

![PgAdmin-4](https://mintcdn.com/nile/PVqSPvIIF-xsKfJe/images/dbweaver-4.png?fit=max\&auto=format\&n=PVqSPvIIF-xsKfJe\&q=85\&s=5346e9f9933aae9914d52fa39d91262e)

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

```bash theme={null}
host:db.thenile.dev
database:diplomatic_axe
username:018bd797-ed9d-7c02-bec4-dac1179c29fd
password:d68af75e-47cb-4354-ada4-98abe7d8015c
```

6. Navigate to PgAdmin. Select to create a new server. Provide a name for the server

![PgAdmin-5](https://mintcdn.com/nile/SZ6JYQiPYP1_QgSP/images/pgadmin1.png?fit=max\&auto=format\&n=SZ6JYQiPYP1_QgSP\&q=85\&s=7414b416981d5b76bbb52af82f79b97f)

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

![PgAdmin-6](https://mintcdn.com/nile/SZ6JYQiPYP1_QgSP/images/pgadmin2.png?fit=max\&auto=format\&n=SZ6JYQiPYP1_QgSP\&q=85\&s=fc37400e097b58b4aaf3c51d08c0cb44)

8. Press OK and PgAdmin should automatically connect to Nile's Postgres

![PgAdmin-7](https://mintcdn.com/nile/SZ6JYQiPYP1_QgSP/images/pgadmin3.png?fit=max\&auto=format\&n=SZ6JYQiPYP1_QgSP\&q=85\&s=23303ebb7ca417dc9c0a55828c2c916c)

10. Known issues

* You cannot create a table through the UI editor. You can create a table through the query editor
* You cannot get information about indexes or constraints through the UI editor

11. Enjoy exploring Nile with PgAdmin


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.