MS SQL Server MCP Server

# MS SQL Server MCP Server v2.3.5 πŸš€ **Model Context Protocol (MCP) server** for Microsoft SQL Server - compatible with Claude Desktop, Cursor

Remote serverstreamable-httpTypeScript

What is the MS SQL Server MCP Server?

MS SQL Server MCP Server v2.3.5 πŸš€ Model Context Protocol (MCP) server for Microsoft SQL Server - compatible with Claude Desktop, Cursor, Windsurf and VS

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
mssql_connect_databaseNo
mssql_disconnect_databaseNo
mssql_connection_statusβœ…
mssql_run_sql_query⚠️ No
mssql_list_schema_objectsβœ…
mssql_describe_table_columnsβœ…
mssql_read_table_rowsβœ…
mssql_execute_stored_procedure⚠️ No
mssql_list_databasesβœ…

Configuration

VariableDescriptionRequired
DB_SERVERConfiguration value read at startup.Optional
DB_DATABASEConfiguration value read at startup.Optional
DB_USERConfiguration value read at startup.Optional
DB_PASSWORDConfiguration value read at startup.Optional
DB_ENCRYPTConfiguration value read at startup.Optional
DB_TRUST_SERVER_CERTIFICATEConfiguration value read at startup.Optional

Example prompts to try

  • β€œUse MS SQL Server to mssql connect database.”
  • β€œUse MS SQL Server to mssql disconnect database.”
  • β€œUse MS SQL Server to mssql connection status.”

Frequently asked questions

Node.js (via npm) and a network‑accessible SQL Server instance. The server uses the `@modelcontextprotocol/sdk` pinned to 1.28.0.