SqlPlay

Run SQL queries against CSV or JSON files. No database needed.

Install

npm install -g @arc2898/sqlplay

Usage

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-headers

Examples

# 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.csv

Notes

• 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