{"slug":"alyiox/alyio.mcpmssql","name":"SQL Server MCP","description":"A read-only Model Context Protocol (MCP) server for Microsoft SQL Server, enabling safe metadata discovery and parameterized SELECT queries.","category":"database","tags":[],"official":false,"stars":5,"transport":"stdio","install":[{"cmd":"npx -y @modelcontextprotocol/inspector","imports":[]}],"tools":[{"name":"list_profiles","description":"List configured connection profiles. Call first when picking a non-default profile."},{"name":"get_server_properties","description":"Get server properties and execution limits (timeouts, row caps, guardrails)."},{"name":"list_objects","description":"List catalog metadata. kind=catalog: databases; schema: schemas; relation: tables/views; routine: procedures/functions."},{"name":"get_object","description":"Get metadata for one relation or routine. Use list_objects to resolve names."},{"name":"run_query","description":"Execute read-only T-SQL SELECT; only SELECT allowed (no DML/DDL). Returns results as CSV."},{"name":"analyze_query","description":"Analyze execution plan for a read-only SELECT. Returns compact JSON summary (cost, operators, cardinality, warnings, indexes, waits, stats)."}],"env_vars":[],"auth_type":"none","github":"https://github.com/alyiox/Alyio.McpMssql","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Thu May 28"}