SQL Server MCP — Claude & ChatGPT Connector

MCP SQL Server Endpoint (ChatGPT & Claude Connector)

URL: POST /api/mcp/sql_server

Header:

• Mcp-Session-Id (optional but recommended) — will be echoed back in every response.

Methods Supported (method):

• initialize
• notifications/initialized
• ping
• tools/list
• tools/call

Example — List tools:

{ "jsonrpc": "2.0", "method": "tools/list", "params": {}, "id": 1 }

Example — Call tool:

{
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": { "name": "sqlserver_list_tables", "arguments": {} },
  "id": 1
}

Tools

• sqlserver_list_tables
• sqlserver_describe_table
• sqlserver_execute_query
• sqlserver_list_schemas
• sqlserver_get_table_stats
• sqlserver_search_tables

Security

• Read-only enforced (SELECT / WITH…SELECT only)
• Multiple statements blocked
• Max rows limited
• Session header echoed to prevent ChatGPT link expiry