Install MS SQL CLI
Install MS SQL CLI#
mssql-cli is a command line query tool for MS SQL Server. It runs on Windows, macOS, and Linux.
For more general information and detailed installation instructions see Microsoft Docs / SQL / Tools / Command prompt utilities / mssql-cli.
For macOS and Windows platforms you can generally install using pip.
$ pip install mssql-cli
On AWS/CentOS /RHEL flavored systems use sudo to first install python-pip, then use pip.
sudo yum install -y python-pip
sudo pip install mssql-cli
For Ubuntu flavor Linux, use apt-get:
# Import the public repository GPG keys
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
# Register the Microsoft Ubuntu repository
sudo apt-add-repository https://packages.microsoft.com/ubuntu/18.04/prod
# Update the list of products
sudo apt-get update
# Install mssql-cli
sudo apt-get install mssql-cli
# Install missing dependencies
sudo apt-get install -f