{"name":"io.github.alyiox/mcp-mssql","slug":"alyiox-mcp-mssql","title":"Microsoft SQL Server","description":"Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; 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-17T02:54:03.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.6.1","remotes":[],"packages":[{"registryType":"nuget","registryBaseUrl":"https://api.nuget.org/v3/index.json","identifier":"Alyio.McpMssql","version":"1.6.1","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":{"score":73,"grade":"B","scanned_at":"2026-09-19T10:17:01.581Z","report":{"scannerVersion":"0.1.3","scannedAt":"2026-09-19T10:17:01.558Z","components":{"code":{"score":-1,"max":25,"notes":["package could not be scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":15,"max":15,"notes":["last push 2 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[],"repo":{"found":true,"owner":"alyiox","repo":"mcp-mssql","archived":false,"pushedAt":"2026-09-17T02:54:03Z","stars":9,"forks":1,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/7823985?v=4","ownerCreatedAt":"2014-06-07T12:20:24Z","license":"MIT"},"icon":{"url":"https://avatars.githubusercontent.com/u/7823985?v=4&s=128","source":"github"},"presence":{"stars":9,"forks":1,"downloadsWeek":null,"license":"MIT","lastPushAt":"2026-09-17T02:54:03.000Z","score":28}}}},"grade_history":[],"reviews":[]}