# GUI Clients

A database GUI gives you a table browser and a query editor side by side, which is the most comfortable way to explore the books. Any PostgreSQL client works — these are the ones we use.

## What to type where

Every client asks for the same fields, under slightly different names. Take the values from **Settings → Database Access**:

| Field | Value |
| --- | --- |
| Host | `db.instabooks.io` |
| Port | `5432` |
| Database | Your company's id — the long number shown in **Settings**. |
| User | Your Instabooks email address. |
| Password | The password you generated for this company. |
| SSL / TLS | `require` (or "Require", or simply on). The connection is always encrypted. |

> **One company per connection.** The database name and the password go together — a password issued for one company will not open another. If you work in several companies, save one connection per company.

## What you'll see

- The **tables** in the `public` schema, each with a description, and a description on every column. Most clients show these in the table's column list or in a tooltip — they are worth reading before you write a query.
- **Nothing is editable.** The connection is read-only, so a client's row editor will not save.

## Writing queries

We support a subset of SQL that we believe is sufficient for most analytical applications. The [Tables & SQL](/docs/db/sql.md) page documents the details. If there is a PostgreSQL feature you would like to see implemented, please get in touch.

Next: the [Tables and SQL reference](/docs/db/sql.md), or [Troubleshooting](/docs/db/troubleshooting.md) if a connection is refusing.