octosql ☆
« Back to VersTracker
Description:
SQL query tool to analyze data from different file formats and databases
Type: Formula  |  Latest Version: 0.13.0@0  |  Tracked Since: Dec 26, 2025
Links: Homepage  |  GitHub  |  formulae.brew.sh
Stars: 5,212  |  Forks: 214  |  Language: Go  |  Category: Databases
Tags: sql data-analysis cli database go
Install: brew install octosql
About:
OctoSQL is a command-line tool that allows you to query data across multiple sources—including JSON, CSV, Parquet, and databases like PostgreSQL and MySQL—using standard SQL. It unifies disparate data formats into a single, queryable virtual table, eliminating the need for complex ETL pipelines. Its primary value is enabling fast, ad-hoc analysis of heterogeneous data directly from the terminal.
Key Features:
  • Unified SQL queries across multiple file formats and databases
  • Real-time data streaming and incremental query execution
  • No external server required—runs as a standalone CLI tool
  • Supports joins and aggregations across different data sources
  • Extensible plugin architecture for adding new data sources
Use Cases:
  • Ad-hoc analysis of log files (CSV/JSON) combined with database metrics
  • Data exploration and transformation across siloed data formats without pre-processing
  • Creating unified reports from multiple databases and local data files
Alternatives:
  • q – Text-based SQL query tool for CSV/TSV only, lacks multi-source joins
  • duckdb – Embedded analytical SQL database, often used in-process for file analysis, broader SQL support
Version History
Detected Version Rev Change Commit
Dec 26, 2025 7:51pm 0.13.0 0 VERSION_BUMP c5a98cfa
Oct 10, 2025 4:07pm 0 VERSION_BUMP 0337792f
Sep 16, 2025 8:35am 0 VERSION_BUMP 93dfd27c
Sep 11, 2024 7:59am 0 VERSION_BUMP e643f9b2
Nov 25, 2022 7:46pm 0 VERSION_BUMP a771fcea
« Back to VersTracker  |  Browse Packages  |  About