macOS
Homebrew已验证 · 100%
brew install octosqllocal Homebrew formula metadata
MacPorts已验证 · 94%
sudo port install octosqlMacPorts ports tree · databases/octosql/Portfile · 来源: api.github.com
安装
其他安装命令
Linux
Nix已验证 · 92%
nix profile install nixpkgs#octosqlnixpkgs package indexes · pkgs/by-name/oc/octosql/package.nix · 来源: api.github.com
Windows
Scoop已验证 · 92%
scoop install main/octosqlScoop official bucket manifest trees · bucket/octosql.json · 来源: api.github.com
概览
软件包摘要
SQL query tool to analyze data from different file formats and databases
历史
项目历史与用法
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.
来源
安全态势
风险级别：blue
broad file, network, media, or database tool signal.
风险分类器
blue 风险 · 中 置信度 · tool
原因
- broad file, network, media, or database tool signal
信号
- text:database,sql
安装行为
- 未记录 Homebrew bottle 元数据。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
octosql | 可执行文件 | 已索引可执行文件 | 从本地可执行文件索引发现。 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-08-03
管理器版本0.13.0
管理器更新时间2026-07-27
本地数据未知
上游不可用
检测到的最新版本未检测到
- OK没有生成新鲜度警告。
安装元数据
软件包元数据
| 软件包键 | brew:octosql |
|---|---|
| 版本 | 0.13.0 |
| 软件包管理器 | Homebrew |
| 主页 | https://github.com/cube2222/octosql/ |
| 仓库 | https://github.com/cube2222/octosql |
| 最后更新 | 2026-07-27T23:46:50+02:00 |
| Pulse | updated |
| Bottle | 未记录 |
| 服务 | 未声明 |
源数据库匹配
其他软件包管理器记录
匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。
Nix95%
octosql
nix profile install nixpkgs#octosql- normalized package name match
- 匹配方式：Octosql
MacPorts95%
octosql
sudo port install octosql- normalized package name match
- 匹配方式：Octosql
Scoop95%
main/octosql
scoop install main/octosql- normalized package name match
- 匹配方式：Octosql
来源线索
由仓库数据生成
此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。
Combined YAML source
View the package source record on GitHub.
使用的来源
- Geiger risk classifier
- cross-ecosystem install command graph
- curated package history
- external package-manager database matches
- pkg.so package database
- pkgdb category and tag curation