Sign in
MCP Server

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
post/api/mcp/sql_server

Headers

Mcp-Session-Idstring nullable

Request body

jsonrpcstring

JSON-RPC version. Always '2.0'

methodstring

MCP method: initialize | tools/list | tools/call

paramsobject nullable

Method parameters. For tools/call: { name, arguments }

idinteger nullable

Request ID. Echoed back in response.

Response

Successful Response

{"stackTrail":"paths:/api/mcp/sql_server:post:responses:200:content:application/json:schema","oasType":"schema","type":"unknown"}

Changes