SQL Server MCP

stdio

A read-only Model Context Protocol (MCP) server for Microsoft SQL Server, enabling safe metadata discovery and parameterized SELECT queries.

Install

npx -y @modelcontextprotocol/inspector

list_profiles List configured connection profiles. Call first when picking a non-default profile.
get_server_properties Get server properties and execution limits (timeouts, row caps, guardrails).
list_objects List catalog metadata. kind=catalog: databases; schema: schemas; relation: tables/views; routine: procedures/functions.
get_object Get metadata for one relation or routine. Use list_objects to resolve names.
run_query Execute read-only T-SQL SELECT; only SELECT allowed (no DML/DDL). Returns results as CSV.
analyze_query Analyze execution plan for a read-only SELECT. Returns compact JSON summary (cost, operators, cardinality, warnings, indexes, waits, stats).

★ 5 GitHub stars