mssql-cli command-line query tool for SQL Server (Preview)
APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics Parallel Data Warehouse
mssql-cli is an interactive command-line tool for querying SQL Server and runs on Windows, macOS, or Linux.
For detailed installation instructions, see the Installation Guide. The most common install scenarios are summarized below.
Windows and macOS Installation
mssql-cli is installed on Windows and macOS using
$ pip install mssql-cli
For more detailed instructions, please see the Installation Guide.
After registering the Microsoft repository, mssql-cli can be installed and upgraded through package managers on several Linux distributions.
The following example applies to Ubuntu 18.04 (Bionic), more information and examples for other distributions can be found in the Installation Guide.
# 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
Documentation for mssql-cli is located in the mssql-cli GitHub repository.
Additional documentation is located in the doc folder.