Azure Data Studio

Overview

A unified tooling experience for data professionals

Designed to focus on the functionality data platform developers use the most, Azure Data Studio offers additional experiences available as optional extensions. It's built for data professionals who use SQL Server and Azure databases on-premises or in multicloud environments.

Consolidate processes in a lightweight, extensible data analytics tool with modern paradigms and use only the features you need. Take advantage of a full-fledged query editor, native Jupyter Notebooks, built-in Git support, and a convenient terminal. Add and remove functionality to get the tool that's best suited for your work. Use the SQL Database Projects extension to develop for SQL Server. Customize your environment to the workflows you use most often.
Put the tool where you want it—as a desktop application with operating system support for Windows, MacOS, and Linux. Azure Data Studio also offers robust language support for SQL, PowerShell, Python, Kusto Query Language (KQL), Apache Spark, and PySpark to manage and query SQL Server, PostgreSQL, and Azure Data Explorer.
Connect to your data where it resides, whether on-premises or in the cloud. Use Azure Arc to deploy hybrid databases and Azure services anywhere, and to extend Azure management to any infrastructure. Run local jobs that don’t need to be connected to a server. Get support for data platforms including SQL Server 2019 Big Data Clusters and Azure Database for PostgreSQL.

Features

Key Features

Built-in Query Editor

Built-in query editor, native Jupyter Notebooks, and an integrated terminal.

Customizable workspaces

Workspaces with customizable, intuitive services to personalize your environment to the workflows you use most often.

Platform flexibility

Platform flexibility that spans data operations, including management, deployment, and migration of Azure data services.

Extensions

Extensions that give you access to new features and additional services.

Person smiling and gesturing during a video call on a laptop at an outdoor café, with a paper cup nearby.

Pricing

Choose the Azure account that’s right for you

Pay as you go or try Azure free for up to 30 days.

Get started with Azure

Resources

Learn more about Azure Data Studio

A man with gray hair wearing a brown jacket and scarf looks at a smartphone.

Follow Azure Data Studio on X

Stay current with the latest news and updates.

Follow Azure Data Studio

A person is working at a computer with code on one monitor and emails on another in an office setting.

Azure Data Studio on GitHub

Access the source code, projects, and samples.

Learn more

Two people are discussing something while one holds a tablet displaying a chart.

Azure Data Studio documentation

Find detailed guides and tutorials.

Read now

No. It's a hybrid tool built for both on-premises and cloud data services.

Learn more
For more information, including what tool to use when, use cases, and features, see the Azure Data Studio FAQ.

Learn more
Yes, the source code for Azure Data Studio and its data providers is open source and available on GitHub. The source code for the front-end Azure Data Studio, which is based on Visual Studio Code, is available under an end-user license agreement 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.

Learn more