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

# Using PostgreSQL client applications

> Master PostgreSQL database management with our guide on using client applications, featuring pgAdmin III tips and useful links.

This article describes how to use PostgreSQL client applications to access and manage your PostgreSQL databases.

## PostgreSQL client applications

There are numerous GUI (graphical user interface) client applications that you can use to manage PostgreSQL databases. These client applications enable you to view databases, run SQL queries, and more.

One of the most popular and widely-used PostgreSQL client applications is pgAdmin III. This application is free to download and use, and there are versions available for several operating systems, including Microsoft Windows, macOS, and Linux.

## Using pgAdmin III

To download pgAdmin III, visit [http://www.pgadmin.org/download](http://www.pgadmin.org/download). Follow the instructions for your computer's operating system to install the application.

After you have downloaded and installed pgAdmin III, you can use it to manage your PostgreSQL databases. To do this, follow these steps:

1. You must first set up a remote PostgreSQL connection, either by using a SSH tunnel, or by using a direct connection to the hosting.com server.
   > 📘 Note
   >
   > For detailed information about how to set up a remote PostgreSQL connection, please see [this article](/docs/remote-postgresql-connections).

2. After you have established a remote connection to the server, start pgAdmin III.

3. On the **File** menu, click **Add Server**.

4. On the **Properties** tab, in the **Name** text box, type a name for the server connection. The name can be whatever you want.

5. In the **Host** text box, type `localhost`.

6. Confirm that the **Port** text box value is set to **5432**.

7. In the **Maintenance DB** text box, type the name of the PostgreSQL database that you want to access.

8. In the **Username** text box, type the username for the PostgreSQL database.

9. In the **Password** text box, type the username's password.
   > 👍 Tip
   >
   > To have pgAdmin III remember the password, select the **Store password** check box.

10. Click **OK**. pgAdmin III connects to the server.

11. In the **Object browser** pane, click the **+** icon next to the connection name you specified in step 4. The tree expands to show **Databases**, **Tablespaces**, **Group Roles**, and **Login Roles**.

12. Click **Databases**, and then click the name of the database you specified in step 7.

* To access the PostgreSQL console for the database, on the **Plugins** menu, click **PSQL Console**.

* To run the SQL query tool, on the **Tools** menu, click **Query tool**.

## More information

To view the online documentation for pgAdmin III, please visit [http://www.pgadmin.org/docs](http://www.pgadmin.org/docs).

## Related articles

* [Remote PostgreSQL connections](/docs/remote-postgresql-connections)

* [Connecting to PostgreSQL using psql](/docs/connect-to-postgresql-from-the-command-line)