{"id":7480,"date":"2026-08-19T10:18:32","date_gmt":"2026-08-19T17:18:32","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=7480"},"modified":"2026-08-19T10:18:32","modified_gmt":"2026-08-19T17:18:32","slug":"vscode-mssql-august2026","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/vscode-mssql-august2026\/","title":{"rendered":"MSSQL Extension for VS Code: SQL Formatter, Azure SQL Database Provisioning, and More"},"content":{"rendered":"<p>Writing and maintaining SQL is easier when you can eliminate repetitive steps and keep your scripts cleanly formatted. With the <a href=\"https:\/\/aka.ms\/vscode-mssql\" target=\"_blank\" rel=\"noopener\">MSSQL extension for VS Code<\/a> v1.45, we&#8217;re introducing the <strong>Public Preview of the SQL Formatter<\/strong> alongside the <strong>General Availability of Azure SQL Database Provisioning and Shortcuts Configuration<\/strong>. You can now apply consistent T-SQL formatting across your projects, create free tier cloud databases with automated post-deployment actions, and streamline frequently used commands and queries directly inside Visual Studio Code.<\/p>\n<h2>What&#8217;s new in MSSQL extension for VS Code v1.45<\/h2>\n<p>Here&#8217;s a summary of the key features in this release:<\/p>\n<ul>\n<li><strong>SQL Formatter (Preview)<\/strong>: Format an entire T-SQL document or a selected section on demand, format automatically on save, and customize formatting through Visual Studio Code settings.<\/li>\n<li><strong>Azure SQL Database Provisioning (GA)<\/strong>: Easily create new free tier Azure SQL databases with a single-page wizard, export deployment scripts (ARM, Bicep, Terraform), and run post-deployment actions.<\/li>\n<li><strong>Shortcuts Configuration (GA)<\/strong>: Configure, manage, and launch frequently used SQL queries and MSSQL commands from one unified experience.<\/li>\n<\/ul>\n<h2>SQL Formatter (Preview)<\/h2>\n<p>The new built-in SQL Formatter helps you apply a consistent style to T-SQL directly in Visual Studio Code. Built on <a href=\"https:\/\/github.com\/microsoft\/sqlscriptdom\" target=\"_blank\" rel=\"noopener\">ScriptDOM<\/a>\u2014the open-source .NET library for parsing and generating T-SQL\u2014the formatter can format complete documents or selected statements on demand, or run automatically whenever you save.<\/p>\n<p>Format T-SQL on demand via the editor context menu or the Command Palette (Format Document \/ Format Selection), and standard keyboard shortcuts (<kbd>Shift<\/kbd>+<kbd>Alt<\/kbd>+<kbd>F<\/kbd> on Windows and Linux, or <kbd>Shift<\/kbd>+<kbd>Option<\/kbd>+<kbd>F<\/kbd> on macOS).<\/p>\n<h3>Key highlights<\/h3>\n<ul>\n<li><strong>Format on demand and on save<\/strong>: Format entire SQL documents or selected snippets manually, or enable automatic formatting on save with standard Visual Studio Code editor settings.<\/li>\n<li><strong>Customizable casing and alignment<\/strong>: Adjust keyword casing (uppercase, lowercase, Pascal case), align clause bodies and column definitions, and configure statement line breaks.<\/li>\n<li><strong>Multiline list formatting<\/strong>: Control line breaks and indentation for <code>SELECT<\/code> elements, <code>INSERT<\/code> columns and values, <code>WHERE<\/code> predicates, and <code>SET<\/code> clauses.<\/li>\n<li><strong>Preserve comments and notify on parse errors<\/strong>: Keep existing code comments intact and receive clear notifications if syntax errors prevent formatting.<\/li>\n<\/ul>\n<p>For full documentation, see <a href=\"https:\/\/aka.ms\/vscode-mssql-sql-formatter\" target=\"_blank\" rel=\"noopener\">SQL formatter<\/a>.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/08\/settings-formatter.webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7481\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/08\/settings-formatter.webp\" alt=\"settings formatter image\" width=\"1201\" height=\"808\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/08\/settings-formatter.webp 1201w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/08\/settings-formatter-300x202.webp 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/08\/settings-formatter-1024x689.webp 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/08\/settings-formatter-768x517.webp 768w\" sizes=\"(max-width: 1201px) 100vw, 1201px\" \/><\/a><\/p>\n<div>\n<h2>Azure SQL Database Provisioning (GA)<\/h2>\n<p>Azure SQL Database provisioning is now generally available, giving developers an easy, guided way to create a fully managed free tier Azure SQL database directly from Visual Studio Code at no cost.<\/p>\n<p>Access the wizard by opening the <strong>Deployments<\/strong> view from the MSSQL Activity Bar and selecting <strong>Create an Azure SQL Database<\/strong>. Configure your subscription, resource group, logical server, and database on a single page, and choose your preferred limit behavior (auto-pause or continue at serverless rates). Your database connection is added automatically the moment provisioning completes.<\/p>\n<p><!-- Add Azure SQL Database provisioning screenshot here after uploading --><\/p>\n<h3>Key highlights<\/h3>\n<ul>\n<li><strong>Free tier cloud database<\/strong>: Provision a fully managed Azure SQL database at zero cost for prototyping, proof-of-concept projects, or dev\/test workloads.<\/li>\n<li><strong>Post-deployment actions<\/strong>: Instantly copy connection strings and migration commands from the completion screen to jumpstart application development.<\/li>\n<li><strong>Download deployment scripts<\/strong>: Export ready-to-use Infrastructure-as-Code templates in ARM, Bicep, and Terraform formats to replicate deployments across teams and environments.<\/li>\n<\/ul>\n<p>For full documentation, see <a href=\"https:\/\/learn.microsoft.com\/sql\/tools\/visual-studio-code-extensions\/mssql\/mssql-azure-integration\" target=\"_blank\" rel=\"noopener\">Create an Azure SQL Database (Free Tier)<\/a>.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/azuresqldb-ga.webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7484\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/azuresqldb-ga.webp\" alt=\"azuresqldb ga image\" width=\"1100\" height=\"617\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/azuresqldb-ga.webp 1100w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/azuresqldb-ga-300x168.webp 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/azuresqldb-ga-1024x574.webp 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/azuresqldb-ga-768x431.webp 768w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" \/><\/a><\/p>\n<h2>Shortcuts Configuration (GA)<\/h2>\n<p>Shortcuts Configuration is now generally available, providing a centralized experience for discovering, configuring, and managing shortcuts across the MSSQL extension. Use it to save reusable SQL queries, assign the keybindings that fit your workflow, and quickly find commonly used commands for the query editor and results view.<\/p>\n<p>Open the experience by selecting <strong>Open Shortcuts Configuration<\/strong> from the MSSQL extension toolbar.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-entry.webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7257\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-entry.webp\" alt=\"Open Shortcuts Configuration from the MSSQL extension toolbar\" width=\"517\" height=\"130\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-entry.webp 517w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-entry-300x75.webp 300w\" sizes=\"(max-width: 517px) 100vw, 517px\" \/><\/a><\/p>\n<h3>Key highlights<\/h3>\n<ul>\n<li><strong>Quick Queries<\/strong>: Save frequently used T-SQL snippets and run them with custom keyboard shortcuts, reducing repetitive work for common database tasks.<\/li>\n<li><strong>Selected text insertion<\/strong>: Insert selected query-editor text anywhere in your query using the <code>{arg}<\/code> placeholder. If you don&#8217;t use the placeholder, selected text is automatically appended to the end of the query.<\/li>\n<li><strong>Run or review<\/strong>: Choose whether a Quick Query runs immediately or opens in the query editor so you can review and modify it first.<\/li>\n<li><strong>Query Editor shortcuts<\/strong>: Discover and customize commonly used MSSQL commands for query execution, connections, and other editor actions.<\/li>\n<li><strong>Results View shortcuts<\/strong>: View the available keybindings for navigating and working with query results.<\/li>\n<li><strong>Visual Studio Code integration<\/strong>: Assign and manage custom keybindings through the standard Visual Studio Code Keyboard Shortcuts editor.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-queries.webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7258\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-queries.webp\" alt=\"Configure reusable Quick Queries and keyboard shortcuts\" width=\"2027\" height=\"1019\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-queries.webp 2027w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-queries-300x151.webp 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-queries-1024x515.webp 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-queries-768x386.webp 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/07\/shortcuts-configuration-queries-1536x772.webp 1536w\" sizes=\"(max-width: 2027px) 100vw, 2027px\" \/><\/a><\/p>\n<p>For full documentation, see <a href=\"https:\/\/aka.ms\/vscode-mssql-shortcuts-configuration\" target=\"_blank\" rel=\"noopener\">Shortcuts Configuration<\/a>.<\/p>\n<\/div>\n<div>\n<h2>Conclusion<\/h2>\n<p>The MSSQL extension for VS Code v1.45 delivers features that streamline development and simplify database management. The new <strong>SQL Formatter<\/strong> preview gives you flexible, ScriptDOM-based formatting on demand or whenever you save, while <strong>Azure SQL Database Provisioning<\/strong> and <strong>Shortcuts Configuration<\/strong> are now generally available to help you spin up free tier cloud databases effortlessly and customize keybindings.<\/p>\n<p>If there&#8217;s something you&#8217;d love to see in a future update, here&#8217;s how you can contribute:<\/p>\n<ul>\n<li>\ud83d\udcac <a href=\"https:\/\/aka.ms\/vscode-mssql-discussions\">GitHub discussions<\/a> \u2013 Share your ideas and suggestions to improve the extension<\/li>\n<li>\u2728 <a href=\"https:\/\/aka.ms\/vscode-mssql-feature-request\">New feature requests<\/a> \u2013 Request missing capabilities and help shape future updates<\/li>\n<li>\ud83d\udc1e <a href=\"https:\/\/aka.ms\/vscode-mssql-bug\">Report bugs<\/a> \u2013 Help us track down and fix issues to make the extension more reliable<\/li>\n<\/ul>\n<p>If you&#8217;d like to learn more about the MSSQL extension, you can:<\/p>\n<ul>\n<li>\ud83c\udfac\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-demos\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Watch the demos<\/a>: Explore key features through our YouTube playlist<\/li>\n<li>\ud83e\udd16\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-copilot-demos\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Watch the GitHub Copilot demos<\/a>: Learn how to use GitHub Copilot to write, explain, and refactor your database schema<\/li>\n<li>\ud83d\udcdd\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-blogs\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Read the blog posts<\/a>: Learn from use cases, walkthroughs, and product updates<\/li>\n<li>\ud83d\udcd6\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-docs\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Read the documentation<\/a>: Get started or go deep with our official docs<\/li>\n<li>\ud83d\uddfa\ufe0f\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-roadmap#2026\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Check out the roadmap<\/a>: See what&#8217;s coming next, including upcoming features and improvements<\/li>\n<\/ul>\n<p>Thanks for being part of the journey\u2014happy coding! \ud83d\ude80<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Writing and maintaining SQL is easier when you can eliminate repetitive steps and keep your scripts cleanly formatted. With the MSSQL extension for VS Code v1.45, we&#8217;re introducing the Public Preview of the SQL Formatter alongside the General Availability of Azure SQL Database Provisioning and Shortcuts Configuration. You can now apply consistent T-SQL formatting across [&hellip;]<\/p>\n","protected":false},"author":187531,"featured_media":81,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7480","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql"],"acf":[],"blog_post_summary":"<p>Writing and maintaining SQL is easier when you can eliminate repetitive steps and keep your scripts cleanly formatted. With the MSSQL extension for VS Code v1.45, we&#8217;re introducing the Public Preview of the SQL Formatter alongside the General Availability of Azure SQL Database Provisioning and Shortcuts Configuration. You can now apply consistent T-SQL formatting across [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/users\/187531"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=7480"}],"version-history":[{"count":1,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7480\/revisions"}],"predecessor-version":[{"id":7485,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7480\/revisions\/7485"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/81"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=7480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=7480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=7480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}