Command-line tool

trdsql

brew/trdsql

Checked 25 Oct 2026, 21:09 UTC · Listing refreshed from Homebrew, winget, npm, Scoop and cargo; npm packages checked against OSV.dev

CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN

Website Source

At a glance

Type

Command-line tool

Install on

Windows, macOS, Linux

Last checked

25 Oct 2026, 21:09 UTC

Install it

Windows

scoop install trdsql

macOS

brew install trdsql

Linux

brew install trdsql

Convert object data from multiple JSON files to a CSV file with header (`-oh`) and double quote

trdsql -ocsv -oh "SELECT * FROM path/to/directory/*.json" | sed 's/\([^,]*\)/"&"/g' > path/to/file.csv

Interpret JSON list as a table and put objects inside as columns (`path/to/file.json: {"list":[{"age":"26","name":"Tanaka"}]}`)

trdsql "SELECT * FROM path/to/file.json::.list"

Manipulate complex SQL query with data from multiple CSV files with first line is header (`-ih`)

trdsql -icsv -ih "SELECT column1,column2 FROM path/to/file*.csv WHERE column2 != '' ORDER BY column1 GROUP BY column1"

Browse

• Spreadsheets
• Databases

Related command-line tools

• dasel
  JSON, YAML, TOML, XML, and CSV query and modification tool
• jsongrep
  Query tool for JSON, YAML, TOML, and other structured formats rust cli search json yaml command-line grep…
• dhall-json
  Dhall to JSON compiler and a Dhall to YAML compiler
• json2yaml
  A commandline utility to convert JSON to YAML / YML yml yaml json cli util
• dyff
  Diff tool for YAML files, and sometimes JSON
• yaml2json
  Command-line tool convert from YAML to JSON
• template-cli
  CLI for templating based on JSON, YAML or HCL configuration
• ferrite
  A fast, lightweight text editor for Markdown, JSON, YAML, and TOML files.

Listing text is written by the maker; AptLynx lists tools and does not vouch for them. Find another tool · Browse by topic · For agents