# octosql を Homebrew, MacPorts, Nix, scoop でインストール 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 - **ホームページ:** - **リポジトリ:** - **上流ドキュメント:** - **ライセンス:** MPL-2.0 - **ソースアーカイブ:** - **最終更新:** 2026-07-27T23:46:50+02:00 - **生成日時:** 2026-08-04T22:13:35+00:00 ## 実行可能ファイル - octosql (cli) - octosql (エイリアス) ## ビルド依存関係 - go ## インストール挙動 - post-install フック: 未定義 - Bottle: 利用可能 対象 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## バージョンと鮮度 - ページ生成日: 2026-08-04 - マネージャ版: 0.13.0 - マネージャ更新日: 2026-07-27 - ローカルデータ: OK - 上流リポジトリ: https://github.com/cube2222/octosql - 検出された最新: v0.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. ### ソース - - - - - ## セキュリティノート broad file, network, media, or database tool signal. - **Geiger リスク:** blue / 中 - broad file, network, media, or database tool signal ## ソースデータベース詳細 - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** octosql - **Version Scheme:** 0 - **Revision:** 0 - **Head Version:** HEAD - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** head, stable ## 他のパッケージマネージャ記録 - 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 ## 関連リンク - [Source-control packages](https://pkg.so/ja/source-control-tools/) - Belongs to a source-control command family. - [Secret-risk packages](https://pkg.so/ja/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals. - [Terminal utility packages](https://pkg.so/ja/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://pkg.so/ja/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [go](https://pkg.so/ja/brew/go/) - Build dependency declared by Homebrew. - [qo](https://pkg.so/ja/brew/qo/) - Shares pkgdb curated category or tags: cli, data, query-tools, sql. - [dsq](https://pkg.so/ja/brew/dsq/) - Shares pkgdb curated category or tags: cli, data, query-tools, sql. - [qp](https://pkg.so/ja/brew/qp/) - Shares pkgdb curated category or tags: cli, data, query-tools. - [sqlite](https://pkg.so/ja/brew/sqlite/) - Shares pkgdb curated category or tags: cli, data, sql. - [mysql](https://pkg.so/ja/brew/mysql/) - Shares pkgdb curated category or tags: cli, data, sql. - [postgresql@14](https://pkg.so/ja/brew/postgresql-14/) - Shares pkgdb curated category or tags: cli, data, sql. - [postgresql@16](https://pkg.so/ja/brew/postgresql-16/) - Shares pkgdb curated category or tags: cli, data, sql. - [postgresql@17](https://pkg.so/ja/brew/postgresql-17/) - Shares pkgdb curated category or tags: cli, data, sql. - [libesedb](https://pkg.so/ja/brew/libesedb/) - Local package facts share a topical domain. Shared terms: cli, data, databases, file, file-formats. ## 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 - package-page enrichment - curated package history - package version freshness - pkgdb category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph