Home › Databases & Data › Microsoft SQL Server

Microsoft SQL Server

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

C#
★ 10 stars Last pushed 2026-10-26 License: MIT

Connect

Review any command before running it. Package names and URLs come from the server's own registry entry.

Package (nuget 1.8.0)

Package: nuget Alyio.McpMssql

  • 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 guarantee.
  • MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS — Write command timeout in seconds (default 60; ceiling 600).
  • DOTNET_ENVIRONMENT — Set to Development to load dotnet user-secrets (local dev).

Related servers

Data from the Official MCP Registry