macOS
Homebrewverified · 100%
brew install octosqllocal Homebrew formula metadata
MacPortsverified · 94%
sudo port install octosqlMacPorts ports tree · databases/octosql/Portfile · source: api.github.com
brew
Install octosql with Homebrew, MacPorts, Nix, scoop
SQL query tool to analyze data from different file formats and databases. Version 0.13.0 via Homebrew; verified from local package data.
install
Additional install commands
Linux
Nixverified · 92%
nix profile install nixpkgs#octosqlnixpkgs package indexes · pkgs/by-name/oc/octosql/package.nix · source: api.github.com
Windows
Scoopverified · 92%
scoop install main/octosqlScoop official bucket manifest trees · bucket/octosql.json · source: api.github.com
overview
Package summary
SQL query tool to analyze data from different file formats and databases
Project links
Commands and aliases
- octosql
history
Project history and usage
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.
Project history
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.
Adoption history
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.
How it is used
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.
Why package nerds care
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.
Timeline
- 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.
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:database,sql
Install behavior
- No Homebrew post-install hook is recorded in formula metadata.
- Homebrew bottle metadata is available for 6 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 |
|---|---|---|---|
octosql | 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.13.0
manager updated
local dataok
upstreamcurrent
latest detectedv0.13.0
https://github.com/cube2222/octosql
- infoNo package-manager update timestamp was available.low confidence
install metadata
Package metadata
| Package key | brew:octosql |
|---|---|
| Version | 0.13.0 |
| Package manager | Homebrew |
| Package manager page | https://formulae.brew.sh/formula/octosql |
| Homepage | https://github.com/cube2222/octosql/ |
| Repository | https://github.com/cube2222/octosql |
| Upstream docs | https://github.com/cube2222/octosql#readme |
| License | MPL-2.0 |
| Source archive | https://github.com/cube2222/octosql/archive/refs/tags/v0.13.0.tar.gz |
| Build dependencies | go |
| Bottle | available (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, 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 | 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 |
|
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%
octosql
nix profile install nixpkgs#octosql- normalized package name match
- Matched by: Octosql
MacPorts95%
octosql
sudo port install octosql- normalized package name match
- Matched by: Octosql
Scoop95%
main/octosql
scoop install main/octosql- normalized package name match
- Matched by: Octosql
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.
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