
It is also highly customizable, so if you find yourself running the same queries each time, you can save it and easily run it. Users can easily run common queries and actions using a default set of special commands. With mssql-cli, we support horizontal paging so that users can easily navigate with arrow keys to read through the results of a query. In the past, users did not have many options when displaying results that go off the screen due to the size of the result. This is the first time that our SQL Server command line tools have included this experience, and it will make it much easier to write your ad-hoc queries and even discover your database objects. One of the major features of mssql-cli is that you get Intellisense as you are writing queries in the command line. Read on to learn more about how mssql-cli will help improve your productivity through a modern CLI experience. With this release, you will also be able to use mssql-cli in non-interactive scenarios such as scripting and automation. If you are a user of sqlcmd, you will love the interactive and modern design components in mssql-cli.


We are a proud member of the dbcli family of open source command line tools to manage relational databases. Mssql-cli is an open source and cross-platform command-line tool (CLI) to manage SQL Server on-prem and on the cloud. We are excited to announce that mssql-cli is now generally available on macOS and Linux.
