// the find
tconbeer/harlequin
The SQL IDE for Your Terminal.
Harlequin is a terminal SQL IDE built on Textual, with a companion CLI (hsql) for scripted/agent use against the same adapters and config. It's aimed at people who live in a terminal and want a real query editor with autocomplete, a data catalog, and export, rather than psql or a GUI client — plus a non-interactive mode for automation.
Adapter model is genuinely pluggable — DuckDB and SQLite ship in-tree, but Postgres/MySQL/Snowflake/etc. are separate installable packages, so the core stays small. hsql sharing config and adapters with the interactive app (not a bolted-on wrapper) means one profile file works for both a human and a script. Read-only and timeout modes are enforced at the adapter level and refuse to start if the adapter can't guarantee them, which is the right failure mode for something agents will call unattended. Config supports env var interpolation with secret masking, so shared profiles don't leak credentials in logs or `--config show` output.
It's a single-maintainer project (Ted Conbeer) — bus factor is a real risk for something people will wire into automation. Adapter quality outside DuckDB/SQLite is uneven since they're community-maintained plugins with their own release cadence and bug trackers, so 'works with dozens of databases' means variable experience depending which one you pick. Textual as the UI layer means you inherit Textual's terminal-compatibility quirks (some terminals render it poorly, SSH/tmux edge cases). No mention of a stable wire protocol or versioning guarantee for hsql's output format, which matters if you're scripting against it and don't want a Harlequin upgrade to silently break your parsing.