MSSQL Extension for VS Code: Local Containers, GitHub Copilot Agent Mode and Connection Groups

The MSSQL Extension for VS Code continues to evolve, bringing powerful new features that make SQL development more local, more organized, and more intelligent. In version v1.33.0, we’re introducing Local SQL Server container, GitHub Copilot Agent Mode, and Connection Groups—three capabilities designed to simplify and modernize the way developers build applications using SQL Server in Visual Studio Code.

Here’s a closer look at what’s included in this release and how these features can enhance your SQL development workflow.

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

This release introduces three major capabilities designed to streamline the SQL development experience:

• Local SQL Server Container (Public Preview) — Easily spin up and manage SQL Server containers directly from within the extension.
• GitHub Copilot Agent Mode (Public Preview) — A conversational, schema-aware assistant that helps you connect, explore, understand, and optimize your database through natural language interactions.
• Connection Groups — Organize your saved connections into folders with custom colors for improved clarity and control.

Local SQL Server Container (Public Preview)

You can now create and manage SQL Server containers locally, without writing a single Docker command. The new Local SQL Server Container experience allows you to launch a fully configured SQL Server container from the MSSQL extension’s UI.

By default, the SQL Server container wizard uses SQL Server 2025 (Public Preview), the latest version of SQL Server, which includes native support for vector data types, JSON functions, and other AI-ready features. This makes it ideal for building modern, intelligent applications locally.

This new capability is perfect for prototyping, developing, or testing workloads using the same engine available in production environments.

Key highlights 

• Auto-connect: A connection profile is automatically created and ready to use
• Lifecycle controls: Start, stop, restart, or delete containers from the connection panel
• Docker environment checks: Get notified if Docker isn’t running or installed
• Port conflict detection: If port 1433 (the default SQL Server port) is already in use, the extension will automatically find and assign the next available port for your container.
• Custom settings: Define container name, hostname, and port via UI
• Other versions supported: You can also choose to run a SQL Server 2022, 2019, or 2017 container.

It’s easy to get started—open the Connections panel, select the “Create local SQL Container” from the menu

Once the prerequisites check is complete, you’ll be taken to the container creation dialog. Fill in the required details like image version, password, and profile name to continue.

GitHub Copilot Agent mode (Public Preview)

We’re introducing GitHub Copilot Agent Mode in Public Preview, bringing a contextual, action-driven chat experience into the MSSQL extension. This first release enables GitHub Copilot to interpret your intent and perform real tasks inside Visual Studio Code—making it easier to interact with your database through natural language prompts.

Key highlights 

• List servers – View all available SQL Server connections
• Connect to server or database – Establish a new database connection
• Disconnect from server or database – End the active connection
• Show database schema – Display the schema for the connected database

Here’s how easy it is to ask GitHub Copilot to connect to your database and explore your schema—all from chat.

All available tools contributed by the MSSQL extension are listed automatically in the Agent Tools panel: