microsoft / microsoft/vscode-mssql

[Feature Request]: Enable Hosted Remote MCP deployment from the VS Code extension

Open
#22,280 0 comments 0 reactions 0 assignees View on GitHub
Area - GitHub Copilot Enhancement User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Feature Description

Enable Hosted Remote MCP deployment from the VS Code extension.

Users should be able to select **`MCP`** as the `ApiType` and click **Deploy**, which provisions a managed SQL MCP server. Under the hood, this should invoke the same ARM APIs used by this workflow:
[Create a hosted MCP server](https://learn.microsoft.com/en-us/azure/logic-apps/connector-namespace/hosted-mcp-quickstart?pivots=sql#create-a-hosted-mcp-server)

The result of this operation is a ready-to-use MCP endpoint that users can immediately start consuming.

### Problem and Motivation

There is currently no one-click deployment option for remote MCP hosting from the development experience. Users must navigate to the Azure portal and manually perform the deployment steps.

See https://learn.microsoft.com/en-us/azure/logic-apps/connector-namespace/connector-namespace-hosted-mcp

### Related Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [ ] Query results panel
- [ ] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [ ] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [x] Other (please describe below)

### If you selected "Other", please describe the area

Remote MCP hosting

### Confirmation

- [x] I have searched existing feature requests and couldn't find a match
- [ ] I want to help implement this feature

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the extension's ApiType selection and Deploy flow, then read the linked hosted MCP ARM workflow and Azure documentation. Determine how the MCP option should provision the managed SQL MCP server and expose its endpoint. Done means users can select MCP, click Deploy, and receive a ready-to-use remote MCP endpoint.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript
Domain
api, cloud, devtools
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.