Tools
sq
neilotoole/sq
sq is a command-line data wrangler that gives jq-style query access to SQL databases, CSV, Excel, and JSON. It can join across sources and export results in many formats.
Topics
Related projects
trdsql2.2ktrdsql is a command-line tool that runs SQL queries directly against CSV, LTSV, JSON, YAML and TBLN files. It supports multiple input and output formats plus PostgreSQL and MySQL syntax.
sqlitebiter879A CLI converter that ingests CSV, Excel, JSON, HTML, and Google Sheets into a SQLite database file.
visidata9.5kVisiData is a terminal multitool for exploring and arranging tabular data, opening CSV, SQLite, JSON, Excel and many other formats for interactive analysis.
jid7.2kAn interactive JSON drill-down tool with tab completion, dot-path navigation, and JMESPath expressions that highlights matching keys in real time.
mergestat-lite3.5kmergestat-lite is a command-line tool that lets you run SQL queries against Git repositories and related data sources, making it easy to generate reports, run status checks, and analyze codebases.
yj1.1kyj converts between YAML, TOML, JSON, and HCL from the command line while preserving map order. It can also be imported as a Go package for normalizing structured data.