Your First Connection
- Click New at the top of the connection list in the sidebar (or New connection if the list is empty).
- Fill in the connection form:
- Name — anything, e.g.
prod analytics. Optionally pick a Colour to tell environments apart at a glance (8 presets or a custom hex value). - Engine — PostgreSQL. (A MySQL option is visible in the dropdown, but MySQL support is coming soon — it doesn’t work yet.)
- Host / Port / Database / Username / Password — port defaults to
5432. - TLS —
disable,prefer, orrequire. Userequirefor any remote database.
- Name — anything, e.g.
- Click Test Connection. A green check with “Database connection successful” confirms the credentials work; a failed test shows the underlying error.
- Click Save connection, select the connection in the sidebar, then click Connect. A green dot next to the name shows it’s active.
- The Overview tab shows six cards: Version, Database Size, Tables, Users, Active Connections, and Uptime.
Your password is stored in the macOS Keychain — the connection profile on disk holds only a reference to it, never the secret itself.
Need to reach a database behind a bastion host? See SSH Tunneling. Ready to let Claude query it? See Connecting Claude (MCP).