pkg.soopen package index

brew / rank 2673

Install sq with Homebrew, apk, apt, MacPorts, Nix, scoop

Data wrangler with jq-like query language. Version 0.54.1 via Homebrew; verified 2026-07-26. Also installable with debian: sudo apt install sq.

Install commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install sq

local Homebrew formula metadata

MacPortsverified · 94%
sudo port install sq

MacPorts ports tree · databases/sq/Portfile · source: api.github.com

Linux

Alpine Linux apkverified · 92%
sudo apk add sq

Alpine Linux edge package indexes · sq · source: dl-cdn.alpinelinux.org

Debian aptverified · 92%
sudo apt install sq

Debian stable package indexes · sq · source: deb.debian.org

Nixverified · 92%
nix profile install nixpkgs#sq

nixpkgs package indexes · pkgs/by-name/sq/sq/package.nix · source: api.github.com

Windows

Scoopverified · 92%
scoop install main/sq

Scoop official bucket manifest trees · bucket/sq.json · source: api.github.com

overview

Package summary

Data wrangler with jq-like query language

Commands and aliases

  • sq

history

Project history and usage

sq is a Go command-line data wrangler that gives jq-style access to SQL databases and structured document formats such as CSV, Excel, JSON, and XML.

Project history

The GitHub repository was created in 2016. The official README describes sq as the 'lovechild of SQL+jq', able to run jq-like queries or database-native SQL and to join across heterogeneous sources.

Adoption history

sq is packaged across several package-manager ecosystems, including Homebrew, Debian, Ubuntu, Alpine, MacPorts, Nix, and Scoop according to the supplied package metadata. Its GitHub releases have continued through v0.54.1 in 2026, and the project maintains a dedicated documentation site at sq.io.

How it is used

Users add data sources with `sq add`, query them with jq-like syntax, inspect metadata, diff tables or databases, copy data between sources, and emit output formats such as JSON, CSV, Excel, HTML, Markdown, and XML. Source definitions live in `sq.yml`, with optional keyring, environment, file, or 1Password placeholders for secrets.

Why package nerds care

sq is interesting to package-manager users because it compresses a stack of ad hoc data-inspection tools into one portable CLI. It appeals to people who want jq-like interaction but need to cross the boundary between files, SQL engines, spreadsheets, and exports without setting up a full ETL system.

Timeline

  • 2016: GitHub repository created.
  • 2020: v0.14.5 published on GitHub releases.
  • 2026: v0.54.1 published on GitHub releases.

Related projects

  • sq is explicitly inspired by jq and SQL. Its driver set connects it to PostgreSQL, MySQL, SQL Server, SQLite, DuckDB, ClickHouse, Oracle, CSV, JSON, Excel, and other tabular or document sources.

security posture

No protected-tool coverage found yet

No matching local secret-handling manifest was found for sq. Nucleus package metadata is still published here so future coverage has a stable package URL.

Install behavior

  • No Homebrew bottle metadata was recorded.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

local files

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

Config paths the tool may read or write during local use.

Unix
$XDG_CONFIG_HOME/sq/sq.yml~/.config/sq/sq.yml

Credential files

Credential-bearing paths to review before unattended agent runs.

Unix
$XDG_CONFIG_HOME/sq/sq.yml~/.config/sq/sq.yml

executables

Installed executables

CommandKindExposureNote
sqexecutableindexed executableDiscovered from the local executable index.

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-08-03
manager version0.54.1
manager updated2026-07-26
local dataunknown
upstreamnot available
latest detectednot detected
  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:sq
Version0.54.1
Package managerHomebrew
Homepagehttps://sq.io
Repositoryhttps://github.com/neilotoole/sq
Last updated2026-07-26T04:03:44+02:00
Pulseupdated
Bottlenot recorded
Servicenone declared

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Debian apt95%

sq 1.3.1-2+b2

OpenPGP command-line tool from Sequoia

https://sequoia-pgp.org/

sudo apt install sq
  • Section: utils
  • Architecture: amd64
  • Source Package: rust-sequoia-sq
  • 8 dependencies
  • normalized package name match
  • Matched by: Sq
Debian stable package indexes · deb.debian.org · Debian stable package indexes: sq from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Nix95%

sq

nix profile install nixpkgs#sq
  • normalized package name match
  • Matched by: Sq
nixpkgs package indexes · api.github.com · nixpkgs package indexes: pkgs/by-name/sq/sq/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1
Ubuntu apt95%

sq 0.33.0-3

OpenPGP command-line tool from Sequoia

https://sequoia-pgp.org/

sudo apt install sq
  • Section: universe/utils
  • Architecture: amd64
  • Source Package: rust-sequoia-sq
  • 8 dependencies
  • normalized package name match
  • Matched by: Sq
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: sq from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz
apk95%

sq 0.48.11-r5

CLI tool that provides jq-style access to structured data sources

https://sq.io/

sudo apk add sq
  • License: MIT
  • Architecture: x86_64
  • Source Package: sq
  • 1 dependencies
  • 1 provides
  • normalized package name match
  • Matched by: Sq
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: sq from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz
apk95%

sq-bash-completion 0.48.11-r5

Bash completions for sq

https://sq.io/

sudo apk add sq-bash-completion
  • License: MIT
  • Architecture: x86_64
  • Source Package: sq
  • normalized package name match
  • Matched by: Sq
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: sq-bash-completion from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz
apk95%

sq-doc 0.48.11-r5

CLI tool that provides jq-style access to structured data sources (documentation)

https://sq.io/

sudo apk add sq-doc
  • License: MIT
  • Architecture: x86_64
  • Source Package: sq
  • normalized package name match
  • Matched by: Sq
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: sq-doc from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz
apk95%

sq-fish-completion 0.48.11-r5

Fish completions for sq

https://sq.io/

sudo apk add sq-fish-completion
  • License: MIT
  • Architecture: x86_64
  • Source Package: sq
  • normalized package name match
  • Matched by: Sq
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: sq-fish-completion from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz
apk95%

sq-zsh-completion 0.48.11-r5

Zsh completions for sq

https://sq.io/

sudo apk add sq-zsh-completion
  • License: MIT
  • Architecture: x86_64
  • Source Package: sq
  • normalized package name match
  • Matched by: Sq
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: sq-zsh-completion from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz
MacPorts95%

sq

sudo port install sq
  • normalized package name match
  • Matched by: Sq
MacPorts ports tree · api.github.com · MacPorts ports tree: databases/sq/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1
Scoop95%

main/sq

scoop install main/sq
  • normalized package name match
  • Matched by: Sq
Scoop official bucket manifest trees · api.github.com · Scoop official bucket manifest trees: bucket/sq.json from https://api.github.com/repos/ScoopInstaller/Main/git/trees/master?recursive=1

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Combined YAML source

View the package source record on GitHub.

combined/sq.yml

Used sources

  • Geiger risk classifier
  • cross-ecosystem install command graph
  • curated configuration and credential file locations
  • curated package history
  • external package-manager database matches
  • pkg.so package database
  • pkgdb category and tag curation