Azure Data Studio is a lightweight, cross-platform database tool with a modern user interface that helps users manage databases more easily.

Fully Open Source

Azure Data Studio is an open source project with all of its code hosted on GitHub. Users are free to view the source code and can also contribute to the project.

https://github.com/Microsoft/azuredatastudio

Manageable Databases

Azure Data Studio supports a variety of databases, including SQL Server, PostgreSQL, MySQL, TimescaleDB, Oracle, and more. By installing the corresponding extensions, it can support even more databases.

Query Editor with IntelliSense

A rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git) provide a modern, keyboard-focused SQL coding experience.

Smart SQL Code Snippets

Azure Data Studio provides a large number of SQL code snippets to help users write SQL code quickly.

Using Server Groups

With server groups, you can organize servers into categories, making it easier to manage multiple servers.

Using the Integrated Terminal

Common command-line tools, such as the sqlcmd command, can be used in the “Integrated Terminal” window of the user interface.

Using the Table Designer

Azure Data Studio provides a table designer that helps users design tables more easily.

Backing Up and Restoring Databases

Azure Data Studio provides backup and restore functionality, helping users back up and restore databases more easily.

Using the Copilot Extension

The Copilot extension leverages powerful AI to help users write SQL code more easily and improve coding efficiency.

Managing SQL Scripts with Git

Azure Data Studio integrates Git, helping users manage SQL scripts more easily.

Viewing Query Plans

Capturing both estimated and actual query plans is supported. A query plan provides a graphical representation of the data retrieval (or modification) methods chosen by the SQL Server query optimizer.

Extensibility

Extensions can be installed online or manually using VSIX files, and extensions can provide additional functionality.

Some Useful Extensions

  • SQL Server Import (mssql) - import data
  • SQL Server Profiler (mssql) - analyze SQL Server database performance
  • SQL Server Agent (mssql) - manage SQL Server Agent

Compared with SQL Server Management Studio

Azure Data Studio is a lightweight, cross-platform database tool. Compared with SQL Server Management Studio, Azure Data Studio is lighter and better suited for platforms such as Mac and Linux. It also supports multiple databases, helping users manage databases more easily, and its functionality can be extended on demand through extensions, making it more flexible.