Installing mssql-cli

mssql-cli is an interactive command-line tool for querying SQL Server, install it on Windows, macOS, or Linux.

To download mssqli-cli package , download and install python on the OS. The latest Python installation package can be downloaded from here

Once Python is installed successfully, open command prompt with elevated permissions and run the below command

pip install mssql-cli

For detailed installation instructions, see the Installation Guide.

C:\>curl -o
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 1603k  100 1603k    0     0  1603k      0  0:00:01 --:--:--  0:00:01 3306k

C:\>pip install mssql-cli
Collecting mssql-cli
  Downloading (33.6MB)
    100% |████████████████████████████████| 33.6MB 7.7kB/s
Collecting future>=0.16.0 (from mssql-cli)
  Downloading (824kB)
    100% |████████████████████████████████| 829kB 314kB/s
Collecting click>=4.1 (from mssql-cli)
  Downloading (71kB)
    100% |████████████████████████████████| 71kB 1.1MB/s
Collecting enum34>=1.1.6 (from mssql-cli)
Collecting prompt-toolkit<1.1.0,>=1.0.10 (from mssql-cli)
  Downloading (247kB)
    100% |████████████████████████████████| 256kB 968kB/s
Collecting argparse>=1.2.1 (from mssql-cli)
Collecting wheel>=0.29.0 (from mssql-cli)
  Downloading (41kB)
    100% |████████████████████████████████| 51kB 1.0MB/s
Collecting sqlparse<0.3.0,>=0.2.2 (from mssql-cli)
Collecting humanize>=0.5.1 (from mssql-cli)
Collecting applicationinsights>=0.11.1 (from mssql-cli)
  Downloading (53kB)
    100% |████████████████████████████████| 61kB 1.2MB/s
Collecting Pygments>=2.0 (from mssql-cli)
  Downloading (841kB)
    100% |████████████████████████████████| 849kB 144kB/s
Collecting cli-helpers<1.0.0,>=0.2.3 (from mssql-cli)
Collecting configobj>=5.0.6 (from mssql-cli)
Collecting wcwidth (from prompt-toolkit<1.1.0,>=1.0.10->mssql-cli)
Collecting six>=1.9.0 (from prompt-toolkit<1.1.0,>=1.0.10->mssql-cli)
Collecting backports.csv>=1.0.0 (from cli-helpers<1.0.0,>=0.2.3->mssql-cli)
Collecting terminaltables>=3.0.0 (from cli-helpers<1.0.0,>=0.2.3->mssql-cli)
Installing collected packages: future, click, enum34, wcwidth, six, prompt-toolkit, argparse, wheel, sqlparse, humanize, applicationinsights, Pygments, backports.csv, terminaltables, cli-helpers, configobj, mssql-cli
  Running install for future ... done
  Running install for humanize ... done
  Running install for terminaltables ... done
  Running install for configobj ... done
Successfully installed Pygments-2.2.0 applicationinsights-0.11.4 argparse-1.4.0 backports.csv-1.0.6 cli-helpers-0.2.3 click-6.7 configobj-5.0.6 enum34-1.1.6 future-0.16.0 humanize-0.5.1 mssql-cli-0.13.0 prompt-toolkit-1.0.15 six-1.11.0 sqlparse-0.2.4 terminaltables-3.1.0 wcwidth-0.1.7 wheel-0.31.1
You are using pip version 9.0.3, however version 10.0.1 is available.
You should consider upgrading via the 'python -m pip install --upgrade pip' command.

Usage Guide is available on git hub.


Leave a Reply

Your email address will not be published.