1

pip install csvkit mycli

1
2
3

 $ mycli -P 3306 -proot mysql
MySQL root@localhost:mysql> \T csv
MySQL root@localhost:mysql> pager csvjson | jq '.'

1

mycli -P 3306 -proot mysql --csv -e "select * from user;" | csvjson | jq .