Skip to content
Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
TypeScript JavaScript CSS HTML Jupyter Notebook Shell
Branch: master
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github Add charle-gagnon to default assignee (#8382) Nov 18, 2019
.lgtm/javascript-queries Add name and change severity (#7727) Oct 15, 2019
.vscode Merge from vscode c58aaab8a1cc22a7139b761166a0d4f37d41e998 (#7880) Oct 22, 2019
build Update js file with monaco -> ads workbench (#8398) Nov 20, 2019
docs Rename UX-Design-Guidelines to UX-Design-Guidelines.md Nov 8, 2018
extensions Fix a couple a11y issues with manage access (#8386) Nov 19, 2019
i18n Update Lang Pack extension strings from previous refresh (#8229) Nov 6, 2019
remote Bump some packages (#8096) Nov 1, 2019
resources Insiders icons (#8313) Nov 15, 2019
samples bump packages (#8355) Nov 15, 2019
scripts Fix test script overwriting grep option (#8209) Nov 4, 2019
src Fix a couple a11y issues with manage access (#8386) Nov 19, 2019
test Fix test script overwriting grep option (#8209) Nov 4, 2019
.editorconfig Merge VS Code 1.31.1 (#4283) Mar 15, 2019
.eslintrc.json Merge from master Feb 22, 2019
.gitattributes VSCode merge (#4610) Mar 20, 2019
.gitignore Initial LiveShare extension scaffolding (#7170) Sep 11, 2019
.mention-bot SQL Operations Studio Public Preview 1 (0.23) release source code Nov 9, 2017
.nvmrc VSCode merge (#4610) Mar 20, 2019
.prettierrc.json Merge from vscode 64980ea1f3f532c82bb6c28d27bba9ef2c5b4463 (#7206) Sep 16, 2019
.yarnrc Merge from vscode c58aaab8a1cc22a7139b761166a0d4f37d41e998 (#7880) Oct 22, 2019
CHANGELOG.md Update CHANGELOG for 1.13.1 hotfix release (#8342) Nov 15, 2019
CONTRIBUTING.md Merge VS Code 1.31.1 (#4283) Mar 15, 2019
LICENSE.txt Merge Azure Data Studio branding changes (#2689) Sep 24, 2018
README.md Update readme for Nov release (#8193) Nov 4, 2019
ThirdPartyNotices.txt Update ThirdPartyNotices.txt (#7479) Oct 21, 2019
azure-pipelines.yml add triggers for ci (#8197) Nov 2, 2019
cglicenses.json Merge from vscode 1eb87b0e9ce9886afeaecec22b31abd0d9b7939f (#7282) Sep 20, 2019
cgmanifest.json Merge from vscode c58aaab8a1cc22a7139b761166a0d4f37d41e998 (#7880) Oct 22, 2019
extensionsGallery.json Vscode merge (#4582) Mar 20, 2019
gulpfile.js remove some more small differences (#6791) Aug 19, 2019
issue_template.md Merge Azure Data Studio branding changes (#2689) Sep 24, 2018
lgtm.yml Update lgtm.yml (#7932) Oct 23, 2019
package.json distro bump (#8362) Nov 15, 2019
product.json Update iKey (#8353) Nov 15, 2019
runlist.json Test run list proposal (#7617) Oct 19, 2019
tsfmt.json Merge VS Code 1.23.1 (#1520) Jun 5, 2018
tslint-gci.json Change double-quote hygiene rule to tslint rule (#6514) Aug 5, 2019
tslint-sql.json Hygiene linting for extensions + new rule (#7843) Oct 23, 2019
tslint.json Move code around for more linting (#8190) Nov 4, 2019
yarn.lock Remove should (#8196) Nov 4, 2019

README.md

Azure Data Studio

Join the chat at https://gitter.im/Microsoft/sqlopsstudio Build Status Twitter Follow

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=2109256
Windows System Installer https://go.microsoft.com/fwlink/?linkid=2109085
Windows ZIP https://go.microsoft.com/fwlink/?linkid=2109255
macOS ZIP https://go.microsoft.com/fwlink/?linkid=2109180
Linux TAR.GZ https://go.microsoft.com/fwlink/?linkid=2109179
Linux RPM https://go.microsoft.com/fwlink/?linkid=2109178
Linux DEB https://go.microsoft.com/fwlink/?linkid=2109254

Go to our download page for more specific instructions.

Try out the latest insiders build from master:

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.

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:

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.

Localization

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!

Privacy Statement

The Microsoft Enterprise and Developer Privacy Statement describes the privacy statement of this software.

Contributions and "Thank You"

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

  • eulercamposbarros for Prevent connections from moving on click (#7528)
  • AlexFsmn for Fixed issue where task icons got hidden if text was too long
  • jamesrod817 for Tempdb (#7022)
  • dzsquared for fix(snippets): ads parenthesis to sqlcreateindex snippet #7020
  • devmattrick for Update row count as updates are received #6642
  • mottykohn for In Message panel onclick scroll to line #6417
  • Stevoni for Corrected Keyboard Shortcut Execution Issue #5480
  • 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 whoisactive extension
  • 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

License

Copyright (c) Microsoft Corporation. All rights reserved.

Licensed under the Source EULA.

You can’t perform that action at this time.