This project provides the Harlequin adapter for Postgres. For more information, see harlequin.sh.
You must install the harlequin-postgres
package into the same environment as harlequin
. The best and easiest way to do this is to use uv
to install Harlequin with the postgres
extra:
uv tool install 'harlequin[postgres]'
To connect to a Postgres database, run Harlequin with the -a postgres
option and pass a Posgres DSN as an argument:
harlequin -a postgres "postgres://my-user:my-pass@localhost:5432/my-database"
You can also pass all or parts of the connection string as separate options. The following is equivalent to the above DSN:
harlequin -a postgres -h localhost -p 5432 -U my-user --password my-pass -d my-database
The supported connection options are:
host
port
dbname
user
password
passfile
require_auth
channel_binding
connect_timeout
sslmode
sslcert
sslkey
For descriptions of each option, run:
harlequin --help
Harlequin's Postgres driver will load connection information from the standard PG*
environment variables. Any options supplied at the command-line will override environment variables.
To use Manual transaction mode, click on the label in the Run Query Bar to toggle the transaction mode from Auto to Manual.
For more information, see the Harlequin Docs.