mssql-cli is a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is part of the dbcli community.
mssql-cli auto-completion in action
In this release (v0.13.0), highlights include:
- Apt-get and Linux packaging support
- GDPR Compliance
- New demo video
Apt-get and Linux packaging support
One of the key issues Linux users run into when setting up mssql-cli for the first time is not having the right version of Python or having to install Python for the first time. We want to make the first experience with mssql-cli painless, thus we added apt-get support in order to package Python with your installation to help improve the acquisition experience.
For full instructions to acquire mssql-cli for each Linux distribution, please check out the Linux installation guide.
Note: For those who already installed mssql-cli via pip install, please run
sudo pip uninstall mssql-cli
Then, follow the installation instructions.
As many of us are familiar with, GDPR is approaching and we made some updates. In the past, file history stored entire T-SQL queries. However, if the query contained any secrets or passwords, it wasn’t smart enough to scrub those out. This is no longer the case, and now file history has been updated to no longer store secrets or passwords.
In addition, we have added 24-hour rotation of UserID when we collect telemetry.
New Channel9 video
One of our engineers, Abhi Abhishek, presented a demo of mssql-cli for Channel9, the Microsoft Developer studio. If you are new to mssql-cli, please check out this video and please share with those you feel would benefit from using this tool.