{"id":61268,"date":"2025-08-11T11:08:07","date_gmt":"2025-08-11T11:08:07","guid":{"rendered":"https:\/\/www.newsbeep.com\/ca\/61268\/"},"modified":"2025-08-11T11:08:07","modified_gmt":"2025-08-11T11:08:07","slug":"mssql-extension-for-vs-code-1-34-0-deepens-copilot-agent-mode-adds-colour%e2%80%91coded-connections","status":"publish","type":"post","link":"https:\/\/www.newsbeep.com\/ca\/61268\/","title":{"rendered":"MSSQL Extension for VS Code 1.34.0 Deepens Copilot Agent Mode, Adds Colour\u2011Coded Connections"},"content":{"rendered":"

The Azure SQL team has released version 1.34.0 of the MSSQL extension for Visual Studio Code<\/a>, a cross\u2011platform tool for developing against SQL Server, Azure SQL Database and SQL Database in Fabric. Carlos Robles, Principal Product Manager at Microsoft, explains that the update continues the extension\u2019s goal of making SQL development conversational, visual and local by improving Copilot Agent mode, adding colour-coded connections, streamlining local container workflows and polishing the Schema Designer.<\/p>\n

The previous release introduced GitHub Copilot Agent mode, a chat\u2011based assistant that can perform database tasks. Version 1.34.0 deepens this integration<\/a>. The agent can now change databases, list schemas, tables, views and functions, show connection details, list all databases on a server and run queries directly from the chat assistant. In this version, Copilot goes beyond code suggestions to execute secure database actions using natural language or built\u2011in tools. Each action (e.g., connect, disconnect, change database, list servers or run query) is surfaced through the Agent Tools panel and requires user confirmation<\/a>. This secure confirmation workflow ensures that Copilot never runs database tasks without explicit approval.<\/p>\n

The update introduces colour-coded connections<\/a> to help developers navigate multiple environments. Users can assign a custom colour to any saved connection profile and see it reflected in the VS Code status bar. Group\u2011based colouring allows teams to align on conventions, and the length of the colored indicator is configurable. This feature was contributed by a community member @bathetrade<\/a>.<\/p>\n

Local SQL Server containers, introduced in v1.33, let developers spin up SQL Server 2025 containers without running Docker commands. Version 1.34 builds on this<\/a> by allowing containers to be assigned to connection groups and providing more flexible profile management. A streamlined wizard helps developers create containers faster, and containers can be started, stopped, or deleted from the connection panel. The previous release\u2019s highlights included automatic port conflict detection and support for specifying container names, hostnames and versions. Those capabilities remain in this version.<\/p>\n

Lastly, for the database schema designer<\/a>, still in public preview, an update now displays foreign\u2011key icons correctly and refines filter behaviour so that table relationships are easier to understand.<\/p>\n

Developer reactions to the update are mixed. In the comment section of Microsoft\u2019s blog, Matthew Arp expressed frustration<\/a> that Microsoft had killed Azure Data Studio and argued that colour-coded connections are not a compelling replacement for the richer features of that desktop tool. On the Visual Studio Marketplace, several reviewers similarly criticised<\/a> the extension\u2019s feature gap with Azure Data Studio and reported issues. One user wrote that the gap is astonishing and said the extension is nearly non\u2011functional for his workflow. Some reviewers offered praise: Alberto Peralta Ramos noted that he prefers the VS Code SQL integration over SQL Server Management Studio and Mark Douglas said the extension does the job fine, even though he dislikes the new results UI and keeps using version 1.24.<\/p>\n

As with previous releases, the extension is open source under the MIT License and accepts contributions via GitHub<\/a>. The extension has accumulated over 8 million installs and around 1.7k GitHub stars, indicating significant community interest.<\/p>\n","protected":false},"excerpt":{"rendered":"The Azure SQL team has released version 1.34.0 of the MSSQL extension for Visual Studio Code, a cross\u2011platform…\n","protected":false},"author":2,"featured_media":61269,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[17716,49,48,4113,39943,39945,61,39944],"class_list":["post-61268","post","type-post","status-publish","format-standard","has-post-thumbnail","category-technology","tag-net","tag-ca","tag-canada","tag-development","tag-mssql-vscode-copilot-color-codes","tag-sql-server","tag-technology","tag-visual-studio-code"],"_links":{"self":[{"href":"https:\/\/www.newsbeep.com\/ca\/wp-json\/wp\/v2\/posts\/61268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newsbeep.com\/ca\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newsbeep.com\/ca\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newsbeep.com\/ca\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newsbeep.com\/ca\/wp-json\/wp\/v2\/comments?post=61268"}],"version-history":[{"count":0,"href":"https:\/\/www.newsbeep.com\/ca\/wp-json\/wp\/v2\/posts\/61268\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.newsbeep.com\/ca\/wp-json\/wp\/v2\/media\/61269"}],"wp:attachment":[{"href":"https:\/\/www.newsbeep.com\/ca\/wp-json\/wp\/v2\/media?parent=61268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newsbeep.com\/ca\/wp-json\/wp\/v2\/categories?post=61268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newsbeep.com\/ca\/wp-json\/wp\/v2\/tags?post=61268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}