Repository files navigation

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 theextension library for additional database support options including MySQL, PostgreSQL, and MongoDB.

Go to ourdownload page for more specific instructions.

Please visit ourdownload page for more specific installation instructions.Check out thechange log orrelease notes for additional details of what's in the each release.TheAzure Data Studio documentation includes complete details on getting started, connection quickstarts, and feature tutorials.

• Cross-Platform DB management for Windows, macOS and Linux with simple XCopy deployment
• SQL Server Connection Management with Connection Dialog, Server Groups, Azure Integration and Registered Servers
• Object Explorer supporting schema browsing and contextual command execution
• 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.

If you are interested in fixing issues and contributing directly to the code base,please see the documentHow to Contribute, which covers the following:

• How to build and run from source
• The development workflow, including debugging and running tests
• Submitting pull requests

This project has adopted theMicrosoft Open Source Code of Conduct. For more information see theCode of Conduct FAQ or contactopencode@microsoft.com with any additional questions or comments.

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.

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 thedisable telemetry reporting documentation.

TheMicrosoft Privacy Statement describes the privacy statement of this software.

We would like to thank all our users who raised issues, and in particular the following users who helped contribute fixes:

• eulercamposbarros forPrevent connections from moving on click (#7528)
• AlexFsmn forFixed issue where task icons got hidden if text was too long
• jamesrod817 forTempdb (#7022)
• dzsquared forfix(snippets): ads parenthesis to sqlcreateindex snippet #7020
• devmattrick forUpdate row count as updates are received #6642
• mottykohn forIn Message panel onclick scroll to line #6417
• Stevoni forCorrected Keyboard Shortcut Execution Issue #5480
• yamatoya forfix the format #4899
• GeoffYoung forFix sqlDropColumn description #4422
• AlexFsmn forAdded context menu for DBs in explorer view to backup & restore db. #2277
• sadedil forMissing feature request: Save as XML #3729
• gbritton1 forRemoved reference to object explorer #3463
• Tarig0 forAdd Routine_Type to CreateStoredProc fixes #3257 (#3286)
• oltruong fortypo fix #3025'
• Thomas-S-B forRemoved unnecessary IErrorDetectionStrategy #749
• Thomas-S-B forSimplified code #750
• rdaniels6813 forAdd query plan theme support #3031
• Ruturaj123 forFixed some typos and grammatical errors #3027
• PromoFaux forUse emoji shortcodes in CONTRIBUTING.md instead of � #3009
• ckaczor forFix: DATETIMEOFFSET data types should be ISO formatted #714
• hi-im-T0dd forFixed sync issue with my forked master so this commit is correct #2948
• hi-im-T0dd forFixed when right clicking and selecting Manage-correct name displays #2794
• philoushka forcenter the icon #2760
• anthonypants forTypo #2775
• kstolte forFix Invalid Configuration in Launch.json #2789
• kstolte forFixing a reference to SQL Ops Studio #2788
• AlexFsmnFeature: Ability to add connection name #2332
• AlexFsmnDisabled connection name input when connecting to a server. #2566
• SebastianPfliegelAdded more saveAsCsv options #2099
• ianychoiFixes a typo: Mimunum -> Minimum #1994
• AlexFsmnFixed bug where proper file extension wasn't appended to the filename. #2151
• AlexFsmnAdded functionality for adding any file to import wizard #2329
• AlexFsmnFixed background issue when copying a chart to clipboard #2215
• AlexFsmnFixed problem where vertical charts didn't display labels correctly. #2263
• AlexFsmnFixed Initial values for charts to match visuals #2266
• AlexFsmnRenamed chart option labels #2264
• AlexFsmnAdded feature for the opening file after exporting to CSV/XLS/JSON & query files #2216
• AlexFsmmGet Connection String should copy to clipboard #2175
• lanceklingerFix for double-clicking column handle in results table #1504
• westerncj forRemoved duplicate contribution from README.md (#753)
• ntovas forFix for duplicate extensions shown in "Save File" dialog. (#779)
• SebastianPfliegel forAdd cursor snippet (#475)
• mikaoelitiana for the fix:revert README and CONTRIBUTING after last VSCode merge (#574)
• alextercete forReinstate menu item to install from VSIX (#682)
• alextercete forFix "No extension gallery service configured" error (#427)
• mwiedemeyer forFix #58: Default sort order for DB size widget (#111)
• AlexTroshkin forShow disconnect in context menu only when connectionProfile connected (#150)
• AlexTroshkin forFix #138: Invalid syntax color highlighting (identity not highlighting) (#140))
• stebet forFix #153: Fixing sql snippets that failed on a DB with a case-sensitive collation. (#152)
• SebastianPfliegelRemove sqlExtensionHelp (#312)
• olljanat forImplemented npm version check (#314)
• Adam Machanic for helping with thewhoisactive extension

And of course, we'd like to thank the authors of all upstream dependencies. Please see a full list in theThirdPartyNotices.txt

Copyright (c) Microsoft Corporation. All rights reserved.

Licensed under theMIT License.