November 17th, 2026
0 reactions

MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more

A local database is a useful starting point, but deploying it and understanding how queries behave should fit into the same development workflow. The MSSQL extension for VS Code v1.48 brings three new public previews: Azure SQL Database local container provisioning, a local-to-cloud deployment wizard, and the Query Performance Dashboard. This November release also expands the preview query results experience and includes improvements to connection organization and Data API builder.

🎬 Watch YouTube demo:

MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more

What’s new in MSSQL extension for VS Code v1.48

Here’s a summary of the key features in this release:

  • Azure SQL Database local container provisioning (Preview): Develop against the Azure SQL Database engine locally, without an Azure subscription.
  • Local-to-cloud deployment wizard (Preview): Check compatibility and deploy a local database’s schema, or schema and data, to a new Azure SQL Database.
  • Query Performance Dashboard (Preview): Investigate Query Store history, resource-intensive queries, waits, and execution plans from the editor.
  • Multi-results grid and live query statistics (Preview): Compare results across query files and inspect execution progress while a query runs.
  • Nested connection groups: Organize connections into a hierarchy that matches your projects and environments.
  • Data API builder improvements: Redeploy updated APIs and run them locally with the DAB CLI, including Microsoft Entra authentication.

Azure SQL Database local container provisioning (Preview)

Build and test locally with the Azure SQL Database container, which runs the Azure SQL Database engine rather than the SQL Server container image. It is free for local development and testing, requires no Azure subscription or credit card, and works with the drivers and ORMs you use for Azure SQL Database.

In Connections, select New Deployment, then Azure SQL Database container (Preview). The wizard checks your runtime, downloads the image, starts the engine, and saves a connection. Supported runtimes include Docker, Podman, containerd with nerdctl, and WSL containers on Windows.

mssql azuresqlcontainerprovisioning image

Key highlights

  • Develop against the Azure SQL engine: Use Azure SQL Database T-SQL locally with your existing application data access tools.
  • No cloud account needed: Start local development without creating Azure resources or providing a credit card.
  • x64 and ARM support: Run the preview on supported devices across both architectures.
  • Guided setup: Provision the container and save its connection without writing container commands.
  • Manage from VS Code: Start, stop, reconnect to, and delete the container from the extension.

The container is a local development environment, not the managed Azure service. Test cloud-specific behavior against Azure SQL Database before deploying your application.

For full documentation, see Local Azure SQL Database and SQL Server containers.

Local-to-cloud deployment wizard (Preview)

Move a local development database to a new free-tier Azure SQL database with the local-to-cloud deployment wizard. Choose schema only or schema and data; the extension creates and deploys the DACPAC or BACPAC. Your local database and container stay unchanged.

Select New Deployment in Connections, then Local database to Azure SQL Database (Preview), or right-click a local database and choose Deploy database to Azure SQL (Preview). A running local database and an Azure subscription with resource-creation permissions are required.

mssql localtocloud image

Key highlights

  • Choose what to copy: Deploy database objects alone or include the rows in your tables.
  • Check compatibility first: Validate the schema against an Azure SQL Database target before creating cloud resources.
  • Configure the destination: Choose a subscription, resource group, logical server, and database in the wizard.
  • Connect after deployment: The extension verifies deployment and saves the Azure SQL connection for continued development.

For full documentation, see Deploy a local database to Azure SQL.

Query Performance Dashboard (Preview)

The Query Performance Dashboard brings historical Query Store data into VS Code, helping you move from a database-wide view of expensive queries to execution history, waits, and execution plans.

Right-click a database in Connections and select Open Query Performance Dashboard (Preview). Query Store must be enabled and have captured workload data, and your account needs permission to read it.

mssql queryperfdashboard image

Key highlights

  • Find resource-intensive queries: Explore high CPU, memory grants, duration, execution frequency, and logical reads, with ranking and time-range controls.
  • Investigate history and waits: Review trends and, where Query Store wait capture is supported and enabled, investigate wait categories.
  • Compare against a baseline: Compare CPU time or memory grants with an earlier period to investigate changes in resource use.
  • Inspect and compare plans: Open captured execution plans or select two plans for side-by-side comparison.
  • Continue in GitHub Copilot Chat: Send the query and investigation context to agent mode for a performance assessment, with confirmation required before applying changes.

For full documentation, see Query Performance Dashboard overview.

Other improvements

Multi-results grid (Preview)

The multi-results layout lets you compare query files’ results side by side, retain results after closing editors, and choose whether results follow the active editor. Enable mssql.preview.multiResults or select Multi-Results Layout in Query Results.

Live query statistics (Preview)

Live query statistics shows row counts, estimated progress, and elapsed time while a query runs. Preview commands are enabled by default; select MSSQL: Enable Live Query Statistics in a connected SQL editor before executing the query.

Nested connection groups

Nested connection groups organize connections by project, team, or environment. Choose a Parent group when creating or editing a group, or drag connections and groups into place in Connections.

Data API builder improvements

Data API builder adds smoother redeployment and local CLI workflows:

  • Review and redeploy: Select View changes to review configuration updates, then Apply changes to redeploy.
  • Run without Docker: Select Data API builder CLI to run the API locally. The extension prepares the CLI and required .NET runtime.
  • Microsoft Entra database authentication: The CLI workflow supports browser or device-code sign-in through Azure CLI to authenticate DAB to the database. API caller authentication is configured separately.

Next steps

If there’s something you’d love to see in a future update, here’s how you can contribute:

  • 💬 GitHub discussions – Share your ideas and suggestions to improve the extension
  • ✨ New feature requests – Request missing capabilities and help shape future updates
  • 🐞 Report bugs – Help us track down and fix issues to make the extension more reliable

If you’d like to learn more about the MSSQL extension, you can:

Thanks for being part of the journey—happy coding! 🚀

Author

0 comments