notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photos
All times are UTC
Ukraine
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
After the ports freeze to fix some stuff, the freeze is over. I have some work to do before FreshPorts can start processing commits again before it can start processing again. I've created an issue for that.
Port details
py-harlequin SQL IDE for your terminal
2.9.0 databases on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 2.5.2Version of this port present on the latest quarterly branch.
Broken BROKEN: fails to run because requires devel/py-tree-sitter >= 0.25.2 (see PR 289772)
Ignore IGNORE: is marked as broken: fails to run because requires devel/py-tree-sitter >= 0.25.2 (see PR 289772)
Maintainer: nivit@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2026-01-31 15:51:11
Last Update: 2026-08-15 07:18:06
Commit Hash: 1bc6e53
People watching this port, also watch:: tcpdump, metalock
Also Listed In: python
License: MIT
WWW:
https://harlequin.sh/
Description:
Harlequin is an easy, fast, and beautiful database client for the terminal. It has all the features you'd expect from an SQL IDE, delightfully running right in your terminal. - View tables, columns, and their types across one or more attached databases. Optionally view local files or S3 objects. - A full-featured editor: autocomplete, open, save, format, cut, copy, paste, and more. Supports multiple tabbed buffers! - View 1M+ results in an interactive table. Multiple queries loaded into separate tabs. - Full Screen - Export query results and configure the export using a helpful UI. - View a list of executed queries and a summary of results. Select to insert into a new buffer.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}harlequin>0:databases/py-harlequin@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/py-harlequin/ && make install clean
We doubt a package is available for this port because we see it marked as as:
  • Broken
  • Ignore
Packages are normally not provided for ports that are marked as above.
To add the package, run one of these commands:
  • pkg install databases/py-harlequin
  • pkg install py312-harlequin
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
NOTE: This is a Python port. Instead of py312-harlequin listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py312-harlequin
Package flavors (<flavor>: <package>)
  • py312: py312-harlequin
distinfo:
TIMESTAMP = 1786777563 SHA256 (harlequin-2.9.0.tar.gz) = b1824b0ba790e65ea3092000a95660d1ba3836c8729b7f7d7dd18364488b4dae SIZE (harlequin-2.9.0.tar.gz) = 148513

No package information for this port in our database
Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link: pkg-fallout
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py312-hatchling>=1.28.0 : devel/py-hatchling@py312
  2. python3.12 : lang/python312
  3. py312-build>=0 : devel/py-build@py312
  4. py312-installer>=0 : devel/py-installer@py312
Test dependencies:
  1. python3.12 : lang/python312
Runtime dependencies:
  1. py312-click>=8.1.7_1 : devel/py-click@py312
  2. py312-duckdb>=1.5.5 : databases/py-duckdb@py312
  3. py312-pandas>=2.3.3,1 : math/py-pandas@py312
  4. py312-platformdirs>=4.5.1 : devel/py-platformdirs@py312
  5. py312-pyperclip>=1.11.0 : devel/py-pyperclip@py312
  6. py312-questionary>=2.1.1 : devel/py-questionary@py312
  7. py312-rich-click>=1.8.5 : devel/py-rich-click@py312
  8. py312-shandy-sqlfmt>=0.29.0 : devel/py-shandy-sqlfmt@py312
  9. py312-textual-fastdatatable>=0.14.0 : textproc/py-textual-fastdatatable@py312
  10. py312-textual-textarea>=0.17.2 : textproc/py-textual-textarea@py312
  11. py312-textual>=6.11.0 : textproc/py-textual@py312
  12. py312-tomlkit>=0.13.3 : textproc/py-tomlkit@py312
  13. py312-tree-sitter-sql>=0.3.11 : devel/py-tree-sitter-sql@py312
  14. py312-tree-sitter>=0.25.2 : devel/py-tree-sitter@py312
  15. py312-wcwidth>=0.8 : devel/py-wcwidth@py312
  16. python3.12 : lang/python312
This port is required by:
for Run
  1. databases/py-harlequin-mysql
  2. databases/py-harlequin-postgres

Configuration Options:
No options to configure
Options name:
databases_py-harlequin
USES:
python
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/h/harlequin/
  2. https://pypi.org/packages/source/h/harlequin/
Collapse this list.

Number of commits found: 6

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
2.9.0
15 Aug 2026 07:18:06
commit hash: 1bc6e530d9123e873bf7a689502acea5927e9248commit hash: 1bc6e530d9123e873bf7a689502acea5927e9248commit hash: 1bc6e530d9123e873bf7a689502acea5927e9248commit hash: 1bc6e530d9123e873bf7a689502acea5927e9248 files touched by this commit
Nicola Vitale (nivit) search for other commits by this committer
databases/py-harlequin: Update to 2.9.0

- Update list of run dependencies

ChangeLog:	https://github.com/tconbeer/harlequin/releases/tag/v2.9.0
Reported by:	Ted Conbeer <notifications@github.com>
2.8.1
14 Aug 2026 08:33:03
commit hash: 7a8971c22836afb40811195ce4ee1115e3412e7ecommit hash: 7a8971c22836afb40811195ce4ee1115e3412e7ecommit hash: 7a8971c22836afb40811195ce4ee1115e3412e7ecommit hash: 7a8971c22836afb40811195ce4ee1115e3412e7e files touched by this commit
Nicola Vitale (nivit) search for other commits by this committer
databases/py-harlequin: Update to 2.8.1

ChangeLog:	https://github.com/tconbeer/harlequin/releases/tag/v2.8.1
Reported by:	Ted Conbeer <notifications@github.com>
2.8.0
09 Aug 2026 15:59:22
commit hash: 87d8f8e6f60eef226724be71ff53f14c2ec28ecccommit hash: 87d8f8e6f60eef226724be71ff53f14c2ec28ecccommit hash: 87d8f8e6f60eef226724be71ff53f14c2ec28ecccommit hash: 87d8f8e6f60eef226724be71ff53f14c2ec28ecc files touched by this commit
Nicola Vitale (nivit) search for other commits by this committer
databases/py-harlequin: Update to 2.8.0

ChangeLog:

- https://github.com/tconbeer/harlequin/releases/tag/v2.6.0
- https://github.com/tconbeer/harlequin/releases/tag/v2.7.0
- https://github.com/tconbeer/harlequin/releases/tag/v2.8.0

Reported by:	Ted Conbeer <notifications@github.com>
2.5.2
27 Mar 2026 13:23:09
commit hash: b04e8b3175a6802d3c56b571639f80a4a777f816commit hash: b04e8b3175a6802d3c56b571639f80a4a777f816commit hash: b04e8b3175a6802d3c56b571639f80a4a777f816commit hash: b04e8b3175a6802d3c56b571639f80a4a777f816 files touched by this commit
Nicola Vitale (nivit) search for other commits by this committer
databases/py-harlequin: Update to 2.5.2

ChangeLog:	https://github.com/tconbeer/harlequin/releases/tag/v2.5.2
Reported by:	Ted Conbeer <notifications@github.com>
2.5.1_1
06 Feb 2026 10:38:50
commit hash: 487d47c4ebbb6bf48b6f70814ab39f4d693fee8bcommit hash: 487d47c4ebbb6bf48b6f70814ab39f4d693fee8bcommit hash: 487d47c4ebbb6bf48b6f70814ab39f4d693fee8bcommit hash: 487d47c4ebbb6bf48b6f70814ab39f4d693fee8b files touched by this commit
Nicola Vitale (nivit) search for other commits by this committer
databases/py-harlequin: Add missing dependency

- Bump PORTREVISION
- Mark BROKEN: fails to run because requires devel/py-tree-sitter >= 0.25.2
  (see https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=289772 )
2.5.1
31 Jan 2026 15:32:33
commit hash: e71cbdf569b2bbfdef3327aac82a3f312886a993commit hash: e71cbdf569b2bbfdef3327aac82a3f312886a993commit hash: e71cbdf569b2bbfdef3327aac82a3f312886a993commit hash: e71cbdf569b2bbfdef3327aac82a3f312886a993 files touched by this commit
Nicola Vitale (nivit) search for other commits by this committer
databases/py-harlequin: Add new port

Harlequin is an easy, fast, and beautiful database client for the terminal.

It has all the features you'd expect from an SQL IDE, delightfully running
right in your terminal.

  - View tables, columns, and their types across one or more attached
    databases. Optionally view local files or S3 objects.
  - A full-featured editor: autocomplete, open, save, format, cut, copy, paste,
    and more. Supports multiple tabbed buffers!
  - View 1M+ results in an interactive table. Multiple queries loaded into
    separate tabs.
  - Full Screen
  - Export query results and configure the export using a helpful UI.
  - View a list of executed queries and a summary of results. Select to insert
    into a new buffer.

https://harlequin.sh/

Number of commits found: 6