Modern SQL shells like mssql-cli, mycli, SQLcl and pgcli are very convenient: they offer auto-completion, syntax highlighting, query history, a multi-line editor, and much more.

SQL Shell makes using SQL clients even more convenient:

• a standard interface to enter connection parameters so you don’t have to remember command line options

• pre-defined connection strings for connection without typing

• automatic tunneling if your database is behind a firewall or listening only on localhost interface

• SQL shell clients (mssql-cli, mycli, SQLcl, pgcli, litecli)

• Linux only: Python modules click, npyscreen, pycompat, and sshtunnel

1. download release

2. verify requirements

1. optional: edit sql shell.ini and tunnel.ini to match your environment

2. run sql shell.exe (Windows) or sql shell.py (Linux)