In this post, we are going to discuss a new cross-platform and interactive command-line query tool that can be used to communicate with Microsoft SQL Server. Unlike sqlcmd command-line utility, mssql-cli supports cross-platform and can be used on Windows, macOS, Linux, Ubuntu, Debian, CentOS, Fedora, and etc. This is an open-source tool and it supports a very-rich and interactive command-line experience.
The mssql-cli is written in Python and it is released under open source BSD-3 license by Microsoft. It provides a very user-friendly terminal experience for T-SQL queries. It is a very small REPL utility and takes very less amount on the disk. It provides a highly interactive interface for writing T-SQL queries. Let’s discuss the features of the mssql-cli in detail.
Features of mssql-cli
Below we have listed the main features of mssql-cli:
It offers an improved command-line experience for T-SQL by enabling support for IntelliSense … More