{"name":"io.github.alyiox/mcp-mssql","slug":"alyiox-mcp-mssql","title":"Microsoft SQL Server","description":"MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in.","url":"https://mcp.market/server/alyiox-mcp-mssql","rating":null,"grade":"B","score":73,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":28,"stars":9,"forks":1,"downloads_week":null,"last_push_at":"2026-09-23T00:52:55.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"nuget","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/alyiox/mcp-mssql","website":"https://github.com/alyiox/mcp-mssql","version":"1.8.0","remotes":[],"packages":[{"registryType":"nuget","registryBaseUrl":"https://api.nuget.org/v3/index.json","identifier":"Alyio.McpMssql","version":"1.8.0","runtimeHint":"dnx","transport":{"type":"stdio"},"environmentVariables":[{"description":"Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.","format":"string","isSecret":true,"name":"MCPMSSQL_CONNECTION_STRING"},{"description":"Optional human-readable description for the default profile.","format":"string","name":"MCPMSSQL_DESCRIPTION"},{"description":"Max rows per interactive query (default 500; ceiling 1000).","format":"number","name":"MCPMSSQL_QUERY_MAX_ROWS"},{"description":"Interactive query command timeout in seconds (default 30).","format":"number","name":"MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS"},{"description":"Max rows for snapshot queries (default 10000; ceiling 50000).","format":"number","name":"MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS"},{"description":"Snapshot query timeout in seconds (default 120).","format":"number","name":"MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS"},{"description":"Execution plan analysis timeout in seconds (default 300; ceiling 600).","format":"number","name":"MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS"},{"description":"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.","format":"boolean","name":"MCPMSSQL_ALLOW_WRITE"},{"description":"Write command timeout in seconds (default 60; ceiling 600).","format":"number","name":"MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS"},{"description":"Set to Development to load dotnet user-secrets (local dev).","format":"string","name":"DOTNET_ENVIRONMENT"}]}],"tools":[],"scan":null,"grade_history":[],"reviews":[]}