OctoSQL Share Help Try It

Query tool that joins, analyzes, and transforms data from multiple databases and file formats using SQL

Category

Database

License

MPL-2.0

Platforms

Windows macOS Linux

Released

2019

Path

c:\octosql\octosql.exe

Benefits

Join data across different sources (PostgreSQL, MySQL, CSV, JSON, Parquet) in a single SQL query. Statically typed with query optimization.

Notes

Plugin-based architecture for adding data sources. Written in Go. Supports live table output, batch table, CSV, and streaming output formats.

Try it

• Aggregate the Iris CSV
  Run a GROUP BY query against the selected Iris dataset to compute per-species count and mean sepal/petal dimensions. OctoSQL infers the schema from the file extension (.csv or .tsv) - no import step needed.
• Filter and order Iris rows
  Find the 10 widest sepals across the dataset using a WHERE+ORDER BY+LIMIT query. Demonstrates OctoSQL's standard SQL surface against a flat file.

Agree to terms to run demos.

# OctoSQL - Help

Source: https://octosql.dev/

```
Usage:
  octosql <query> [flags]
  octosql [command]

Examples:
octosql "SELECT * FROM myfile.json"
octosql "SELECT * FROM mydir/myfile.csv"
octosql "SELECT * FROM plugins.plugins"

Available Commands:
  completion  Generate the autocompletion script for the specified shell
  help        Help about any command
  plugin      

Flags:
      --describe         Describe query output schema.
      --explain int      Describe query output schema.
  -h, --help             help for octosql
      --optimize         Whether OctoSQL should optimize the query. (default true)
  -o, --output string    Output format to use. Available options are live_table, batch_table, csv, json and stream_native. (default "live_table")
      --profile string   Enable profiling of the given type: cpu, memory, trace.
  -v, --version          version for octosql

Use "octosql [command] --help" for more information about a command.
```