microsoft / microsoft/mcp

Some `SQL Server operation` prompts do not trigger the corresponding tool as expected

Open
#780 2 comments 0 reactions 2 assignees Claimed by @achyuth-ms View on GitHub
bug server-Azure.Mcp tools-SQL
Dominant language
C#
Stars
3.7k
Forks
624
Avg merge
2d 20h
Merged PRs (30d)
220

Description

**Description:**
When testing `Azure SQL Server Operations`, some test prompts did not trigger the expected tools, as follows:

1. `Show me the Entra ID administrators configured for SQL server `
Image

2. `What Microsoft Entra ID administrators are set up for my SQL server ?`:
Image

3. `List all firewall rules for SQL server `:
Image

4. `Show me the firewall rules for SQL server `:
Image

5. `What firewall rules are configured for my SQL server ?`:
Image

**Steps to Reproduce:**
1. Start mcp server in namespaces mode.
2. Open GitHub Copilot in VS Code and [switch to Agent mode](https://code.visualstudio.com/docs/copilot/chat/chat-agent-mode).
3. Click Refresh on the tools list, and select the `Built-in`, `Extension: Github Copilot for Azure`, `MCP Server: Microsoft Docs`, `github MCP server` and `MCP Server: Azure MCP`.
4. Enter test prompts `Show me the Entra ID administrators configured for SQL server `

**Environment:**

- OS: Windows.
- Vscode Version: 1.105
- GitHub Copilot Chat Version: 0.31.3
- Large Language Model: GPT-4.1
- Virtual Tool: On
- Azure MCP Server: 0.8.6

**Expected Behavior:**
The expected tools were successfully triggered.

@joshfree for notification

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.