# Install harlequin with Homebrew, Nix Easy, fast, and beautiful database client for the terminal. Version 2.5.2 via Homebrew; verified 2026-07-11. Also installable with nix: nix profile install nixpkgs#harlequin. ## Install ```sh sudo av install brew:harlequin ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install harlequin ``` Evidence: local Homebrew formula metadata ### Linux - Nix (92%): ```sh nix profile install nixpkgs#harlequin ``` Evidence: nixpkgs package indexes: pkgs/by-name/ha/harlequin/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 ## Package facts - **Package key:** brew:harlequin - **Package manager:** Homebrew - **Version:** 2.5.2 - **Source summary:** Easy, fast, and beautiful database client for the terminal - **Homepage:** - **Repository:** - **Last updated:** 2026-07-11T10:53:51Z - **Generated:** 2026-08-03T19:37:03+00:00 ## Executables - harlequin (alias) ## Install behavior - Bottle: not available ## Freshness - Page generated: 2026-08-03 - Package-manager version: 2.5.2 ## Project history and usage Harlequin is a terminal SQL IDE created by Ted Conbeer to bring editor-style database work into a TUI. It began in 2023 as a Python/Textual application centered on DuckDB, then grew into a plugin-oriented database client with adapters for SQLite, PostgreSQL, MySQL/MariaDB, ODBC, BigQuery, Trino, Databricks, ADBC, and other back ends. ### Project history The public repository started in May 2023 with early commits for a working CLI, schema sidebar, query editor, and data viewer. The 0.0.x changelog shows a fast iteration cycle: query execution became asynchronous, SQL files could be opened and saved from the editor, DuckDB extension support landed, multiple editor buffers and multiple result tabs appeared, and database-file workflows gained read-only and export features. Version 1.0.0, tagged in September 2023, marked the point where the core terminal database-client experience had settled enough for a named milestone. Subsequent development broadened Harlequin from a DuckDB-first SQL TUI into a general database client: the official docs describe adapter plug-ins as the generic interface to databases and list core and community adapters beyond the built-in DuckDB and SQLite support. ### Adoption history Harlequin's adoption path follows the DuckDB and terminal-UI communities: it is installable with Python tooling, documented as having a Homebrew formula, and packaged in Homebrew and Nix in the supplied package-manager facts. Its README also notes that the Homebrew formula bundles several adapter packages, which made the formula attractive for users who wanted a single terminal SQL client with more than DuckDB support. The project attracted package-manager attention because it sits at the intersection of several popular command-line trends: local analytical databases, terminal user interfaces, Python application packaging, and pluggable database adapters. ### How it is used Harlequin is run as a command-line application, commonly with no arguments for an in-memory DuckDB session or with database paths/connection strings for concrete databases. Users can pass adapter options from the shell, keep profiles in TOML config files, edit and execute SQL in a terminal editor, browse catalogs, and export result data. The adapter model is central to everyday use. The official adapter docs describe DuckDB as the default, SQLite as built in, and additional adapters as Python packages discovered at runtime, so package installs often matter as much as the core executable. ### Why package nerds care Harlequin is interesting to package nerds because it packages a rich, stateful terminal application rather than a small single-purpose CLI. Formula maintainers have to care about Python runtime behavior, optional adapters, database client dependencies, and config discovery. It also illustrates a newer class of Homebrew formula: a Python TUI that competes with native database CLIs by bundling editor, catalog, and result-viewer behavior into one command while still remaining scriptable enough to live in terminal workflows. ### Timeline - 2023-05: Public repository history begins with a working CLI, schema sidebar, query editor, and data viewer. - 2023-06: Early 0.0.x releases add multi-database catalog behavior, read-only database opening, MotherDuck support, and terminal key-binding improvements. - 2023-09: Version 1.0.0 is tagged after rapid 0.0.x iteration. - 2025-01: Version 2.0.0 is tagged, continuing the project after the initial SQL TUI became a broader adapter-based database client. - 2026-03: Version 2.5.2 is tagged in the upstream repository. ### Related projects - DuckDB is the default database target and part of Harlequin's early identity. - Textual is the Python terminal UI framework behind Harlequin's interactive interface. - Adapter packages such as harlequin-postgres, harlequin-mysql, and harlequin-odbc extend the core client to additional database systems. ### Sources - Official Harlequin documentation for installation, configuration, database adapters, and DuckDB usage. - Official Harlequin repository and release/changelog history. ## Security Notes broad file, network, media, or database tool signal. - **Geiger risk:** blue / medium - broad file, network, media, or database tool signal ## Configuration and credential file locations These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval. ## Configuration files - Unix: $PWD/harlequin.toml, $PWD/.harlequin.toml, $PWD/pyproject.toml, $XDG_CONFIG_HOME/harlequin/harlequin.toml, ~/.config/harlequin/harlequin.toml ## Other Package-Manager Records - Nix - harlequin: normalized package name match | nixpkgs package indexes: pkgs/by-name/ha/harlequin/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 ## Combined YAML source View the package source record on GitHub. [combined/harlequin.yml](https://github.com/mxcl/pkgdb/blob/main/combined/harlequin.yml) ## Sources - pkg.so package database - Geiger risk classifier - curated configuration and credential file locations - curated package history - pkgdb category and tag curation - external package-manager database matches - cross-ecosystem install command graph