Azure Data Studio

Obtain the skills to connect and query various databases, including SQL Server, Azure SQL Database, PostgreSQL, MySQL, and more.

About Azure Data Studio

Overview

• What is Azure Data Studio?
• Azure connectivity

Download

• Download Azure Data Studio
• Azure Data Studio Release Notes

Quickstarts

Quickstart

• Connect and query data in SQL Server
• Connect and query data in Azure SQL database
• Connect and query data in Azure Synapse Analytics
• Connect and query data in MySQL
• Connect and query data in PostgreSQL

Azure Data Studio features

How-To Guide

• Connect
• Manage servers and databases with Insight widgets in Azure Data Studio
• Create and use code snippets
• Explore and manage Azure SQL resources
• Create and edit keyboard shortcuts
• Enable or disable usage data collection
• Enable Kerberos
• Modify User and Workspace Settings

Notebooks

How-To Guide

• Notebooks in Azure Data Studio
• SQL Kernel
• Python Kernel
• Kusto Kernel
• Kqlmagic in Azure Data Studio

Extensions

Concept

• Extend the functionality of Azure Data Studio
• GitHub Copilot extension
• Kusto Query Language (KQL)
• MySQL extension
• PostgreSQL extension
• SandDance extension
• \"Schema Compare\" extension
• SQL Database projects extension
• SQL Server Import extension
• SQL Server Profiler extension

Migration extensions

Concept

• Azure SQL migration extension
• Azure PostgreSQL migration extension
• Database Migration Assessment for Oracle
• Azure Cosmos DB migration for MongoDB
• Database Schema Conversion Toolkit