安装

其他安装命令

macOS

Homebrew已验证 · 100%

brew install octosql

local Homebrew formula metadata

MacPorts已验证 · 94%

sudo port install octosql

MacPorts ports tree · databases/octosql/Portfile · 来源: api.github.com

Linux

Nix已验证 · 92%

nix profile install nixpkgs#octosql

nixpkgs package indexes · pkgs/by-name/oc/octosql/package.nix · 来源: api.github.com

Windows

Scoop已验证 · 92%

scoop install main/octosql

Scoop official bucket manifest trees · bucket/octosql.json · 来源: api.github.com

概览

软件包摘要

SQL query tool to analyze data from different file formats and databases

项目链接

命令和别名

octosql

历史

项目历史与用法

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

安装行为

formula 元数据中未记录 Homebrew post-install 钩子。
Homebrew bottle 元数据适用于 6 个平台目标。
构建元数据列出 1 个构建依赖。

建议审查

在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。

可执行文件

已安装的可执行文件

命令	类型	暴露范围	备注
`octosql`	cli	全局可执行文件

新鲜度

版本和新鲜度

这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。

页面生成时间2026-07-25

管理器版本0.13.0

管理器更新时间

本地数据OK

上游当前

检测到的最新版本v0.13.0

https://github.com/cube2222/octosql

信息No package-manager update timestamp was available.低置信度

安装元数据

软件包元数据

软件包键	brew:octosql
版本	0.13.0
软件包管理器	Homebrew
软件包管理器页面	https://formulae.brew.sh/formula/octosql
主页	https://github.com/cube2222/octosql/
仓库	https://github.com/cube2222/octosql
上游文档	https://github.com/cube2222/octosql#readme
许可证	MPL-2.0
源码归档	https://github.com/cube2222/octosql/archive/refs/tags/v0.13.0.tar.gz
构建依赖	go
Bottle	可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-install	未定义
服务	未声明

注册表事实

源数据库详情

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	octosql
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

源数据库匹配

其他软件包管理器记录

匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。

Nix95%

octosql

nix profile install nixpkgs#octosql

normalized package name match
匹配方式：Octosql

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

MacPorts95%

octosql

sudo port install octosql

normalized package name match
匹配方式：Octosql

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

Scoop95%

main/octosql

scoop install main/octosql

normalized package name match
匹配方式：Octosql

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

软件包图谱

链接来自本地软件包关系图、补充数据、依赖边、生态匹配和软件包 hub 归属。

来源线索

由仓库数据生成

此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。

Combined YAML source

View the package source record on GitHub.

combined/octosql.yml

使用的来源

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

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