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.
Volunteers wanted to help translate FreshPorts
Port details
sq CLI tool for querying multiple databases and data formats
0.55.0_1 databases on this many watch lists=0 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 0.55.0_1Version of this port present on the latest quarterly branch.
Maintainer: olgeni@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2025-07-09 07:27:06
Last Update: 2026-10-08 20:44:12
Commit Hash: 031fc6b
License: MIT
WWW:
https://sq.io/
Description:
sq is a command-line tool that provides jq-style access to structured data sources including SQL databases and document formats like CSV, Excel, and JSON. Key features: - Query multiple database types (PostgreSQL, MySQL, SQLite, SQL Server, etc.) - Cross-source joins between different databases and file formats - Multiple output formats (JSON, CSV, Excel, HTML, XML, Markdown) - Database inspection and schema comparison - SQL execution with syntax highlighting - Data import/export between sources sq simplifies working with structured data by providing a unified interface for querying and transforming data across various sources.
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
Expand this list (4 items)
Collapse this list.
  1. bin/sq
  2. /usr/local/share/licenses/sq-0.55.0_1/catalog.mk
  3. /usr/local/share/licenses/sq-0.55.0_1/LICENSE
  4. /usr/local/share/licenses/sq-0.55.0_1/MIT
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • sq>0:databases/sq
To install the port:
cd /usr/ports/databases/sq/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/sq
  • pkg install sq
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: sq
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1789045992 SHA256 (go/databases_sq/neilotoole-sq-v0.55.0_GH0/v0.55.0.mod) = c76b38a5e65e20890081bd208ee0a5278b0771aebca74e46f0ffa88cd00e7725 SIZE (go/databases_sq/neilotoole-sq-v0.55.0_GH0/v0.55.0.mod) = 8529

Expand this list (4 items)

Collapse this list.

SHA256 (go/databases_sq/neilotoole-sq-v0.55.0_GH0/v0.55.0.zip) = f7f77b3fd0d14e01f6dd14698500f90c074a1b263197727f346fed389c0489f5 SIZE (go/databases_sq/neilotoole-sq-v0.55.0_GH0/v0.55.0.zip) = 54222143 SHA256 (go/databases_sq/neilotoole-sq-v0.55.0_GH0/neilotoole-sq-v0.55.0_GH0.tar.gz) = ab9f0595423269eacf43a531f1d101e296f100aabec95781dc8af6ab1c155739 SIZE (go/databases_sq/neilotoole-sq-v0.55.0_GH0/neilotoole-sq-v0.55.0_GH0.tar.gz) = 86254536

Collapse this list.


Packages (timestamps in pop-ups are UTC):
sq
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64leriscv64
FreeBSD:13:latest0.48.11_40.48.11_4n/an/an/an/an/an/an/a
FreeBSD:13:quarterly0.48.11_40.48.11_4n/an/an/an/an/an/an/a
FreeBSD:14:latest0.55.00.55.0-0.48.5_20.55.0----
FreeBSD:14:quarterly0.48.11_90.55.0--0.55.0----
FreeBSD:15:latest0.55.00.55.0n/a-n/an/a---
FreeBSD:15:quarterly0.55.00.48.11_9n/a-n/an/a---
FreeBSD:16:latest0.55.00.55.0n/a-n/an/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. go127 : lang/go127
Library dependencies:
  1. libduckdb.so : databases/duckdb
Fetch dependencies:
  1. go127 : lang/go127
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_sq
USES:
go:modules zip
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://codeload.github.com/neilotoole/sq/tar.gz/v0.55.0?dummy=/
  2. https://proxy.golang.org/github.com/neilotoole/sq/@v/
Collapse this list.

Number of commits found: 26

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
0.55.0_1
08 Oct 2026 20:44:12
commit hash: 031fc6bfbf58dd0aadc59bc428be611930856ffccommit hash: 031fc6bfbf58dd0aadc59bc428be611930856ffccommit hash: 031fc6bfbf58dd0aadc59bc428be611930856ffccommit hash: 031fc6bfbf58dd0aadc59bc428be611930856ffc files touched by this commit
Dag-Erling Smørgrav (des) search for other commits by this committer
various: Bump Go ports
0.55.0
11 Sep 2026 00:54:44
commit hash: 46b21e97498f64e6747fc0388baca3f436498c7dcommit hash: 46b21e97498f64e6747fc0388baca3f436498c7dcommit hash: 46b21e97498f64e6747fc0388baca3f436498c7dcommit hash: 46b21e97498f64e6747fc0388baca3f436498c7d files touched by this commit
Jimmy Olgeni (olgeni) search for other commits by this committer
databases/sq: Update to 0.55.0
0.54.1_2
03 Sep 2026 04:50:55
commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01commit hash: dd0905142a9a35cdf8267e2706db9488b516ad01 files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
many: Bump go ports for 1.26.8 and 1.27.1
0.54.1_1
28 Aug 2026 22:31:12
commit hash: 1b098f9ad5e9fbc1f0e6012670074673bdaa4fadcommit hash: 1b098f9ad5e9fbc1f0e6012670074673bdaa4fadcommit hash: 1b098f9ad5e9fbc1f0e6012670074673bdaa4fadcommit hash: 1b098f9ad5e9fbc1f0e6012670074673bdaa4fad files touched by this commit
Jimmy Olgeni (olgeni) search for other commits by this committer
databases/sq: Set the version at build time
0.54.1
25 Aug 2026 08:53:46
commit hash: a95d27abbf617ca51c1eb604c886d845cc2c4ec1commit hash: a95d27abbf617ca51c1eb604c886d845cc2c4ec1commit hash: a95d27abbf617ca51c1eb604c886d845cc2c4ec1commit hash: a95d27abbf617ca51c1eb604c886d845cc2c4ec1 files touched by this commit
Jimmy Olgeni (olgeni) search for other commits by this committer
databases/sq: Update to 0.54.1

Upstream added a DuckDB driver, whose Go bindings ship prebuilt static
libraries only for darwin, linux and windows. Build with the
duckdb_use_lib tag so that the bindings link against the system
libduckdb instead.
0.48.12
23 Aug 2026 20:46:21
commit hash: af1900922ee028b669cfaa43316fd987f8d1aa1bcommit hash: af1900922ee028b669cfaa43316fd987f8d1aa1bcommit hash: af1900922ee028b669cfaa43316fd987f8d1aa1bcommit hash: af1900922ee028b669cfaa43316fd987f8d1aa1b files touched by this commit
Jimmy Olgeni (olgeni) search for other commits by this committer
databases/sq: Update to 0.48.12
0.48.11_9
19 Aug 2026 17:39:04
commit hash: 4867821cd65241b6e8c0faa3ed76d67514594442commit hash: 4867821cd65241b6e8c0faa3ed76d67514594442commit hash: 4867821cd65241b6e8c0faa3ed76d67514594442commit hash: 4867821cd65241b6e8c0faa3ed76d67514594442 files touched by this commit
Dag-Erling Smørgrav (des) search for other commits by this committer
various: Bump go ports for go-1.25.14 / 1.26.7
0.48.11_8
14 Aug 2026 00:38:09
commit hash: 6d39dcf04e96d7cdbad58d1b7f27d25d8e3b75b8commit hash: 6d39dcf04e96d7cdbad58d1b7f27d25d8e3b75b8commit hash: 6d39dcf04e96d7cdbad58d1b7f27d25d8e3b75b8commit hash: 6d39dcf04e96d7cdbad58d1b7f27d25d8e3b75b8 files touched by this commit
Dag-Erling Smørgrav (des) search for other commits by this committer
various: Bump go ports for go-1.25.13 / 1.26.6
0.48.11_7
10 Jul 2026 07:54:15
commit hash: 4ea354713284ca756537346a9ebc6df56184ed31commit hash: 4ea354713284ca756537346a9ebc6df56184ed31commit hash: 4ea354713284ca756537346a9ebc6df56184ed31commit hash: 4ea354713284ca756537346a9ebc6df56184ed31 files touched by this commit
Dag-Erling Smørgrav (des) search for other commits by this committer
various: Bump go ports for go-1.25.12 / 1.26.5
0.48.11_6
03 Jun 2026 17:54:22
commit hash: dd8dc2a59ddc46a12ace1cc4f7a953de512853bdcommit hash: dd8dc2a59ddc46a12ace1cc4f7a953de512853bdcommit hash: dd8dc2a59ddc46a12ace1cc4f7a953de512853bdcommit hash: dd8dc2a59ddc46a12ace1cc4f7a953de512853bd files touched by this commit
Dag-Erling Smørgrav (des) search for other commits by this committer
various: Bump go ports for go-1.25.11 / go-1.26.4
0.48.11_5
09 May 2026 17:25:51
commit hash: 4e243a83f8d8d5cd511bba2b689931886b3a57cecommit hash: 4e243a83f8d8d5cd511bba2b689931886b3a57cecommit hash: 4e243a83f8d8d5cd511bba2b689931886b3a57cecommit hash: 4e243a83f8d8d5cd511bba2b689931886b3a57ce files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
various: Bump ports for Go 1.25.10
0.48.11_4
10 Apr 2026 15:57:27
commit hash: 7507e72a845b5c83e1ad035bd54b1c35482fb86acommit hash: 7507e72a845b5c83e1ad035bd54b1c35482fb86acommit hash: 7507e72a845b5c83e1ad035bd54b1c35482fb86acommit hash: 7507e72a845b5c83e1ad035bd54b1c35482fb86a files touched by this commit
Dag-Erling Smørgrav (des) search for other commits by this committer
various: Bump go ports for go-1.25.9 / 1.26.2
0.48.11_3
06 Mar 2026 03:33:23
commit hash: a8d318da7c159b84ddff6a525e2e39800ab3f795commit hash: a8d318da7c159b84ddff6a525e2e39800ab3f795commit hash: a8d318da7c159b84ddff6a525e2e39800ab3f795commit hash: a8d318da7c159b84ddff6a525e2e39800ab3f795 files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
various: Bump ports for Go 1.25.8
0.48.11_2
11 Feb 2026 19:21:45
commit hash: 97685c188649d678a8a0e5fde3e8ecb842bf9422commit hash: 97685c188649d678a8a0e5fde3e8ecb842bf9422commit hash: 97685c188649d678a8a0e5fde3e8ecb842bf9422commit hash: 97685c188649d678a8a0e5fde3e8ecb842bf9422 files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
various: Bump ports for Go default 1.24->1.25
0.48.11_1
05 Feb 2026 16:48:00
commit hash: 529df949a5b00103a138f1defddc73ef64750f2fcommit hash: 529df949a5b00103a138f1defddc73ef64750f2fcommit hash: 529df949a5b00103a138f1defddc73ef64750f2fcommit hash: 529df949a5b00103a138f1defddc73ef64750f2f files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
various: Bump Go ports for 1.24.13
0.48.11
20 Jan 2026 15:02:15
commit hash: 24aa7286ce7166c61e39afeebc2f88d23247f908commit hash: 24aa7286ce7166c61e39afeebc2f88d23247f908commit hash: 24aa7286ce7166c61e39afeebc2f88d23247f908commit hash: 24aa7286ce7166c61e39afeebc2f88d23247f908 files touched by this commit
Jimmy Olgeni (olgeni) search for other commits by this committer
databases/sq: update 0.48.10 → 0.48.11
0.48.10_1
16 Jan 2026 17:49:03
commit hash: 013f2d30b04bfe9e8d278b7bfad96a64b72c36dacommit hash: 013f2d30b04bfe9e8d278b7bfad96a64b72c36dacommit hash: 013f2d30b04bfe9e8d278b7bfad96a64b72c36dacommit hash: 013f2d30b04bfe9e8d278b7bfad96a64b72c36da files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
various: Bump Go ports for 1.24.12
0.48.10
29 Dec 2025 16:32:43
commit hash: 39b3765cfb66bfcc1de70d19aafdc97fc763e48acommit hash: 39b3765cfb66bfcc1de70d19aafdc97fc763e48acommit hash: 39b3765cfb66bfcc1de70d19aafdc97fc763e48acommit hash: 39b3765cfb66bfcc1de70d19aafdc97fc763e48a files touched by this commit
Jimmy Olgeni (olgeni) search for other commits by this committer
databases/sq: Update to 0.48.10
0.48.5_7
03 Dec 2025 18:24:45
commit hash: b24429e3ede02a855f8e7ecb3564af0287306483commit hash: b24429e3ede02a855f8e7ecb3564af0287306483commit hash: b24429e3ede02a855f8e7ecb3564af0287306483commit hash: b24429e3ede02a855f8e7ecb3564af0287306483 files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
various: Bump Go ports for 1.24.11
0.48.5_6
06 Nov 2025 17:03:19
commit hash: 0dfced16fb0f78e71c42a767df8b6f394a185d6ccommit hash: 0dfced16fb0f78e71c42a767df8b6f394a185d6ccommit hash: 0dfced16fb0f78e71c42a767df8b6f394a185d6ccommit hash: 0dfced16fb0f78e71c42a767df8b6f394a185d6c files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
various: Bump Go ports for 1.24.10
0.48.5_5
14 Oct 2025 15:13:55
commit hash: 90f976619bf883b36d921c6ab89ffc5ff156b391commit hash: 90f976619bf883b36d921c6ab89ffc5ff156b391commit hash: 90f976619bf883b36d921c6ab89ffc5ff156b391commit hash: 90f976619bf883b36d921c6ab89ffc5ff156b391 files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
various: Bump go ports for go-1.24.9
0.48.5_4
08 Oct 2025 00:41:39
commit hash: 2e7587aaf8e7f893fd2025d55f66de088427b180commit hash: 2e7587aaf8e7f893fd2025d55f66de088427b180commit hash: 2e7587aaf8e7f893fd2025d55f66de088427b180commit hash: 2e7587aaf8e7f893fd2025d55f66de088427b180 files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
many: Bump dependent ports after go124 update
0.48.5_3
04 Sep 2025 17:53:24
commit hash: 31a5a229a778dc5f458cb8887954f192d846e0e3commit hash: 31a5a229a778dc5f458cb8887954f192d846e0e3commit hash: 31a5a229a778dc5f458cb8887954f192d846e0e3commit hash: 31a5a229a778dc5f458cb8887954f192d846e0e3 files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
many: Bump go ports for go-1.24.7
0.48.5_2
07 Aug 2025 00:02:46
commit hash: 53610681ea46b375186fc68723dcc335051ef9b4commit hash: 53610681ea46b375186fc68723dcc335051ef9b4commit hash: 53610681ea46b375186fc68723dcc335051ef9b4commit hash: 53610681ea46b375186fc68723dcc335051ef9b4 files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
go ports: Bump for 1.24.6
0.48.5_1
09 Jul 2025 16:11:00
commit hash: 275975297bc1002e96f88f503cf18dea17df847ecommit hash: 275975297bc1002e96f88f503cf18dea17df847ecommit hash: 275975297bc1002e96f88f503cf18dea17df847ecommit hash: 275975297bc1002e96f88f503cf18dea17df847e files touched by this commit
Adam Weinberger (adamw) search for other commits by this committer
many: Bump PORTREVISION for go-1.24.5 update
0.48.5
09 Jul 2025 07:25:19
commit hash: dede8a40cffc3fea8ec06def0583fa2e04907072commit hash: dede8a40cffc3fea8ec06def0583fa2e04907072commit hash: dede8a40cffc3fea8ec06def0583fa2e04907072commit hash: dede8a40cffc3fea8ec06def0583fa2e04907072 files touched by this commit
Jimmy Olgeni (olgeni) search for other commits by this committer
databases/sq: Add new port

sq is a command-line tool that provides jq-style access to structured
data sources including SQL databases and document formats. It supports
cross-source joins, multiple output formats, and unified querying across
various data sources.

WWW: https://sq.io/

Number of commits found: 26