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
- NuGet
Alyio.McpMssqlstdio
From the server's entry in the official MCP Registry.
Configuration
| Name | Set as | What it is |
|---|---|---|
MCPMSSQL_CONNECTION_STRINGOptional · Secret | Env var | Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings. |
MCPMSSQL_DESCRIPTIONOptional | Env var | Optional human-readable description for the default profile. |
MCPMSSQL_QUERY_MAX_ROWSOptional | Env var | Max rows per interactive query (default 500; ceiling 1000). |
MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDSOptional | Env var | Interactive query command timeout in seconds (default 30). |
MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWSOptional | Env var | Max rows for snapshot queries (default 10000; ceiling 50000). |
MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDSOptional | Env var | Snapshot query timeout in seconds (default 120). |
MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDSOptional | Env var | Execution plan analysis timeout in seconds (default 300; ceiling 600). |
MCPMSSQL_ALLOW_WRITEOptional | Env var | Enable 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_SECONDSOptional | Env var | Write command timeout in seconds (default 60; ceiling 600). |
DOTNET_ENVIRONMENTOptional | Env var | Set 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
- 6461Oracle Formsio.github.aoreshkov/oracle-forms-mcpServes Oracle Forms module content (.fmb/.mmb/.pll/.olb) from a directory to MCP clients.10
- 6462io.github.ashev87/propstack-mcpio.github.ashev87/propstack-mcpConnect AI assistants to your Propstack real estate CRM (contacts, properties, deals).10
- 6463stetdocio.github.clauseo-ai/stetdocRead, redline and compare Word .docx files with real tracked changes10
- 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
- 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
- 6466axe MCP Serverio.github.dequelabs/axe-mcp-serverAxe DevTools accessibility analysis and remediation MCP Server for AI coding agents10