NonPharma Demo SQL Server MCP — Claude & ChatGPT Connector

MCP NonPharma Demo Endpoint (ChatGPT & Claude Connector)

URL: POST /api/mcp/NonPharma_Demo

Same SQL Server instance as /api/mcp/sql_server, pointed at a different database (MSSQL_NONPHARMA_DATABASE). Read-only, same six tools.

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": "DataFreshness", "arguments": {} },
  "id": 1
}

Tools — curated domain tools; the tool builds the SQL, so the caller never names a table or column.

Domain:

• Sales
• Finance
• Inventory
• Manufacturing
• SecondarySales
• FieldForce
• Procurement
• Workforce

Utility:

• DataFreshness
• ResolveEntity
• DescribeTable
• GetKpiDefinition
• RunSQL

Security

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