Azure Data Studio is a comprehensive data management and development tool designed to connect to both cloud-based and on-premises databases. It provides robust capabilities for managing and developing across popular database systems.
Key Features:
Connectivity to Azure SQL, SQL Server, MySQL, PostgreSQL, MongoDB, and more via an extendable architecture.
Cross-platform support for Windows, macOS, and Linux with simple deployment options.
Object Explorer for schema browsing and contextual command execution.
Advanced T-SQL Query Editor with autosuggestions, error diagnostics, tooltips, and formatting tools.
Management Dashboard with customizable widgets for actionable insights.
Audience & Benefit:
Ideal for database administrators, developers, and data professionals to streamline database management workflows. It enables efficient data exploration, query optimization, and task automation across hybrid environments.
Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for additional database support options including MySQL, PostgreSQL, and MongoDB.
Download the latest Azure Data Studio release
Please visit our download page for more specific installation instructions.
Check out the change log or release notes for additional details of what's in the each release.
The Azure Data Studio documentation includes complete details on getting started, connection quickstarts, and feature tutorials.
T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition
Query Results Viewer with advanced data grid supporting large result sets, export to JSON\CSV\Excel, query plan and charting
Management Dashboard supporting customizable widgets with drill-through actionable insights
Visual Data Editor that enables direct row insertion, update and deletion into tables
Backup and Restore dialogs that enables advanced customization and remote filesystem browsing, configured tasks can be executed or scripted
Task History window to view current task execution status, completion results with error messages and task T-SQL scripting
Scripting support to generate CREATE, SELECT, ALTER and DROP statements for database objects
Workspaces with full Git integration and Find In Files support to managing T-SQL script libraries
Modern light-weight shell with theming, user settings, full-screen support, integrated terminal and numerous other features
Here are some of these features in action.
Contributing
If you are interested in fixing issues and contributing directly to the code base,
please see the document How to Contribute, which covers the following:
Azure Data Studio is localized into 10 languages: French, Italian, German, Spanish, Simplified Chinese, Traditional Chinese, Japanese, Korean, Russian, and Portuguese (Brazil). The language packs are available in the Extension Manager marketplace. Simply, search for the specific language using the extension marketplace and install. Once you install the selected language, Azure Data Studio will prompt you to restart with the new language.
Telemetry
Azure Data Studio collects telemetry data, which is used to help understand how to improve the product. For example, this usage data helps to debug issues, such as slow start-up times, and to prioritize new features. While we appreciate the insights this data provides, we also know that not everyone wants to send usage data and you can disable telemetry as described in the disable telemetry reporting documentation.
