CmdID

CmdID / Commands

trdsql

Execute SQL on CSV, LTSV, JSON, YAML, and TBLN files. tldr-pages

On several platforms

Opens CmdID with your command. It is read in your browser and sent nowhere.

Several platforms

from tldr-pages, CC BY 4.0

Convert object data from multiple JSON files to a CSV file with header (-oh) and double quote

trdsql -ocsv -oh "SELECT * FROM path/to/directory/*.json" | sed 's/\([^,]*\)/"&"/g' >path/to/file.csvIdentify

Interpret JSON list as a table and put objects inside as columns (path/to/file.json: {"list":[{"age":"26","name":"Tanaka"}]})

trdsql "SELECT * FROM path/to/file.json::.list"Identify

Manipulate complex SQL query with data from multiple CSV files with first line is header (-ih)

trdsql -icsv -ih "SELECT column1,column2 FROM path/to/file*.csv WHERE column2 != '' ORDER BY column1 GROUP BY column1"Identify

Merge content of 2 CSV files to one CSV file

trdsql "SELECT column1,column2 FROM path/to/file1.csv UNION SELECT column1,column2 FROM path/to/file2.csv"Identify

Connect to PostgreSQL database

trdsql -driver postgres -dsn "host=hostname port=5433 dbname=database_name" "SELECT 1"Identify

Create table data to MySQL database from CSV file

trdsql -driver mysql -dsn "username:password@hostname/database" -ih "CREATE TABLE table (column1 int, column2 varchar(20)) AS SELECT column3 AS column1,column2 FROM path/to/header_file.csv"Identify

Show data from compress log files

trdsql -iltsv "SELECT * FROM path/to/access.log.gz"Identify