A MySQL Driver for the SQL CLI package!
Lets you connect to MySQL Servers using the SQL CLI. This can be installed globally (allowing you to use it everywhere) or locally (to be used within a specific package).
$ npm install [-g] sqlclid-mysql
For most use cases, you'll want to install this globally so you can take full advantage of sqlcli anywhere on your computer, however, you can also save it to your dev dependencies to make sure your colleagues are on the same page when inspecting the DB.
$ npm install --save-dev sqlcli-repl sqlclid-mysql
Open a connection using a URI or through args
$ sqlcli mysql://user:pass@localhost:3306/myDB
OR
$ sqlcli -d mysql -u user -p pass -h localhost -b myDB
Find out more help using sqlcli --help
Execute typical SQL queries:
user@localhost> SELECT 1 AS `One`, 2 AS `Two`;
|-----|-----|
| One | Two |
|-----|-----|
| 1 | 2 |
|-----|-----|
Execute multi-line SQL queries:
user@localhost> SELECT
... 3 AS `Three`,
... 4 AS `Four`
... ;
|-------|------|
| Three | Four |
|-------|------|
| 3 | 4 |
|-------|------|
Execute JS on results:
user@localhost> SELECT 1 AS `One`, 2 AS `Two`;sh
user@localhost> >$0
[
{
"One": 1,
"Two": 2
}
]
Find out more info at the SQL CLI repo!
MIT