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

[kshyju]

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

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
• Other (please describe below)

If you selected "Other", please describe the area

Remote MCP hosting

Confirmation

• I have searched existing feature requests and couldn't find a match
• I want to help implement this feature