Hacktoberfest 2026: the issues maintainers tagged for October, open and beginner-friendly. Browse Hacktoberfest issues

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

Open
#90 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
38/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Stale
Tech stack
csharp, sql
Domain
databases

Research direction

Start by locating the MssqlMcp tool definitions for ListTables, CreateTable, DescribeTable, InsertData, UpdateData, and DropTable. Compare each tag with the operation it performs, then review the available tools in Claude Desktop or VS Code to confirm read operations do not appear destructive and schema-changing operations are appropriately marked.

Written by the indexing model from the issue text.

Description

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.

Dominant language
HTML
Stars
331
Forks
208
No merged PRs in 30d

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from Azure-Samples/SQL-AI-samples

All issues in Azure-Samples/SQL-AI-samples

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.