ClaudeCodeMod

All shelves / MCP servers

Microsoft SQL Server

io.github.alyiox/mcp-mssql · 10 stars · C# · MIT

MCP server MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in.

Install

The repo has no one-line install. Follow its README.

Published as

  • NuGetAlyio.McpMssqlstdio

From the server's entry in the official MCP Registry.

Open the repo

Configuration

NameSet asWhat it is
MCPMSSQL_CONNECTION_STRINGOptional · SecretEnv varDefault profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.
MCPMSSQL_DESCRIPTIONOptionalEnv varOptional human-readable description for the default profile.
MCPMSSQL_QUERY_MAX_ROWSOptionalEnv varMax rows per interactive query (default 500; ceiling 1000).
MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDSOptionalEnv varInteractive query command timeout in seconds (default 30).
MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWSOptionalEnv varMax rows for snapshot queries (default 10000; ceiling 50000).
MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDSOptionalEnv varSnapshot query timeout in seconds (default 120).
MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDSOptionalEnv varExecution plan analysis timeout in seconds (default 300; ceiling 600).
MCPMSSQL_ALLOW_WRITEOptionalEnv varEnable write commands (DDL/DML) via run_command on the default profile (default false). With no write-enabled profile the tool is not advertised at all. Soft guard only — prefer a db_datareader login for a hard read-only guarantee.
MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDSOptionalEnv varWrite command timeout in seconds (default 60; ceiling 600).
DOTNET_ENVIRONMENTOptionalEnv varSet to Development to load dotnet user-secrets (local dev).

Facts

Kind
MCP server
Repo
alyiox/mcp-mssql
Group
Uncategorized
Stars
10
License
MIT
Language
C#
Last push
2026-10-26
Forks
1
MCP Registry
io.github.alyiox/mcp-mssql
Homepage
github.com/alyiox/mcp-mssql
Topics
mcp, mcp-server, mssql, read-only, sql-server, azure-ad, azure-sql, ai-agents, csharp, database, dotnet, execution-plan, llm, model-context-protocol, nuget, query-optimization, sql

Next on this shelf

  1. 6461Oracle Formsio.github.aoreshkov/oracle-forms-mcpServes Oracle Forms module content (.fmb/.mmb/.pll/.olb) from a directory to MCP clients.10
  2. 6462io.github.ashev87/propstack-mcpio.github.ashev87/propstack-mcpConnect AI assistants to your Propstack real estate CRM (contacts, properties, deals).10
  3. 6463stetdocio.github.clauseo-ai/stetdocRead, redline and compare Word .docx files with real tracked changes10
  4. 6464io.github.ctrlpi/pico-bayio.github.ctrlpi/pico-bayApp and MCP server for Raspberry Pi Pico and ESP32 boards over USB: files, console, firmware.10
  5. 6465io.github.cyanheads/eurostat-mcp-serverio.github.cyanheads/eurostat-mcp-serverSearch and query the Eurostat catalogue — EU economy, demography, trade, and NUTS regional data.10
  6. 6466axe MCP Serverio.github.dequelabs/axe-mcp-serverAxe DevTools accessibility analysis and remediation MCP Server for AI coding agents10