---
title: "28SV SQL Server MCP — Claude & ChatGPT Connector"
method: POST
path: "/api/mcp/28SV"
tags: ["MCP Server"]
---

# 28SV SQL Server MCP — Claude & ChatGPT Connector

`POST /api/mcp/28SV`

## Request

- Base URL: `https://api.leapsurgebi.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.leapsurgebi.com/api/mcp/28SV`
- Auth: none declared
- TypeScript: <https://skmtc.dev/leapsurgebi/apis/leapsurgeapi/docs/api/mcp/28SV/post.ts> (a function with typed inputs; its response is checked against the schema)

**MCP 28SV SQL Server Endpoint (Claude & ChatGPT Connector)**

    Read-only access to the 28SV SQL Server database.

    **URL:** `POST /api/mcp/28SV`

    **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:**
```json
    { "jsonrpc": "2.0", "method": "tools/list", "params": {}, "id": 1 }
```

    **Example — Call tool:**
```json
    {
      "jsonrpc": "2.0",
      "method": "tools/call",
      "params": { "name": "sv28_list_tables", "arguments": {} },
      "id": 1
    }
```

    **Tools**
    - `sv28_list_tables`
    - `sv28_describe_table`
    - `sv28_execute_query`
    - `sv28_list_schemas`
    - `sv28_get_table_stats`
    - `sv28_search_tables`

    **Security**
    - Read-only enforced (SELECT / WITH…SELECT only)
    - DML/DDL blocked
    - Multiple statements blocked
    - Max rows limited (default 200, max 1000)
    - Session header echoed to prevent ChatGPT link expiry

    **Required env vars:** `MSSQL_SERVER` (shared), `MSSQL_28SV_DATABASE`, `MSSQL_28SV_USER`, `MSSQL_28SV_PASSWORD`

## Headers

- `Mcp-Session-Id` string, nullable

## Request body

- MCPRequest
  - `jsonrpc` string: JSON-RPC version. Always '2.0'
  - `method` string: MCP method: initialize | tools/list | tools/call
  - `params` object, nullable: Method parameters. For tools/call: { name, arguments }
  - `id` integer, nullable: Request ID. Echoed back in response.

## Response `200`

Successful Response

- unknown

## Other responses

- `422`: Validation Error

## Changes

- **2026-09-24** `23b42df3193a`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/leapsurgebi/apis/leapsurgeapi/changes/api/mcp/28SV/post.md)

---

[API](https://skmtc.dev/leapsurgebi/apis/leapsurgeapi.md) - [All operations](https://skmtc.dev/leapsurgebi/apis/leapsurgeapi/llms.txt) - [OpenAPI document](https://skmtc.dev/leapsurgebi/apis/leapsurgeapi/revisions/13653cb8ee76?raw)