mssql-cli is an interactive command line query tool for SQL Server. This open source tool works cross-platform and proud to be a part of the dbcli community.
mssql-cli supports a rich interactive command line experience, with features such as:
Read the section below to quickly get started with mssql-cli. Consult the usage guide for a deeper dive into mssql-cli features.
Platform-specific installation instructions are below:
| Windows | macOS | Linux |
|---|
Visit the installation reference guide to view all supported releases and downloads.
Follow the Linux installation instructions to install mssql-cli using apt-get, yum, and other Linux package managers.
python -m pip install mssql-cli
Please refer to the pip installation docs for more platform-specific information.
Complete the command below to connect to your server:
mssql-cli -S <server URL> -d <database name> -U <username> -P <password>
Press Ctrl+D or type quit.
For general help content, pass in the -h parameter:
mssql-cli --help
Please refer to the usage guide for details on options and example usage. If you are having any issues using mssql-cli, please see the troubleshooting guide.
The mssql-cli tool includes a telemetry feature. Please refer to the telemetry guide for more information.
If you would like to contribute to the project, please refer to the development guide.
If you encounter any bugs or would like to leave a feature request, please file an issue in the Issues section of our GitHub repo.
This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.
mssql-cli is licensed under the BSD-3 license.
FAQs
CLI for SQL Server Database. With auto-completion and syntax highlighting.
We found that mssql-cli demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 3 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Product
Socket now supports Scala and Kotlin, bringing AI-powered threat detection to JVM projects with easy manifest generation and fast, accurate scans.
Application Security
/Security News
Socket CEO Feross Aboukhadijeh and a16z partner Joel de la Garza discuss vibe coding, AI-driven software development, and how the rise of LLMs, despite their risks, still points toward a more secure and innovative future.
Research
/Security News
Threat actors hijacked Toptal’s GitHub org, publishing npm packages with malicious payloads that steal tokens and attempt to wipe victim systems.