Skip navigation

Azure Data Studio

A modern open-source, cross-platform hybrid data analytics tool designed to simplify the data landscape

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.

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

Workspaces with customisable, intuitive services to personalise your environment to the workflows you use most often

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

Extensions that give you access to new features and additional services

Get a unified tooling experience

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. Customise your environment to the workflows you use most often.

Work across multiple platforms

Put the tool where you want as a desktop application, with operating system support for Windows, MacOS, and Linux. It also offers robust language support for SQL, PowerShell, Python, KQL, Apache Spark TM, and PySpark to manage and query SQL Server, PostgreSQL, and Azure Data Explorer.

Connect on-premises or in multicloud environments

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. Execute 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.

See how customers are using Azure Data Studio


"We backed up ... to Azure Storage [and] restored the backup to Azure Arc–enabled SQL Managed Instance in less than 10 minutes. ... I could immediately start accessing it via Azure Data Studio."

Kristina Melo, SQL Server Database Administrator, Ferguson Enterprises

Resources and documentation

Learn more about Azure Data Studio

Frequently asked questions about Azure Data Studio

  • No. It's a hybrid tool built for both on-premises and cloud data services.
  • For more information, including what tool to use when, use cases, and features, see the supplemental FAQ.
  • 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 Microsoft Visual Studio Code, is available under an end-user licence 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 licence.

Ready when you are—let's set up your Azure free account

Can we help you?