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.