@arc2898/sqlplay
v1.0.1
Published
Run SQL queries against CSV or JSON files. No database needed.
Readme
SqlPlay
Run SQL queries against CSV or JSON files. No database needed.
Install
npm install -g @arc2898/sqlplayUsage
sqlplay "SELECT * FROM data WHERE age > 30" --files users.csv
sqlplay "SELECT name, COUNT(*) FROM data GROUP BY name" --files logs.json
sqlplay "SELECT * FROM t1 JOIN t2 ON t1.id = t2.id" --files file1.csv file2.csv
sqlplay "SELECT * FROM data" --files data.json --csv --no-headersExamples
# Query a CSV file
sqlplay "SELECT name, email FROM users WHERE active = 1" --files users.csv
# Query a JSON file (array of objects)
sqlplay "SELECT SUM(amount) FROM transactions" --files data.json
# Multiple files (become t1, t2, ...)
sqlplay "SELECT * FROM t1 INNER JOIN t2 ON t1.user_id = t2.id" --files users.csv orders.csvNotes
- CSV files: first row is treated as headers
- JSON files: expects an array of objects
- Default table name is
data, change with--table
License
MIT
