install

Additional install commands

macOS

Homebrewverified · 100%

brew install dsq

local Homebrew formula metadata

MacPortsverified · 94%

sudo port install dsq

MacPorts ports tree · textproc/dsq/Portfile · source: api.github.com

Linux

Nixverified · 92%

nix profile install nixpkgs#dsq

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

Arch Linux pacmanverified · 92%

sudo pacman -S dsq

Arch Linux sync databases · dsq · source: geo.mirror.pkgbuild.com

overview

Package summary

CLI tool for running SQL queries against JSON, CSV, Excel, Parquet, and more

Project links

Commands and aliases

dsq

history

Project history and usage

dsq is a Go command-line tool for running SQL queries over data files such as JSON, CSV, Excel, Parquet, TSV, and logs. Upstream now labels it not under active development and points users toward DuckDB, ClickHouse-local, and GlareDB-style analytics foundations.

Project history

The README presents dsq as a CLI companion to DataStation, the Multiprocess Labs GUI for querying data files. Its implementation approach is SQLite-centered, which made it convenient and portable for mixed local files but eventually less attractive than columnar/vectorized analytics engines.

The release history moved quickly through 2022: 0.15 added query-file and cache flags, 0.16 added an interactive REPL, 0.22 added logfmt support, and v0.23.0 fixed nested JSON handling. The README later opened with a not-under-active-development notice and recommended DuckDB, ClickHouse-local, and GlareDB instead.

Adoption history

dsq's adoption came from the CLI data-wrangling crowd: people who wanted `jq`-adjacent convenience but preferred SQL over local structured files. It shipped Homebrew installation instructions in the README and has also appeared in MacPorts, Nix, and Arch packages.

Homebrew analytics showed 159 installs over the preceding 365 days during this batch, consistent with a useful but superseded utility.

How it is used

Typical use is `dsq file.json 'SELECT ... FROM {}'`, piping data with `-s`, joining multiple files as numbered tables, pretty-printing results, dumping inferred schema, caching imported data, or using the interactive REPL added in the 0.16 line.

Why package nerds care

dsq is package-nerd significant because it marks a short transitional moment in local data tools: single-binary SQL over arbitrary files before DuckDB became the obvious answer for many of the same workflows. Its own README now documents that transition by pointing users away from dsq toward stronger analytics engines.

Timeline

2022-04-20: 0.15.0 added query-file and cache support.
2022-04-26: 0.16.0 added a basic interactive REPL.
2022-08-26: v0.22.0 added logfmt support.
2022-10-20: v0.23.0 fixed nested JSON query handling and is the Homebrew stable version recorded for this batch.
Later README state: Upstream marked the project not under active development and recommended DuckDB, ClickHouse-local, and GlareDB.

Related projects

DataStation is the GUI companion project named by the README.
DuckDB, ClickHouse-local, and GlareDB are the README's recommended successors or alternatives.
SQLite is the underlying style of engine the README contrasts with newer columnar/vectorized systems.
jq is a common neighboring CLI in local JSON/data-wrangling workflows.

Sources

security posture

Risk level: blue

broad file, network, media, or database tool signal.

Risk classifier

blue risk · medium confidence · tool

Why

broad file, network, media, or database tool signal

Signals

text:sql

Install behavior

No Homebrew post-install hook is recorded in formula metadata.
Homebrew bottle metadata is available for 13 platform targets.
Build metadata lists 1 build dependencies.

Recommended review

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

executables

Installed executables

Command	Kind	Exposure	Note
`dsq`	cli	global executable

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-07-08

manager version0.23.0

manager updated

local dataok

upstreamcurrent

latest detectedv0.23.0

https://github.com/multiprocessio/dsq

infoNo package-manager update timestamp was available.low confidence

install metadata

Package metadata

Package key	brew:dsq
Version	0.23.0
Package manager	Homebrew
Package manager page	https://formulae.brew.sh/formula/dsq
Homepage	https://github.com/multiprocessio/dsq
Repository	https://github.com/multiprocessio/dsq
Upstream docs	https://github.com/multiprocessio/dsq#readme
License	Apache-2.0
Source archive	https://github.com/multiprocessio/dsq/archive/refs/tags/v0.23.0.tar.gz
Build dependencies	go
Bottle	available (on arm64_big_sur, arm64_linux, arm64_monterey, arm64_sequoia, arm64_sonoma, arm64_tahoe, arm64_ventura, big_sur, catalina, monterey, sonoma, ventura, x86_64_linux)
Homebrew post-install	not defined
Service	none declared

registry facts

Source database details

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	dsq
Version Scheme	0
Revision	0
Head Version	HEAD
Bottle Stable Root URL	https://ghcr.io/v2/homebrew/core
Deprecated	no
Disabled	no
Keg Only	no
URL Keys	head stable

source database matches

Other package-manager records

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

Nix95%

dsq

nix profile install nixpkgs#dsq

normalized package name match
Matched by: Dsq

nixpkgs package indexes · api.github.com · nixpkgs package indexes: pkgs/by-name/ds/dsq/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1

pacman95%

dsq 0.23.0-3

CLI tool for running SQL queries against JSON/CSV/Excel/Parquet and more

https://github.com/multiprocessio/dsq

sudo pacman -S dsq

License: Apache-2.0
Architecture: x86_64
1 dependencies
normalized package name match
Matched by: Dsq

Arch Linux sync databases · geo.mirror.pkgbuild.com · Arch Linux sync databases: dsq from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz

MacPorts95%

dsq

sudo port install dsq

normalized package name match
Matched by: Dsq

MacPorts ports tree · api.github.com · MacPorts ports tree: textproc/dsq/Portfile from https://api.github.com/repos/macports/macports-ports/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/dsq.yml

Used sources

Geiger risk classifier
Nucleus package database
av.db category and tag curation
cross-ecosystem install command graph
curated package history
external package-manager database matches
package relationship graph
package version freshness
package-page enrichment

Install dsq with Homebrew, MacPorts, Nix, pacman