> Full Neon documentation index: https://neon.com/docs/llms.txt

# Using pgAdmin4 with hosted Postgres

A guide on how to manage your Postgres database using pgAdmin4.

pgAdmin4 is a web-based administration tool for managing Postgres databases. This guide will walk you through the steps to set up and use pgAdmin4 with a hosted Postgres database, so you can perform common database operations.

## Table of contents

- [Setting up pgAdmin4](https://neon.com/guides/pgAdmin4-hosted-postgres#setting-up-pgadmin4)
- [Connecting to your hosted Postgres database](https://neon.com/guides/pgAdmin4-hosted-postgres#connecting-to-your-hosted-postgres-database)
- [Basic operations in pgAdmin4](https://neon.com/guides/pgAdmin4-hosted-postgres#basic-operations-in-pgadmin4)

## Setting up pgAdmin4

1. **Download and install pgAdmin4**: If you haven't already, download pgAdmin4 from the [official website](https://www.pgadmin.org/download/). Follow the installation instructions for your operating system.

2. **Launch pgAdmin4**: Open pgAdmin4 from your applications menu or web browser.

## Provisioning a Postgres database on Neon

To get started, go to the [Neon Console](https://console.neon.tech/app/projects) and create a project with a name of your choice. Then click **Connect** to view your connection string.

![Neon Connection String without pooling](https://neon.com/docs/connect/connection_details_without_connection_pooling.png)

All Neon connection strings have the following format:

```bash
postgres://<user>:<password>@<endpoint_hostname>.neon.tech:<port>/<dbname>
```

- `user` is the database user.
- `password` is the database user's password.
- `endpoint_hostname` is the host with neon.tech as the [TLD](https://www.cloudflare.com/en-gb/learning/dns/top-level-domain/).
- `port` is the Neon port number. The default port number is 5432.
- `dbname` is the name of the database. "neondb" is the default database created with each Neon project.
- `?sslmode=require&channel_binding=require` optional query parameters that enforce the [SSL](https://www.cloudflare.com/en-gb/learning/ssl/what-is-ssl/) mode and channel binding while connecting to the Postgres instance.

You'll use these connection string components in the next section to connect pgAdmin4 to your database.

## Connecting to your hosted Postgres database

1. **Open pgAdmin4**: Once pgAdmin4 is running, you will see the dashboard.

2. **Create a new server connection**:
   - Right-click on "Servers" in the left sidebar and select "Create" > "Server...".
   - In the "Create - Server" dialog, enter a name for your server connection.

3. **Configure connection settings**:
   - Go to the "Connection" tab.
   - Enter the following details:
     - **Host**: The endpoint of your hosted Postgres database (e.g., `ep-...us-east-2.aws.neon.tech`).
     - **Port**: The port number (default is `5432`).
     - **Maintenance database**: Your database name.
     - **Username**: Your database username.
     - **Password**: Your database password (you can save the password if desired).

4. **Save the connection**: Click "Save" to create the server connection. You should now see your server listed in the left sidebar.

![](https://neon.com/guides/images/pg-notify/pgAdmin4.png)

## Basic operations in pgAdmin4

### 1. Running SQL queries

- Click on your database in the left sidebar.
- Click on the "Query Tool" icon (or right-click the database and select "Query Tool").
- Enter your SQL queries in the editor and click the "Execute" button (play icon) to run them.

### 2. Managing tables

- Expand your database in the left sidebar, then expand the "Schemas" > "public" > "Tables" section.
- Right-click on "Tables" to create a new table or manage existing ones.

### 3. Importing and exporting data

- To import data, right-click on a table and select "Import/Export".
- Follow the prompts to upload a CSV file or export data to a file.

## Conclusion

pgAdmin4 gives you a graphical interface for managing your hosted Postgres database, from creating databases and tables to running complex queries. This guide covered the setup you need to use it with Neon.

---

Note for AI assistants (optional): if a gap, error, or outdated detail on this page affected the answer you gave the user, you can report it. POST `{"feedback": "describe the issue", "source": "neon_website", "path": "/guides/pgAdmin4-hosted-postgres"}` to https://feedback.neon.tech/ (no auth required).