Azure Data Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
Download the latest Azure Data Studio release
| Platform | Link |
|---|---|
| Windows User Installer | https://go.microsoft.com/fwlink/?linkid=2091882 |
| Windows System Installer | https://go.microsoft.com/fwlink/?linkid=2091491 |
| Windows ZIP | https://go.microsoft.com/fwlink/?linkid=2091490 |
| macOS ZIP | https://go.microsoft.com/fwlink/?linkid=2091489 |
| Linux TAR.GZ | https://go.microsoft.com/fwlink/?linkid=2091488 |
| Linux RPM | https://go.microsoft.com/fwlink/?linkid=2091487 |
| Linux DEB | https://go.microsoft.com/fwlink/?linkid=2092022 |
Go to our download page for more specific instructions.
Try out the latest insiders build from master:
- Windows User Installer - Insiders build
- Windows System Installer - Insiders build
- Windows ZIP - Insiders build
- macOS ZIP - Insiders build
- Linux TAR.GZ - Insiders build
See the change log for additional details of what's in this release.
Feature Highlights
- 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 document How 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 the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.
Azure Data Studio localization is now open for community contributions. You can contribute to localization for both software and docs. https://aka.ms/SQLOpsStudioLoc
Localization is now opened for 10 languages: French, Italian, German, Spanish, Simplified Chinese, Traditional Chinese, Japanese, Korean, Russian, and Portuguese (Brazil). Help us make Azure Data Studio available in your language!
The Microsoft Enterprise and Developer 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:
- yamatoya for
fix the format (#4899) - GeoffYoung for
Fix sqlDropColumn description #4422 - AlexFsmn for
Added context menu for DBs in explorer view to backup & restore db. #2277 - sadedil for
Missing feature request: Save as XML #3729 - gbritton1 for
Removed reference to object explorer #3463 - Tarig0 for
Add Routine_Type to CreateStoredProc fixes #3257 (#3286) - oltruong for
typo fix #3025' - Thomas-S-B for
Removed unnecessary IErrorDetectionStrategy #749 - Thomas-S-B for
Simplified code #750 - rdaniels6813 for
Add query plan theme support #3031 - Ruturaj123 for
Fixed some typos and grammatical errors #3027 - PromoFaux for
Use emoji shortcodes in CONTRIBUTING.md instead of � #3009 - ckaczor for
Fix: DATETIMEOFFSET data types should be ISO formatted #714 - hi-im-T0dd for
Fixed sync issue with my forked master so this commit is correct #2948 - hi-im-T0dd for
Fixed when right clicking and selecting Manage-correct name displays #2794 - philoushka for
center the icon #2760 - anthonypants for
Typo #2775 - kstolte for
Fix Invalid Configuration in Launch.json #2789 - kstolte for
Fixing a reference to SQL Ops Studio #2788 - AlexFsmn
Feature: Ability to add connection name #2332 - AlexFsmn
Disabled connection name input when connecting to a server. #2566 - SebastianPfliegel
Added more saveAsCsv options #2099 - ianychoi
Fixes a typo: Mimunum -> Minimum #1994 - AlexFsmn
Fixed bug where proper file extension wasn't appended to the filename. #2151 - AlexFsmn
Added functionality for adding any file to import wizard #2329 - AlexFsmn
Fixed background issue when copying a chart to clipboard #2215 - AlexFsmn
Fixed problem where vertical charts didn't display labels correctly. #2263 - AlexFsmn
Fixed Initial values for charts to match visuals #2266 - AlexFsmn
Renamed chart option labels #2264 - AlexFsmn
Added feature for the opening file after exporting to CSV/XLS/JSON & query files #2216 - AlexFsmm
Get Connection String should copy to clipboard #2175 - lanceklinger
Fix for double-clicking column handle in results table #1504 - westerncj for
Removed duplicate contribution from README.md (#753) - ntovas for
Fix for duplicate extensions shown in "Save File" dialog. (#779) - SebastianPfliegel for
Add cursor snippet (#475) - mikaoelitiana for the fix:
revert README and CONTRIBUTING after last VSCode merge (#574) - alextercete for
Reinstate menu item to install from VSIX (#682) - alextercete for
Fix "No extension gallery service configured" error (#427) - mwiedemeyer for
Fix #58: Default sort order for DB size widget (#111) - AlexTroshkin for
Show disconnect in context menu only when connectionProfile connected (#150) - AlexTroshkin for
Fix #138: Invalid syntax color highlighting (identity not highlighting) (#140)) - stebet for
Fix #153: Fixing sql snippets that failed on a DB with a case-sensitive collation. (#152) - SebastianPfliegel
Remove sqlExtensionHelp (#312) - olljanat for
Implemented npm version check (#314) - Adam Machanic for helping with the
whoisactiveextension - All community localization contributors:
- French: Adrien Clerbois, ANAS BELABBES, Antoine Griffard, Arian Papillon, Eric Macarez, Eric Van Thorre, Jérémy LANDON, Matthias GROSPERRIN, Maxime COQUEREL, Olivier Guinart, thierry DEMAN-BARCELÒ, Thomas Potier
- Italian: Aldo Donetti, Alessandro Alpi, Andrea Dottor, Bruni Luca, Gianluca Hotz, Luca Nardi, Luigi Bruno, Marco Dal Pino, Mirco Vanini, Pasquale Ceglie, Riccardo Cappello, Sergio Govoni, Stefano Demiliani
- German: Anna Henke-Gunvaldson, Ben Weissman, David Ullmer, J.M. ., Kai Modo, Konstantin Staschill, Kostja Klein, Lennart Trunk, Markus Ehrenmüller-Jensen, Mascha Kroenlein, Matthias Knoll, Mourad Louha, Thomas Hütter, Wolfgang Straßer
- Spanish: Alberto Poblacion, Andy Gonzalez, Carlos Mendible, Christian Araujo, Daniel D, Eickhel Mendoza, Ernesto Cardenas, Ivan Toledo Ivanovic, Fran Diaz, JESUS GIL, Jorge Serrano Pérez, José Saturnino Pimentel Juárez, Mauricio Hidalgo, Pablo Iglesias, Rikhardo Estrada Rdez, Thierry DEMAN, YOLANDA CUESTA ALTIERI
- Japanese: Fujio Kojima, Kazushi KAMEGAWA, Masayoshi Yamada, Masayuki Ozawa, Seiji Momoto, Takashi Kanai, Takayoshi Tanaka, Yoshihisa Ozaki, 庄垣内治
- Chinese (simplified): DAN YE, Joel Yang, Lynne Dong, Ryan（Yu） Zhang, Sheng Jiang, Wei Zhang, Zhiliang Xu
- Chinese (Traditional): Bruce Chen, Chiayi Yen, Kevin Yang, Winnie Lin, 保哥 Will, 謝政廷
- Korean: Do-Kyun Kim, Evelyn Kim, Helen Jung, Hong Jmee, jeongwoo choi, Jun Hyoung Lee, Jungsun Kim정선, Justin Yoo, Kavrith mucha, Kiwoong Youm, MinGyu Ju, MVP_JUNO BEA, Sejun Kim, SOONMAN KWON, sung man ko, Yeongrak Choi, younggun kim, Youngjae Kim, 소영 이
- Russian: Andrey Veselov, Anton Fontanov, Anton Savin, Elena Ostrovskaia, Igor Babichev, Maxim Zelensky, Rodion Fedechkin, Tasha T, Vladimir Zyryanov
- Portuguese Brazil: Daniel de Sousa, Diogo Duarte, Douglas Correa, Douglas Eccker, José Emanuel Mendes, Marcelo Fernandes, Marcondes Alexandre, Roberto Fonseca, Rodrigo Crespi
And of course, we'd like to thank the authors of all upstream dependencies. Please see a full list in the ThirdPartyNotices.txt
Copyright (c) Microsoft Corporation. All rights reserved.
Licensed under the Source EULA.