Harlequin
Terminal SQL IDE for querying multiple databases with adapters.
Tested on Linux
Use it
Linux x86_64
You need first
- Runtimes:
Python 3.9 or above
install harlequin via uv tool install
uv tool install harlequin
Check that it works
harlequin --helpThe output should contain “harlequin [OPTIONS] [CONN_STR]”.
First thing to try
cat > /tmp/make_db2.py << 'PY'
import sqlite3
con=sqlite3.connect("/tmp/test_sqlite.db")
con.execute("drop table if exists users")
con.execute("create table users (id integer primary key, name text)")
con.execute("insert into users values (1,'Ted'), (2,'Patrick')")
con.commit()
con.close()
print("done sqlite")
# also try duckdb via CLI
PY
python3 /tmp/make_db2.py && ls -lh /tmp/test_sqlite.db
hsql --adapter duckdb -c "create table users (id integer, name varchar); insert into users values (1,'Ted'), (2,'Patrick')" "/tmp/test_duck.db" 2>&1 | head; echo "exit:$?"
ls -lh /tmp/test_duck.db 2>&1hsql -a sqlite "/tmp/test_sqlite.db" -c "select * from users"What it does
- Edit and execute SQL queriesTested
- Browse data catalogTested
- Export query dataTested
- Run headless queries via hsqlTested
How far pickfit got
Linux x86_64
- Installs
- Starts
- 4 of 4 features work
- Works offline
macOS and Windows: the project says it runs there; pickfit hasn’t tried it.
Good for
- open an in-memory DuckDB session
- open DuckDB database files
- open an in-memory SQLite database
- run SQL headless via hsql
- explore database catalog without SQL
How pickfit tested it
Each run starts from a clean machine and follows the steps above. How pickfit verifies
Linux x86_64
Its main function works
- Replayed from scratch
- Works offline
- Checked on 4 Nov 2026
- Version 2.17.0