dsq

Run SQL queries directly on JSON, CSV, Excel, and Parquet files

brewmacoslinux

Try with needOr install directly

About

CLI tool for running SQL queries against JSON, CSV, Excel, Parquet, and more

dsq

query JSON file with SQL$ dsq data.json "SELECT * FROM data WHERE age > 30"

read CSV and filter rows$ dsq employees.csv "SELECT name, salary FROM employees WHERE department='engineering'"

convert Excel spreadsheet to JSON$ dsq data.xlsx "SELECT * FROM Sheet1" -o json

join data from multiple files

$ dsq users.json orders.json "SELECT u.name, COUNT(o.id) FROM users u LEFT JOIN orders o ON u.id=o.user_id GROUP BY u.id"

query Parquet file and export results$ dsq analytics.parquet "SELECT date, SUM(revenue) as total FROM analytics GROUP BY date" -o csv