PostgreSQL
A PostgreSQL client that belongs on a Mac.
Write queries, edit rows in place and design tables on PostgreSQL — and on Supabase, Neon, CockroachDB, TimescaleDB and YugabyteDB, which connect through the same driver.
Free for the databases on your Mac. Pricing
What PostgreSQL gets.
The kinds of object that exist on an engine are the kinds the app shows. This is PostgreSQL's row of the features table, and what stands behind it.
| Engine | Editable grid | Designers | Users & Roles | Diagram |
|---|---|---|---|---|
| PostgreSQL and Supabase, Neon, CockroachDB, TimescaleDB, YugabyteDB | ✓ | ✓all kinds | ✓ | ✓ |
A designer for every kind of object
Tables, sequences, types and triggers, and the kinds only PostgreSQL has: aggregates, conversions, operators, operator classes, extensions, casts and tablespaces. Designers open as tabs and preview their SQL.
Guide: kinds of objectColumn types that cast
The table designer retypes a column with ALTER COLUMN … TYPE … USING, so the values already there are cast, and its script runs in a transaction.
Roles, with everything there is to set
Can log in, superuser, create databases, create roles, inherit, replication, bypass row security, a connection limit and an expiry date — and grants at database, schema and table level.
Guide: users and rolespsql, already signed in
A console tab is a real terminal running psql with the connection's host, port, user and password, through its SSH tunnel or proxy if it has one. The password is never put on the command line.
Connect to PostgreSQL.
Click Add Connection under the sidebar and pick the PostgreSQL tile. Paste a connection string — the field reads postgresql:// addresses — and the fields fill themselves in, or type the host, port, database, user and password. Click Test Connection, then Add.
- Default port
- 5432
- SSL
- Disabled, Required, Verify Certificate
- Servers
- PostgreSQL 11 and newer: the schema browser reads
pg_proc.prokind, which arrived in 11. - Console
psql—brew install libpq- Notes
- Every designer, including aggregates, conversions, operators, operator classes, extensions, casts and tablespaces. The fullest Users & Roles pane.
Hosted services built on PostgreSQL get a tile of their own with the port and SSL mode they expect:
Supabase
Neon
CockroachDB
TimescaleDB
YugabyteDB
| Service | Port | SSL |
|---|---|---|
| Supabase | 5432 | Verify Certificate |
| Neon | 5432 | Verify Certificate |
| CockroachDB | 26257 | Verify Certificate |
| TimescaleDB | 5432 | Disabled |
| YugabyteDB | 5433 | Disabled |
One app for the rest of your databases, too.
Every feature is built against one driver contract, so the grid, the designers and the assistant work the same whichever server you open next.
MySQL
MariaDB
SQLite
SQL Server
Oracle
IBM Db2
MongoDB
Redis
DuckDBand CSV files
ClickHouse
DatabricksTry it on your own database.
Free for the databases on your Mac, and never asking you to sign in.
$brew install --cask az-code-lab/taps/dbclient