M

Microsoft SQL Server

MCP server · by alyiox

Databases nuget v1.8.0

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

View source ↗ Website ↗ Generate config for multiple servers More servers

Install

unavailable — hosted endpoints aren’t versioned

nuget
Alyio.McpMssql

Setup by client

Pick your client — the config below is generated for this server. Copy respects the “Pin version” switch above.

This server ships as a downloadable bundle: Alyio.McpMssql

Format verified against the official Claude Desktop docs ↗.

Environment variables

Defined in the server's official registry manifest. Required secrets are shown as <YOUR_…> placeholders in the configs above.

  • MCPMSSQL_CONNECTION_STRING secret — Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.
  • MCPMSSQL_DESCRIPTION — Optional human-readable description for the default profile.
  • MCPMSSQL_QUERY_MAX_ROWS — Max rows per interactive query (default 500; ceiling 1000).
  • MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS — Interactive query command timeout in seconds (default 30).
  • MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS — Max rows for snapshot queries (default 10000; ceiling 50000).
  • MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS — Snapshot query timeout in seconds (default 120).
  • MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS — Execution plan analysis timeout in seconds (default 300; ceiling 600).
  • MCPMSSQL_ALLOW_WRITE — 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

GitHub

⭐ 9 stars · 最近更新于 19 天前 · MIT license

About this server

Distributed as nuget, listed under Databases. Review our MCP security guide before granting access to real data.

Frequently asked questions

How do I install Microsoft SQL Server?

Run the install command shown above, then paste the config for your client (Claude Desktop, Claude Code, Cursor, VS Code or Windsurf) into its MCP settings and restart the client.

Is Microsoft SQL Server free to use?

The MCP server itself is free to install. The source is public on https://github.com/alyiox/mcp-mssql. Any third-party service it calls may require its own API key and account.

Which clients support Microsoft SQL Server?

Any MCP-compatible client can use it, including Claude Desktop, Claude Code, Cursor, VS Code, Windsurf and custom agents.

Add this badge

Publish this server? Link back with a badge on your README or site — copy either snippet.

Listed on MCPNav

Markdown

[![Listed on MCPNav](https://mcpnav.net/badge/mcp-mssql.svg)](https://mcpnav.net/server/mcp-mssql/)

HTML

<a href="https://mcpnav.net/server/mcp-mssql/"><img src="https://mcpnav.net/badge/mcp-mssql.svg" alt="Listed on MCPNav" height="20"></a>