{"id":4631,"date":"2025-05-19T09:00:24","date_gmt":"2025-05-19T16:00:24","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=4631"},"modified":"2025-07-18T13:00:34","modified_gmt":"2025-07-18T20:00:34","slug":"vscode-mssql-copilot-preview-ui-ga","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/vscode-mssql-copilot-preview-ui-ga\/","title":{"rendered":"MSSQL Extension for VS Code: New UI Goes GA and GitHub Copilot Enters Preview"},"content":{"rendered":"<p>The SQL development experience is taking a major leap forward with the <a href=\"http:\/\/aka.ms\/vscode-mssql\" target=\"_blank\" rel=\"noopener\"><span class=\"s1\"><b>MSSQL Extension for VS Code<\/b><\/span><\/a>.<\/p>\n<p class=\"p3\">The MSSQL extension is evolving to meet the needs of modern developers, bringing powerful, intelligent, and intuitive capabilities directly into your daily workflow. With this release, we\u2019re announcing the <span class=\"s1\"><b>general availability of the enhanced UI<\/b><\/span> and the <span class=\"s1\"><b>public preview of GitHub Copilot integration<\/b><\/span>. Together, these updates streamline how developers connect to databases, write queries, and manage schema objects\u2014whether you\u2019re working locally with SQL Server 2025 or in the cloud with Azure SQL or SQL Database in Fabric.<\/p>\n<p class=\"p3\"><span class=\"s1\">As part of our broader effort<\/span>, this release continues to transform SQL development in VS Code. While the new Schema Designer debuts alongside these updates, we\u2019ll cover it separately <a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/vs-code-mssql-schema-designer\" target=\"_blank\" rel=\"noopener\">in an upcoming post<\/a>.<\/p>\n<h2><b>A modern SQL development experience, now generally available<\/b><\/h2>\n<p class=\"p1\">The enhanced UI in the MSSQL extension\u2014first introduced in preview and <a href=\"https:\/\/github.com\/microsoft\/vscode-mssql\/releases\/tag\/v1.30.0\" target=\"_blank\" rel=\"noopener\">made default in <span class=\"s1\">v1.30<\/span><\/a>\u2014is now officially <span class=\"s1\"><b>generally available<\/b><\/span>. Over the past several months, these experiences have been refined based on community feedback to deliver a faster, more intuitive way to work with SQL in Visual Studio Code.<\/p>\n<h3><b>What\u2019s included in the GA release:<\/b><\/h3>\n<ul>\n<li class=\"p1\"><span class=\"s1\"><b>Connection Dialog<\/b><\/span>: Quickly connect to local or cloud databases using parameters, connection strings, or Azure browsing. Easily access saved and recent connections.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Object Explorer<\/b><\/span>: Navigate complex database hierarchies with advanced filtering by object type, name, and schema.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Table Designer<\/b><\/span>: Visually build or update tables, define relationships and constraints, and publish schema changes with a T-SQL preview.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Query Results Pane<\/b><\/span>: Export, sort, and inspect query results in-grid or in a new tab. Includes Estimated and Actual Execution Plan buttons for performance analysis.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Query Plan Visualizer<\/b><\/span>: Explore query execution plans with zoom, metrics, and node-level insights to help you identify and resolve performance bottlenecks.<\/li>\n<\/ul>\n<p class=\"p1\">As of this release, these features no longer require preview settings or feature flags. In other words, if you\u2019re already using the extension, the new UI is available immediately upon update.<\/p>\n<h2><b>GitHub Copilot is now integrated with the MSSQL extension (Preview)<\/b><\/h2>\n<p class=\"p3\">In parallel with the UI GA release, <strong>GitHub Copilot integrates with the MSSQL extension for Visual Studio Code<\/strong>. This integration brings AI-assisted development into your SQL workflows. Available as a Public Preview, this integration helps developers write, understand, and optimize SQL code faster\u2014whether you\u2019re working with raw T-SQL or modern ORMs. Since it\u2019s available as a Public Preview<span class=\"s1\">, you can start using it right away.<\/span><\/p>\n<p class=\"p3\">Importantly, we have designed this experience specifically with developers in mind\u2014especially those who work code-first or may not have deep T-SQL expertise. GitHub Copilot adapts to your database schema and open files to offer contextual suggestions and explanations.<\/p>\n<h3><b>What you can do with GitHub Copilot:<\/b><\/h3>\n<ul>\n<li class=\"p1\"><span class=\"s1\"><b>Chat with @mssql<\/b><\/span>: Ask natural language questions to generate queries, explain logic, scaffold tables, or debug stored procedures\u2014all grounded in your connected database.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Inline Suggestions<\/b><\/span>: Get real-time completions while writing SQL or ORM code, including Sequelize, Prisma, SQLAlchemy, and Entity Framework.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Schema Design and Exploration<\/b><\/span>: Create, update, and reverse-engineer schemas using conversational or code-based prompts.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Query Optimization<\/b><\/span>: Receive AI-driven suggestions to refactor slow queries, improve indexing, and analyze execution plans.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Understand Business Logic<\/b><\/span>: Let GitHub Copilot explain stored procedures, views, and functions\u2014ideal for onboarding or working with legacy code.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Security Analyzer<\/b><\/span>: Identify vulnerable patterns like SQL injection and get safer alternatives in context.<\/li>\n<li class=\"p1\"><span class=\"s1\"><b>Mock and Test Data Generation<\/b><\/span>: Automatically generate sample data based on your schema for prototyping and testing.<\/li>\n<\/ul>\n<p class=\"p3\">GitHub Copilot actively uses your database connection and open files to deliver tailored assistance. To get the most out of it, connect to a database and work within SQL or ORM files.<\/p>\n<p class=\"p1\">For additional guidance, check out the <a href=\"https:\/\/aka.ms\/vscode-mssql-copilot-docs\" target=\"_blank\" rel=\"noopener\">official documentation<\/a> or watch the <a href=\"https:\/\/aka.ms\/vscode-mssql-copilot-demo\" target=\"_blank\" rel=\"noopener\">demo video<\/a> to see GitHub Copilot in action.<\/p>\n<h2><b>Get started with GitHub Copilot\n<\/b><\/h2>\n<p class=\"p1\">It\u2019s easy to try the enhanced UI and GitHub Copilot integration in the MSSQL extension\u2014no setup scripts, no configuration needed. Follow these steps:<\/p>\n<ol>\n<li class=\"p1\"><a href=\"https:\/\/aka.ms\/vscode-mssql-marketplace\" target=\"_blank\" rel=\"noopener\">Install or update the MSSQL extension for Visual Studio Code<\/a>.<\/li>\n<li class=\"p1\">Connect to any database, local or cloud (SQL Database in Fabric, Azure SQL, or SQL Server 2025 (Public Preview) or prior).<\/li>\n<li class=\"p1\">If you have a <a href=\"https:\/\/github.com\/features\/copilot\" target=\"_blank\" rel=\"noopener\">GitHub Copilot subscription<\/a>, sign in. That\u2019s it\u2014Copilot works automatically based on your connected database and active SQL or ORM files.<\/li>\n<li class=\"p1\">To start chatting, <span class=\"s1\"><b>right-click any database<\/b><\/span> in the Object Explorer and select <span class=\"s1\"><b>\u201cChat with this database.\u201d<\/b><\/span><\/li>\n<\/ol>\n<p style=\"padding-left: 40px\"><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-chat-database-context-menu.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4651\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-chat-database-context-menu.png\" alt=\"vscode chat database context menu image\" width=\"585\" height=\"530\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-chat-database-context-menu.png 585w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-chat-database-context-menu-300x272.png 300w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/a><\/p>\n<p class=\"p1\" style=\"padding-left: 40px\">This opens a connected chat session with the Azure SQL Copilot agent, ready to assist with queries, schema design, optimization, and more.<\/p>\n<p style=\"padding-left: 40px\"><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-copilot-chat-window.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4650\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-copilot-chat-window.png\" alt=\"vscode copilot chat window image\" width=\"1904\" height=\"1039\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-copilot-chat-window.png 1904w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-copilot-chat-window-300x164.png 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-copilot-chat-window-1024x559.png 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-copilot-chat-window-768x419.png 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/05\/vscode-copilot-chat-window-1536x838.png 1536w\" sizes=\"(max-width: 1904px) 100vw, 1904px\" \/><\/a><\/p>\n<p><div class=\"alert alert-success\"><p class=\"alert-divider\"><i class=\"fabric-icon fabric-icon--Lightbulb\"><\/i><strong>Getting Started with the MSSQL extension in VS Code<\/strong><\/p> Check out the <a href=\"https:\/\/aka.ms\/vscode-mssql-docs\" target=\"_blank\" rel=\"noopener\">official documentation<\/a> for detailed information and quickstarts on every feature, or catch our latest livestream on the <a href=\"https:\/\/youtu.be\/7axbKTpwF1c\" target=\"_blank\" rel=\"noopener\">VS Code YouTube channel<\/a>.<\/div><\/p>\n<h2><b>Conclusion<\/b><\/h2>\n<p class=\"p1\">This release marks a significant step forward in the SQL developer experience inside VS Code\u2014bringing a modern, streamlined UI and AI-assisted capabilities together in a single tool built for developers.<\/p>\n<p class=\"p1\">As we continue evolving the extension, your feedback plays a critical role. If you try GitHub Copilot with the MSSQL extension, we\u2019d love to hear from you:<\/p>\n<ul>\n<li>\ud83e\udd16 <a href=\"https:\/\/aka.ms\/vscode-mssql-copilot-feedback\" target=\"_blank\" rel=\"noopener\">GitHub Copilot feedback form<\/a> &#8211; Share your experience using GitHub Copilot with the MSSQL extension<\/li>\n<li>\ud83d\udcac <a href=\"https:\/\/aka.ms\/vscode-mssql-discussions\" target=\"_blank\" rel=\"noopener\">GitHub discussions<\/a> &#8211; Share your ideas and suggestions to improve the extension<\/li>\n<\/ul>\n<p class=\"p1\">This is just the beginning\u2014we\u2019re building a modern SQL development experience for real-world workflows, and your input helps drive what comes next.<\/p>\n<p>Happy coding!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SQL development experience is taking a major leap forward with the MSSQL Extension for VS Code. The MSSQL extension is evolving to meet the needs of modern developers, bringing powerful, intelligent, and intuitive capabilities directly into your daily workflow. With this release, we\u2019re announcing the general availability of the enhanced UI and the public [&hellip;]<\/p>\n","protected":false},"author":132338,"featured_media":4670,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,669,668,625],"tags":[529,449,670,638,558,682],"class_list":["post-4631","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","category-github-copilot","category-sql-database-in-fabric","category-vs-code","tag-azure-sql","tag-development","tag-github-copilot","tag-sql-database-in-fabric","tag-vs-code","tag-vscode-mssql"],"acf":[],"blog_post_summary":"<p>The SQL development experience is taking a major leap forward with the MSSQL Extension for VS Code. The MSSQL extension is evolving to meet the needs of modern developers, bringing powerful, intelligent, and intuitive capabilities directly into your daily workflow. With this release, we\u2019re announcing the general availability of the enhanced UI and the public [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/4631","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=4631"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/4631\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/4670"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=4631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=4631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=4631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}