# dsq を Homebrew, MacPorts, Nix, pacman でインストール

dsq のインストール経路、実行ファイル、メタデータ、AI エージェント向けセキュリティノートを確認します。

## インストール

```sh
sudo av install brew:dsq
```

追加のインストールコマンド:

### macOS

- Homebrew (100%):

```sh
brew install dsq
```

  証拠: local Homebrew formula metadata

- MacPorts (94%):

```sh
sudo port install dsq
```

  証拠: MacPorts ports tree: textproc/dsq/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1

### Linux

- Nix (92%):

```sh
nix profile install nixpkgs#dsq
```

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

- pacman (92%):

```sh
sudo pacman -S dsq
```

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

## パッケージ情報

- **パッケージキー:** brew:dsq
- **パッケージマネージャ:** Homebrew
- **パッケージマネージャページ:** <https://formulae.brew.sh/formula/dsq>
- **バージョン:** 0.23.0
- **ソース概要:** CLI tool for running SQL queries against JSON, CSV, Excel, Parquet, and more
- **ホームページ:** <https://github.com/multiprocessio/dsq>
- **リポジトリ:** <https://github.com/multiprocessio/dsq>
- **ライセンス:** Apache-2.0
- **ソースアーカイブ:** <https://github.com/multiprocessio/dsq/archive/refs/tags/v0.23.0.tar.gz>
- **最終更新:** 2026-07-29T17:01:33+09:00
- **生成日時:** 2026-08-04T22:13:35+00:00

## 実行可能ファイル

- dsq (cli)
- dsq (エイリアス)

## ビルド依存関係

- go

## インストール挙動

- post-install フック: 未定義
- Bottle: 利用可能 対象 arm64_big_sur, arm64_linux, arm64_monterey, arm64_sequoia, arm64_sonoma, arm64_tahoe, arm64_ventura, big_sur, catalina, monterey, sonoma, ventura

## バージョンと鮮度

- ページ生成日: 2026-08-04
- マネージャ版: 0.23.0
- マネージャ更新日: 2026-07-29
- ローカルデータ: OK
- 上流リポジトリ: https://github.com/multiprocessio/dsq
- 検出された最新: v0.23.0 (最新)
## プロジェクトの歴史と使われ方

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.

### プロジェクトの歴史

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.

### 採用の歴史

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.

### 使われ方

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.

### パッケージ好きにとっての重要性

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.

### タイムライン

- 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.

### ソース

- <https://github.com/multiprocessio/dsq#readme>
- <https://github.com/multiprocessio/dsq/releases/tag/0.15.0>
- <https://github.com/multiprocessio/dsq/releases/tag/0.16.0>
- <https://github.com/multiprocessio/dsq/releases/tag/v0.22.0>
- <https://github.com/multiprocessio/dsq/releases/tag/v0.23.0>
- <https://formulae.brew.sh/formula/dsq>


## セキュリティノート

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

- **Geiger リスク:** blue / 中
- broad file, network, media, or database tool signal

## ソースデータベース詳細

- **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

## 他のパッケージマネージャ記録

- Nix - dsq: normalized package name match | nixpkgs package indexes: pkgs/by-name/ds/dsq/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1
- pacman - dsq - 0.23.0-3: normalized package name match | Arch Linux sync databases: dsq from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz | CLI tool for running SQL queries against JSON/CSV/Excel/Parquet and more | https://github.com/multiprocessio/dsq
- MacPorts - dsq: normalized package name match | MacPorts ports tree: textproc/dsq/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1


## 関連リンク

- [Source-control packages](https://pkg.so/ja/source-control-tools/) - Belongs to a source-control command family.
- [Secret-risk packages](https://pkg.so/ja/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals.
- [Terminal utility packages](https://pkg.so/ja/terminal-utilities/) - Matched terminal and command-line workflow metadata.
- [Text processing packages](https://pkg.so/ja/text-processing-tools/) - Matched text, document, or structured-data processing metadata.
- [go](https://pkg.so/ja/brew/go/) - Build dependency declared by Homebrew.
- [qo](https://pkg.so/ja/brew/qo/) - Shares pkgdb curated category or tags: cli, csv, data, json, query-tools.
- [octosql](https://pkg.so/ja/brew/octosql/) - Shares pkgdb curated category or tags: cli, data, query-tools, sql.
- [qp](https://pkg.so/ja/brew/qp/) - Shares pkgdb curated category or tags: cli, data, json, query-tools.
- [miller](https://pkg.so/ja/brew/miller/) - Shares pkgdb curated category or tags: cli, csv, data, json.
- [tidy-viewer](https://pkg.so/ja/brew/tidy-viewer/) - Shares pkgdb curated category or tags: cli, csv, data, parquet.
- [csvq](https://pkg.so/ja/brew/csvq/) - Shares pkgdb curated category or tags: cli, csv, data, sql.
- [cqlkit](https://pkg.so/ja/brew/cqlkit/) - Shares pkgdb curated category or tags: cli, csv, data, json.
- [sqlite](https://pkg.so/ja/brew/sqlite/) - Shares pkgdb curated category or tags: cli, data, sql.

## Combined YAML source

View the package source record on GitHub. [combined/dsq.yml](https://github.com/mxcl/pkgdb/blob/main/combined/dsq.yml)


## ソース

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