[!INCLUDEname-sos] is a free lightweight database development and operations tool that runs on your desktop and is available for Windows, macOS, and Linux. [!INCLUDEname-sos] has built-in support for Azure SQL Database, Azure SQL Data Warehouse, and SQL Server running on-premises or in any cloud. [!INCLUDEname-sos] offers a consistent experience across databases of your choice on your favorite operating systems.

Download [!INCLUDEname-sos] for Windows, macOS, and Linux from http://aka.ms/sqlopsstudio

[!INCLUDEname-sos] is free for private or commercial use.

Anyone can use [!INCLUDEname-sos]. However, it is designed to simplify tasks performed by database developers, database administrators, system administrators, and independent software vendors.

[!INCLUDEname-sos] is built on top of Visual Studio Code and offers a lightweight, keyboard focused modern code workflow experience when working with SQL.

[!INCLUDEname-sos] makes the core experiences that you rely on every day simple and easy with built-in features such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets & code navigation and source control integration (Git and TFS). You can execute on-demand queries, view & save results as text, JSON, or Excel, edit data, organize & manage your favorite database connections, and browse database objects in a familiar object browsing experience.

Use your favorite command-line tools (for example, Bash, PowerShell, sqlcmd, bcp, psql, and ssh) in the Integrated Terminal window right within the [!INCLUDEname-sos] user interface. Easily generate and execute CREATE and INSERT scripts for your database objects to create copies of your database for development or testing purposes. Boost your productivity with smart code snippets and rich graphical experiences that create new databases and database objects (such as tables, views, stored procedures, users, logins, roles, etc.) or update existing database objects. Use rich customizable dashboards to monitor and quickly troubleshoot performance bottlenecks in your databases on-premises, in Azure or any cloud.

[!INCLUDEname-sos] offers a consistent experience to back up and restore your databases. With planned support for SQL Server Always On Availability Groups, you can easily configure, monitor, and troubleshoot AGs for your mission-critical SQL Server databases and quickly failover to a secondary database during a disaster. [!INCLUDEname-sos] has been designed to make you more productive in the DevOps lifecycle of your databases of choice on the operating systems of your choice. As a result, you are always in control, and you can reduce risks, solve problems faster, and continuously deliver value that exceeds customers’ expectations.

The source code for [!INCLUDEname-sos] and its data providers is available on GitHub. The source code for the front end of [!INCLUDEname-sos] (which is based on Visual Studio Code) is available under a source code EULA that provides rights to modify and use the software, but not to redistribute it or host it in a cloud service. The source code for the data providers is available under the MIT license at https://github.com/Microsoft/sqltoolsservice.

No. However, next generation multi-OS CLI and GUI tools are open source. For example, the mssql extension for VS Code, mssql-scripter, and msql-CLI are all open source on GitHub. The source code for [!INCLUDEname-sos] is available on GitHub.

No. Investments in flagship Windows tools (SSMS, SSDT, PowerShell) will continue in addition to the next generation of multi-OS and multi-DB CLI and GUI tools. The goal is to offer customers the choice of using the tools they want on the platforms of their choice for their scenarios.

It depends on the scenario & customer/business need. To help prioritize, file a suggestion on GitHub.

The SMO APIs are not yet available on Linux or macOS in a consumable way. We ported over a subset of the SMO APIs to .NET Core that we needed for [!INCLUDEname-sos], and we plan to expand as part of the roadmap. The SQL Tools Service is on GitHub: https://github.com/Microsoft/sqltoolsservice.

It's on the longer-term roadmap. To help prioritize, file a suggestion on GitHub.

SQL PowerShell is available today on the PowerShell gallery and you can use it on Windows to work with SQL Server running anywhere, including SQL on Linux. Offering the SQL PowerShell cmdlets on Linux & macOS is in the roadmap. To help prioritize, file a suggestion on GitHub.