SQL Server MCP

stdionone★ 5database

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

Install

How to run this server

[ { "cmd": "npx -y @modelcontextprotocol/inspector", "imports": [] } ]

server path: sql-server-mcp

Tools

What this server exposes

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).

Configuration

Environment & auth

authnone

Resources