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

READONLY mode support is needed in dotnet MCP server as implemented in Node version

Open
#56 2 comments 2 reactions 0 assignees View on GitHub
Dominant language
HTML
Stars
331
Forks
208
PR merge metrics
No merged PRs in 30d

Description

Could you please implement support for `READONLY` mode in dotnet version?
So that when `env` configuration is configured with `"READONLY": "true"` MCP server will not allow to execute Update/Insert/Drop tools.

```
"env": {
"CONNECTION_STRING": "Server=localdev;Database=eCommerce;Integrated Security=True;TrustServerCertificate=True;Encrypt=False",
"READONLY": "true"
}
```

dotnet version:
https://github.com/Azure-Samples/SQL-AI-samples/blob/5a4ba3f8d62aa5683a497f16e5ff4c26cc600ee0/MssqlMcp/dotnet/MssqlMcp/Program.cs#L37

Node version:
https://github.com/Azure-Samples/SQL-AI-samples/blob/5a4ba3f8d62aa5683a497f16e5ff4c26cc600ee0/MssqlMcp/Node/src/index.ts#L85

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.