Azure Data Studio FAQ
Azure Data Studio is an open source, cross-platform, multi-database tool for managing data. It offers a rich query editor experience with IntelliSense, keyword completion, code snippets & code navigation, and source control integration.
Azure Data Studio has been designed to focus deeply on the functionality that is used most by people who work with data,
Azure Data Studio is free for private or commercial use.
Anyone can use Azure Data Studio. However, it is designed to simplify tasks performed by database developers, database administrators, system administrators, and independent software vendors.
- Execute on-demand queries in a rich query editor
- Organize and manage your database connections on-premises, in Azure or any cloud
- Use your favorite command-line tools (i.e. Bash, PowerShell, sqlcmd, bcp, psql, ssh) in the Integrated Terminal window
- Use rich customizable dashboards to monitor and quickly troubleshoot performance bottlenecks in your databases
- Browse our growing library of extensions for additional features to supplement your administrative or developer experience (i.e. Schema Compare or Agent job management)
- Deploy and manage SQL Server 2019 Big Data Clusters
We ship Azure Data Studio monthly with new features, enhancements, and bug fixes.
Follow us on Twitter (@AzureDataStudio) to stay updated on all Azure Data Studio related news.
Please submit bug reports or feedback on the Azure Data Studio GitHub: https://github.com/microsoft/azuredatastudio
If ADS is a multi-database tool, will it also support CosmosDB, Spark Databricks and/or Azure Data Explorer anytime soon?
SQL and Postgres are currently supported. Other platforms are not yet committed, but we’re watching to see what the demand is.
At this time Azure Data Studio only officially supports MFA. This is something we will prioritize in our planning as more Azure Data partners use our product.
No. Investments in flagship Windows tools (SSMS, SSDT, PowerShell) will continue in addition to the next generation of CLI and GUI tools. The goal is to offer customers the choice of using the tools they want on platforms of their choice.
It depends on the scenario & customer/business need. To help us prioritize, please voice your suggestions on our Github: https://github.com/microsoft/azuredatastudio
- Spend most of your time editing or executing queries
- Need the ability to quickly chart and visualize resultsets
- Can execute most administrative tasks via the integrated terminal using sqlcmd or PowerShell
- Do not need to do deep administrative or platform related configuration
- Want to create and edit SQL, Python, and Powershell notebooks
- Work with SQL Server 2019 Big Data Clusters
- Need to run on macOS or Linux
- Spend most of your time on database administration tasks
- Are doing complex administrative or platform configuration
- Are doing security management, including user management, vulnerability assessment, and configuration of security features
- Need to make use of performance tuning advisors and dashboards
- Use database diagrams and table designers
- Need access to Registered Servers
Documentation
- Get Started
- Install Azure Data Studio
- Telemetry
- Microsoft Ready 2019 Lab
- MS Docs Overview
- Debug Trace Logging
- Troubleshoot Azure Authentication Issues
- FAQ
Contributing
- How to Contribute
- Developer Getting Started
- Submitting Bugs and Suggestions
- Localization
- Troubleshooting Build Issues
- Engineering FAQ
- How to update typings files
- Importing and using modules
- UI Guidelines
- Angular UI Guidelines
- Contributor License Agreement
- Azure Data Studio Tests
- Why is the Azure Data Studio license different than the repository license?
Tool Services
Extensibility Reference
- Getting Started
- Extensibility API
- Contribution Points
- Context Variables
- Servers and Data Explorer Tree Views
- Debugging with VS Code
- Extension Authoring
- Building multiple insight widgets
- Microsoft Ignite lab
- List of Extensions
- Replace sqlops namespace
Project Management