# cube2222/octosql

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

Repository: https://github.com/cube2222/octosql
Canonical: https://ross.abutalabs.com/products/octosql
Language: Go
License: MPL-2.0
License Family: copyleft
Topics: go, cli, sql, query, query-engine, nosql, mysql, postgresql, redis, json, csv, data-analysis, golang
Last push: 2024-05-26T15:16:53+00:00

## Health v2 (maintenance only)
Score: 23/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 2740, "days_push": 829, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 5264, forks 213 (observed 2026-08-28T04:09:13.864262+00:00)

## What it is
OctoSQL is a Go CLI tool that lets you query, join, and transform data from multiple databases and file formats using SQL through a unified interface. It is also an extensible dataflow engine that can be embedded to add a SQL interface to your own applications.

## Use cases
- join a  file with a postgresql table using sql
- query csv and  files from the command line
- run sql across multiple heterogeneous databases
- analyze and aggregate data from files with sql
- inspect schemas of files and databases
- add a sql interface to a go application

## When to choose
- you need to join or combine data across different databases and file formats
- you want a lightweight CLI for ad-hoc SQL analysis without a full data warehouse
- you need a pluggable SQL engine to embed in your own tooling

## When to avoid
- you need a full-featured distributed query engine for large-scale production analytics
- you want a GUI-based data exploration tool
- you need streaming or real-time data processing at scale

## Facets
- artifact type: cli-tool
- maturity: maintenance
- function: database, database-driver, etl, data-science, cli
- domain: databases, developer-tools, analytics
- platform: cli, cross-platform, go
- tags: sql, query-engine, dataflow, join, file-formats, plugins, nosql, data-analysis, data-engineering, command-line

## Member repositories
- cube2222/octosql (main) score 23

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:13.864262+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:59:30.248590+00:00, confidence not recorded.
  - readme: https://github.com/cube2222/octosql (fetched 2026-08-28T04:09:13.864262+00:00, sha 02e7b153e22b)
- Data as of 2026-08-30T08:39:29.467469+00:00.