{"id":5941,"date":"2025-09-17T09:00:09","date_gmt":"2025-09-17T16:00:09","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=5941"},"modified":"2025-09-17T09:00:09","modified_gmt":"2025-09-17T16:00:09","slug":"vscode-mssql-fabric-copilot","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/vscode-mssql-fabric-copilot\/","title":{"rendered":"MSSQL Extension for VS Code: Fabric Integration and GitHub Copilot Slash Commands (Public Preview)"},"content":{"rendered":"<p>The <a href=\"http:\/\/aka.ms\/vscode-mssql\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"aka.ms\/vscode-mssql\"><strong>MSSQL Extension for VS Code<\/strong><\/a> continues to evolve,\u00a0delivering features that make SQL development more integrated, more consistent, and more developer-friendly. In version v1.36.0, we\u2019re announcing the <span class=\"s1\">Public Preview of <b>Fabric Connectivity (Browse)<\/b><\/span>, <span class=\"s1\"><b>SQL Database in Fabric Provisioning<\/b><\/span>, and <span class=\"s1\"><b>GitHub Copilot Slash Commands<\/b><\/span> \u2014 three capabilities that bring Microsoft Fabric and AI-powered assistance directly into your development workflow inside Visual Studio Code.<\/p>\n<h2 id=\"what\u2019s-new-in-mssql-extension-for-vs-code-v1.33\"><b>What\u2019s new in MSSQL extension for VS Code v1.36<\/b><\/h2>\n<p class=\"p1\">This release introduces three major capabilities designed to streamline the SQL development experience:<\/p>\n<ul>\n<li class=\"p1\"><span class=\"s1\"><b>Fabric Connectivity (Public Preview)<\/b><\/span> \u2014 Browse and connect to Fabric workspaces directly from the Connection dialog using Microsoft Entra ID, with tree-view navigation and search.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>SQL Database in Fabric Provisioning (Public Preview)<\/b><\/span> \u2014 Create new SQL databases in Fabric directly from the Deployments page, with instant connection in VS Code.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>GitHub Copilot Slash Commands (Public Preview)<\/b><\/span> \u2014 Use structured slash commands in GitHub Copilot Agent Mode to connect, explore schemas, and run queries directly from chat.<\/li>\n<\/ul>\n<p class=\"p3\">In addition to these major features, this release includes multiple quality and performance improvements:<\/p>\n<ul>\n<li class=\"p1\">Enhanced performance and usability of the query results grid.<\/li>\n<li class=\"p1\">Fixed accessibility issues affecting error messages and UI feedback.<\/li>\n<li class=\"p1\">Addressed edge case errors in GitHub Copilot Agent Mode when switching connections.<\/li>\n<\/ul>\n<h3><b>Fabric Connectivity (Public Preview)<\/b><\/h3>\n<p class=\"p1\">The MSSQL extension for Visual Studio Code now includes Fabric connectivity, making it easier than ever to browse and connect to your Fabric workspaces directly from your development environment. This new integration eliminates the friction of connection strings and brings Fabric resources into the familiar VS Code experience.<\/p>\n<p class=\"p1\">With this update, you can authenticate once, browse all your workspaces in an intuitive tree view, and establish connections to your Fabric resources in just a few clicks\u2014all without leaving VS Code.<\/p>\n<h4><strong>Key highlights<\/strong><\/h4>\n<ul>\n<li><span class=\"s1\"><b>Dedicated Fabric Experience<\/b><\/span> \u2013 A new \u201cFabric\u201d connection type joins the existing \u201cParameters\u201d and \u201cAzure\u201d options in the connection dialog.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Seamless Authentication<\/b><\/span> \u2013 Leverage Microsoft Entra ID for secure, one-click authentication with persistent sign-in.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Intelligent Workspace Browsing<\/b><\/span> \u2013 Explore Fabric workspaces in an intuitive tree view that loads resources on-demand.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Smart Search &amp; Discovery<\/b><\/span> \u2013 Find workspaces quickly with real-time search and relevant results at the top.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Cross-extension Support<\/b><\/span> \u2013 Use the \u201cOpen in MSSQL\u201d option directly from the Fabric extension or Portal.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/browseblurred.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-6057\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/browseblurred.png\" alt=\"browseblurred image\" width=\"815\" height=\"804\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/browseblurred.png 815w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/browseblurred-300x296.png 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/browseblurred-768x758.png 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/browseblurred-24x24.png 24w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/browseblurred-48x48.png 48w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/browseblurred-96x96.png 96w\" sizes=\"(max-width: 815px) 100vw, 815px\" \/><\/a><\/p>\n<h3><b>SQL database in Fabric Provisioning (Public Preview)<\/b><\/h3>\n<p class=\"p1\">With Fabric Provisioning, you can now create SQL databases in Fabric without leaving VS Code. The new provisioning flow allows you to authenticate, select or create a workspace, name your database, and connect instantly\u2014all in under three minutes.<\/p>\n<p class=\"p1\">By bringing provisioning directly into the Deployments page, this experience eliminates the need to use the Fabric Portal or Azure Portal, reducing context switching and making early prototyping significantly faster.<\/p>\n<h4><strong>Key highlights<\/strong><\/h4>\n<ul>\n<li class=\"p1\"><span class=\"s1\"><b>Simple Provisioning Flow<\/b><\/span> \u2013 Authenticate, select or create a workspace, name your database, and create.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Immediate Connection<\/b><\/span> \u2013 The new database is automatically added to your connections for instant querying.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Consistent Experience<\/b><\/span> \u2013 Provisioning flow aligns with other backend options, like local SQL Server containers.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Capacity Awareness<\/b><\/span> \u2013 Disabled workspaces are clearly shown with guidance if capacity isn\u2019t available.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/fabric-provisioning.gif\"><img decoding=\"async\" class=\"alignnone size-full wp-image-6031\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/fabric-provisioning.gif\" alt=\"fabric provisioning image\" width=\"1920\" height=\"1080\" \/><\/a><\/p>\n<h3><b>GitHub Copilot Slash Commands (Public Preview)<\/b><\/h3>\n<p class=\"p1\">The MSSQL extension now contributes <span class=\"s1\"><b>slash commands<\/b><\/span> to GitHub Copilot Agent Mode, giving you a faster, more structured way to interact with your databases directly in chat. Instead of typing full prompts, you can invoke commands like <span class=\"s2\" style=\"font-family: andale mono, monospace\">\/connect<\/span>, <span class=\"s2\" style=\"font-family: andale mono, monospace\">\/listDatabases<\/span>, or <span class=\"s2\" style=\"font-family: andale mono, monospace\">\/runQuery<\/span> to perform common tasks with less effort and greater predictability.<\/p>\n<h4><strong>Key highlights<\/strong><\/h4>\n<ul>\n<li class=\"p1\"><span class=\"s1\"><b>Connection management<\/b><\/span> \u2013 Establish, switch, or disconnect database connections with structured commands.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Schema exploration<\/b><\/span> \u2013 List schemas, tables, views, functions, or generate schema diagrams directly in chat.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Query execution<\/b><\/span> \u2013 Run queries or request optimizations with simple commands.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/slash-command-change-database.gif\"><img decoding=\"async\" class=\"alignnone size-full wp-image-6032\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/09\/slash-command-change-database.gif\" alt=\"slash command change database image\" width=\"1920\" height=\"1080\" \/><\/a><\/p>\n<h3><b>Other updates<\/b><\/h3>\n<ul>\n<li class=\"p1\"><span class=\"s1\"><b>Connection reliability<\/b><\/span> \u2013 Fixed issues that prevented users from establishing connections.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Fabric connectivity stability<\/b><\/span> \u2013 Resolved query failures when working with Fabric tables.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Authentication persistence<\/b><\/span> \u2013 Fixed a bug where saved passwords were lost after failed connections.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Performance &amp; memory<\/b><\/span> \u2013 Addressed excessive memory usage and unresponsive queries.<\/li>\n<\/ul>\n<h2>Conclusion<\/h2>\n<p class=\"p1\">The v1.36 release marks a major milestone by introducing <span class=\"s1\">Fabric Connectivity (Browse)<\/span>, <span class=\"s1\">SQL Database in Fabric Provisioning<\/span>, and <span class=\"s1\">GitHub Copilot Slash Commands<\/span> in Public Preview. Together, these capabilities simplify connectivity, accelerate prototyping, and bring AI-powered assistance directly into your SQL development workflows in VS Code. Combined with important reliability fixes, this update makes the MSSQL extension more powerful, stable, and developer-friendly than ever.<\/p>\n<p>If there\u2019s something you\u2019d love to see in a future update, here\u2019s how you can contribute:<\/p>\n<ul>\n<li>\ud83d\udcac <a href=\"https:\/\/aka.ms\/vscode-mssql-discussions\" target=\"_blank\" rel=\"noopener\">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\" target=\"_blank\" rel=\"noopener\">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\" target=\"_blank\" rel=\"noopener\">Report bugs<\/a> \u2013 Help us track down and fix issues to make the extension more reliable<\/li>\n<\/ul>\n<p class=\"p1\">Want to see these features in action?<\/p>\n<ul>\n<li class=\"p1\"><a href=\"https:\/\/aka.ms\/vscode-mssql-fabric-browse-demo\" target=\"_blank\" rel=\"noopener\">Fabric Connectivity demo<\/a><\/li>\n<li><a href=\"https:\/\/aka.ms\/vscode-mssql-fabric-db-demo\" target=\"_blank\" rel=\"noopener\">SQL database in Fabric provisioning demo<\/a><\/li>\n<li class=\"p1\"><a href=\"https:\/\/aka.ms\/vscode-mssql-demos\" target=\"_blank\" rel=\"noopener\">Full playlist of demos<\/a><\/li>\n<\/ul>\n<p>Thanks for being part of the journey\u2014happy coding! \ud83d\ude80<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The MSSQL Extension for VS Code continues to evolve,\u00a0delivering features that make SQL development more integrated, more consistent, and more developer-friendly. In version v1.36.0, we\u2019re announcing the Public Preview of Fabric Connectivity (Browse), SQL Database in Fabric Provisioning, and GitHub Copilot Slash Commands \u2014 three capabilities that bring Microsoft Fabric and AI-powered assistance directly into [&hellip;]<\/p>\n","protected":false},"author":132338,"featured_media":6060,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,669,570,668,625],"tags":[694,670,637,638,682],"class_list":["post-5941","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","category-github-copilot","category-microsoft-fabric","category-sql-database-in-fabric","category-vs-code","tag-connectivity","tag-github-copilot","tag-microsoft-fabric","tag-sql-database-in-fabric","tag-vscode-mssql"],"acf":[],"blog_post_summary":"<p>The MSSQL Extension for VS Code continues to evolve,\u00a0delivering features that make SQL development more integrated, more consistent, and more developer-friendly. In version v1.36.0, we\u2019re announcing the Public Preview of Fabric Connectivity (Browse), SQL Database in Fabric Provisioning, and GitHub Copilot Slash Commands \u2014 three capabilities that bring Microsoft Fabric and AI-powered assistance directly into [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/5941","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\/132338"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=5941"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/5941\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/6060"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=5941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=5941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=5941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}