Harlequin SQL CLI IDE

brehttps://harlequin.sh/ is a terminal base SQL IDE.

Install

Install [[python | python with pyenv and pipx]]. Then:

# install halrequin
pipx install harlequin

# add postgres adapter
pip install harlequin-postgres

# inject adapter to existing installation
pipx inject harlequin harlequin-postgres

# start a session
harlequin -a postgres # opens in default database

# use a postgres DSN (https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING)
harlequin -a postgres -d {dbname}

# with a theme
harlequin -a postgres -t dracula -d {dbname}

# show files
harlequin -a postgres -t dracula -f /path/to/dir

# open with a profile
harlequin --profile {profile}

Default keybindings: https://harlequin.sh/docs/bindings---