@keyrier/cli

Keyrier JSON CLI

A tool to execute SQL queries on JSON or CSV.

Install

npm i -g @keyrier/cli

Run

keyrier <SQL-like query>

Examples

# basic query
keyrier "select * from users.json"

# For a CSV file
keyrier "select firstname, lastname, phoneNumber as phone from users.csv"

# input is JSON output CSV
keyrier "select name from users.json where age < 30"  --output youngins.csv -t csv

# read from STDIN
wget -qO- https://jsonplaceholder.typicode.com/users | keyrier "select name as Nom, address.city as Ville from stdin"

Options

--help              display help
--output, -o        output file path (default: stdout)
--output-type, -t   output content type: json or csv (default: json)
--verbose, -v       verbose
--version           print version