Azure-Samples / Azure-Samples/SQL-AI-samples

MssqlMcp: Incorrect tool tags - 'List Tables' marked as destructive, 'Create Table' marked as read-only

未关闭
#90 1 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
HTML
星标
331
派生
208
PR 合并指标
30 天内没有已合并 PR

描述

## Problem

The MssqlMcp .NET server has incorrect tool tags that misrepresent the nature of operations:

**Current (incorrect) behavior:**
- `ListTables` is tagged as **destructive**
- `CreateTable` is tagged as **read-only**
- `DescribeTable` is tagged as **read-only** ✓ (correct)

**Expected behavior:**
- `ListTables` should be tagged as **read-only** (it only queries metadata via INFORMATION_SCHEMA or sys tables)
- `CreateTable` should be tagged as **destructive** or **write** (it modifies database schema)
- Other write operations (`InsertData`, `UpdateData`, `DropTable`) should also be reviewed for correct tagging

## Impact

This causes user confusion and may trigger unnecessary confirmations for safe read operations while failing to warn about actual schema modifications.

## Environment

- MssqlMcp version: Built from main branch (dotnet implementation)
- .NET 8.0
- MCP SDK: Official C# SDK

## Steps to Reproduce

1. Configure MssqlMcp server in Claude Desktop or VS Code
2. View available tools
3. Observe incorrect tags on `ListTables` (destructive) and `CreateTable` (read-only)

## Additional Context

The tool tags appear to be swapped or misconfigured in the tool definitions. `ListTables` performs a SELECT query on database metadata and should be completely safe/read-only.

贡献指南

打开贡献指南

评估

这个 Issue 还没有评估数据。

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。