sql-cli-repl

Node MySQL CLI

A NodeJS-based MySQL CLI client which is just what you need when you don't want to install MySQL locally.

This package lets you connect to a MySQL server and execute queries. Query results are stored in a JS VM context which you're then able to manipulate.

Install

$ npm install -g mysqlcli

This package is intended to be installed globally as it acts as an alias for the official mysqlcli program, but if you find it conflicting, it might be worthwhile to install it locally as a devDependency.

$ npm install --save-dev mysqlcli

Usage

Open a connection using a URI or through args

$ mysqlcli mysql://user:pass@localhost:3306/myDB
OR
$ mysqlcli -u user -p pass -h localhost -db myDB

Find out more help using mysqlcli -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`
... ;

Interact with the app/cli

user@localhost> /prompt sql
sql> /clear
sql> /prompt $reset
user@localhost> 

Execute JS on results

user@localhost> SELECT 1 AS `One`, 2 AS `Two`;
user@localhost> >$0

Commands

There are three (point one) types of commands that this CLI can recognise:

• ...; - Normal SQL Commands
  • ...;sh - Normal SQL Commands with output suppression
• /... - App Commands
• >... - Javascript Commands/Instructions

SQL Commands

All SQL commands are piped directly to the SQL server taht you connect to. This means that any command that you can run on an SQL server is a viable option here.

All SQL commands must terminate with a ;, just like how you would when executing SQL commands in a script file. The only exception to this is when you want to suppress output.

Example:

user@localhost> SELECT 1 AS `One`, 2 AS `Two`;
|-----|-----|
| One | Two |
|-----|-----|
|   1 |   2 |
|-----|-----|
user@localhost> 

SQL Commands Suppressed

Terminating an SQL command with ;sh (remember 🤫) will suppess the output. Everything else about the way this command works is identical to a normal SQL command.

Example:

user@localhost> SELECT 1 AS `One`, 2 AS `Two`;sh
user@localhost> 

App Commands

App commands allow you to interact directly with the application, such as modifying the prompt or clearing the screen, but it also lets you modify settings. These commands start with a / to denote that the following instructions should be handled by the application.

All available commands:

• /clear - Clears the screen
• /prompt [...p] - Sets the prompt to your passed value p (automatically adds the > )
  • /prompt - Ommitting p will display the current prompt value
  • There are a number of $ values that can be used as p:
    • $reset - If passed by itself, this will reset the prompt to the default value ($user@$host)
    • $[config] - Inserts the config option (user, host, pass, port, db, etc...)
• /set <setting> [...opts] - Sets or shows the settings of the application. The following settings are available:
  • /set raw [opt] [val]
    • Without val shows either the whole raw mode setting or the specific raw mode setting. With val it sets the setting.
    • opt can be either mode or active
    • More help can be found by calling !help
• TO BE ADDED
• /save [opt] Saves data about the session to the PWD
  • /save session Saves only the commands and results called
  • /save settings Saves the current settings of the application
  • /save all Saves the entire session (commands and settings)

JS Commands

JS commands/instructions allow you to interact with the results of a query, such as getting the JSON of a response, or its schema, or operating directly on the results and saving them to other variables for later use. These commands start with a > to denote that the following instructions should be handled by the JS VM context.

Additionally, there are some global variables that allow you to retrieve past results:

• $ - Array - Returns all the results of the last

License

MIT