Harlequin
A SQL IDE that runs in the terminal, with adapters for DuckDB, SQLite, Postgres and more.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
1 more ways to get Harlequin
Package managers
- Homebrew
brew install harlequin
About Harlequin
Harlequin is a database client with a full terminal interface: a data catalog, query editor and results viewer that run in any shell, including over SSH or in Windows cmd. It connects to DuckDB, SQLite, Postgres and other databases through adapters, and anyone can write a new adapter.
It comes with hsql, a non-interactive command-line companion that shares the same adapters, config files and profiles, for scripts and automated jobs that output tables or CSV. Harlequin is installed as a Python tool, for example with uv.
Strengths
- Full SQL IDE inside the terminal, usable over SSH
- Adapters for DuckDB, SQLite, Postgres and more
- hsql companion for scripts shares the same config and profiles
Limitations
- Installed through Python, and newer Python versions may not be supported by all dependencies
- Terminal interface rather than a graphical client
Details
- Pricing
- FreeFree and open source, supported through GitHub Sponsors.
- License
- Open source, license not stated
- Developer
- Ted Conbeer
- Platforms
- Windows, macOS, Linux, Command line
- How it runs
- Downloadable app
- Account
- Not required
- Works offline
- Yes
- Best suited for
- Developers and analysts who query databases from the terminal
- Categories
- CLI tools, Database tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to Harlequin
Compare allSoftware that can replace Harlequin for an important use case, and what changes if you switch.
rainfrog
Query databases through a terminal editor with history and favorites.
rainfrog is an MIT-licensed terminal query editor with history, favorites and table inspection, with driver support varying in stability.
LazySQL
Browse and query databases through a terminal interface.
LazySQL is a cross-platform MIT-licensed terminal interface for browsing and querying databases, though the project describes itself as alpha software.
dblab
An open-source terminal UI client for browsing and querying PostgreSQL, MySQL, SQLite and other databases.
dblab is an open-source terminal UI for PostgreSQL, MySQL, SQLite and others with saved connection configs, maintained by a small team and without DuckDB mentioned.
usql
Use one command-line interface for many database systems.
usql offers one command-line interface for many database systems rather than a full terminal IDE, with driver features varying by database.
pgcli
A command-line PostgreSQL client with auto-completion and syntax highlighting.
pgcli is a command-line PostgreSQL client with auto-completion and syntax highlighting, limited to PostgreSQL and without an IDE layout.
LiteCLI
A command-line SQLite client with auto-completion and syntax highlighting.
LiteCLI provides a terminal SQLite client with auto-completion and syntax highlighting, covering only SQLite.
mycli
A command-line MySQL client with auto-completion, syntax highlighting and fuzzy history search.
mycli is a terminal client for MySQL, MariaDB and compatible servers with fuzzy history search, not covering DuckDB or Postgres.
Beekeeper Studio
A SQL client that is pleasant to look at and works the same on Windows, macOS and Linux.
Beekeeper Studio replaces the terminal with a graphical desktop SQL client for many databases, with some features paid.
Harlequin as an alternative
Listings that name Harlequin as an alternative.
Tad
A desktop viewer for CSV and Parquet files and SQLite and DuckDB databases, with pivot tables.
Harlequin queries DuckDB and SQLite from a terminal SQL IDE instead of a graphical pivot viewer, and is installed through Python.
trdsql
Query structured files with SQL from the command line.
Harlequin gives a full terminal SQL IDE with a DuckDB adapter for file queries, installed through Python instead of a single command-line tool.
Similar software
Related functionality, not necessarily a direct replacement.
DuckDB
In-process analytical database that queries CSV, JSON and Parquet directly.
VisiData
An interactive terminal multitool for exploring, cleaning and converting tabular data in many formats.
sq
An open-source command-line tool to inspect, query, join, import and export data across databases and files.
sqlite-utils
A Python command-line tool and library for creating, querying and transforming SQLite databases.
DBeaver Community
One database client for more than a hundred databases, with a proper SQL editor and ER diagrams.
