pkg.soopen package index

brew / rank 9415

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 2026-07-27. Also installable with nix: nix profile install nixpkgs#octosql.

Install commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install octosql

local Homebrew formula metadata

MacPortsverified · 94%
sudo port install octosql

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

Linux

Nixverified · 92%
nix profile install nixpkgs#octosql

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

Windows

Scoopverified · 92%
scoop install main/octosql

Scoop 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

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.

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 bottle metadata was recorded.

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

CommandKindExposureNote
octosqlexecutableindexed executableDiscovered from the local executable index.

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-08-03
manager version0.13.0
manager updated2026-07-27
local dataunknown
upstreamnot available
latest detectednot detected
  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:octosql
Version0.13.0
Package managerHomebrew
Homepagehttps://github.com/cube2222/octosql/
Repositoryhttps://github.com/cube2222/octosql
Last updated2026-07-27T23:46:50+02:00
Pulseupdated
Bottlenot recorded
Servicenone declared

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
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
  • Matched by: 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
  • Matched by: 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

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

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.

Used sources

  • 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