# 使用 Homebrew, MacPorts, Nix, scoop 安装 octosql

查看 octosql 的安装路径、可执行文件、元数据以及面向 AI 代理工作流的安全说明。

## 安装

```sh
sudo av install brew:octosql
```

其他安装命令:

### macOS

- Homebrew (100%):

```sh
brew install octosql
```

  证据: local Homebrew formula metadata

- MacPorts (94%):

```sh
sudo port install octosql
```

  证据: MacPorts ports tree: databases/octosql/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1

### Linux

- Nix (92%):

```sh
nix profile install nixpkgs#octosql
```

  证据: nixpkgs package indexes: pkgs/by-name/oc/octosql/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1

### Windows

- Scoop (92%):

```sh
scoop install main/octosql
```

  证据: Scoop official bucket manifest trees: bucket/octosql.json from https://api.github.com/repos/ScoopInstaller/Main/git/trees/master?recursive=1

## 软件包事实

- **软件包键:** brew:octosql
- **软件包管理器:** Homebrew
- **版本:** 0.13.0
- **来源摘要:** SQL query tool to analyze data from different file formats and databases
- **主页:** <https://github.com/cube2222/octosql/>
- **仓库:** <https://github.com/cube2222/octosql>
- **最后更新:** 2026-07-27T23:46:50+02:00
- **已生成:** 2026-08-03T19:37:03+00:00

## 可执行文件

- octosql (别名)

## 安装行为

- Bottle: 不可用

## 版本和新鲜度

- 页面生成时间: 2026-08-03
- 管理器版本: 0.13.0
## 项目历史与用法

OctoSQL is a Go CLI query engine that lets users run SQL across files and databases through one interface. Its hook is practical and package-index friendly: JSON, CSV, TSV, Parquet, stdin streams, and database plugins can all become SQL tables.

### 项目历史

The public repository was created on 2019-03-03. The README describes OctoSQL as both a CLI for joining, analyzing, and transforming data from multiple file formats and databases, and as an extensible dataflow engine that applications can embed for SQL access.

### 采用历史

OctoSQL gained enough distribution footprint to appear in Homebrew, MacPorts, Nix, and Scoop package metadata. The GitHub API metadata recorded Go as the primary language and repository topics including sql, query-engine, data-analysis, csv, json, postgresql, mysql, and redis.

### 使用方式

Users run commands such as octosql "SELECT * FROM ./myfile.json" or join local files with configured databases. Built-in file support covers JSONLines, CSV, TSV, Parquet, line-oriented text, and stdin tables; additional database support is installed through OctoSQL plugins and configured in octosql.yml.

### 为什么软件包爱好者会关心

OctoSQL sits in the useful CLI niche between shell text tools, SQLite/DuckDB-style local querying, and heavier federated query engines. It is significant as a packaged single-purpose developer tool: install one binary, point it at heterogeneous data, and use SQL instead of format-specific scripts.

### 时间线

- 2019-03-03: public GitHub repository created.
- 2026-07-01: Homebrew formula metadata listed stable version 0.13.0 and binary bottles for macOS and Linux variants.

### Related projects

- Comparable tools in the same package-nerd neighborhood include DuckDB's CLI for local analytical SQL and other command-line query tools for files, but OctoSQL's plugin tables and database/file joins give it a federated-query flavor.

### 来源

- <https://api.github.com/repos/cube2222/octosql>
- <https://formulae.brew.sh/api/formula/octosql.json>
- <https://formulae.brew.sh/formula/octosql>
- <https://github.com/cube2222/octosql>
- <https://raw.githubusercontent.com/cube2222/octosql/master/README.md>


## 安全说明

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

- **Geiger 风险:** blue / 中
- broad file, network, media, or database tool signal

## 其他软件包管理器记录

- Nix - octosql: normalized package name match | nixpkgs package indexes: pkgs/by-name/oc/octosql/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1
- MacPorts - octosql: normalized package name match | MacPorts ports tree: databases/octosql/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1
- Scoop - main/octosql: normalized package name match | Scoop official bucket manifest trees: bucket/octosql.json from https://api.github.com/repos/ScoopInstaller/Main/git/trees/master?recursive=1


## Combined YAML source

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


## 来源

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