Harlequin is a SQL IDE that runs in the terminal. It has a data catalog, a query editor with autocomplete and a results viewer. DuckDB and SQLite work out of the box; the Postgres and MySQL adapters are included too.
Examples
harlequin ./my-data.duckdb
harlequin -a sqlite ./my-data.db
harlequin -a postgres "postgres://user:password@localhost:5432/mydb"
File access
Harlequin can use database files in your home directory. To also use USB drives and other removable media (/media, /mnt), run:
sudo snap connect harlequin:removable-media
You are about to open
Do you wish to proceed?
Thank you for your report. Information you provided will help us investigate further.
There was an error while sending your report. Please try again later.
Snaps are applications packaged with all their dependencies to run on all popular Linux distributions from a single build. They update automatically and roll back gracefully.
Snaps are discoverable and installable from the Snap Store, an app store with an audience of millions.
Snap can be installed from the command line. Open the Konsole terminal and enter the following:
sudo apt update
sudo apt install snapd
To install Harlequin, simply use the following command:
sudo snap install harlequin
Browse and find snaps from the convenience of your desktop using the snap store snap.
Interested to find out more about snaps? Want to publish your own application? Visit snapcraft.io now.