LEleapsurgebi
MCP Server

StoveKraft SQL Server MCP - Claude & ChatGPT Connector

Changed on

MCP StoveKraft Endpoint (ChatGPT & Claude Connector)

URL: POST /api/mcp/StoveKraft

Stove Kraft Limited business analytics (PIGEON, Gilma, Black + Decker, Skava, Pigeon LED). Same SQL Server instance as /api/mcp/sql_server and /api/mcp/NonPharma_Demo, pointed at a different database (MSSQL_STOVEKRAFT_DATABASE). Read-only.

Header:

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

Methods Supported (method):

  • initialize - advertises STOVEKRAFT_SYSTEM_PROMPT as MCP instructions
  • notifications/initialized
  • ping
  • tools/list
  • tools/call

Tools (11): Sales, Margin, Finance, CashFlow, Receivables, Production, Inventory, ResolveEntity, RunSQL, DescribeTable, GetKpiDefinition.

Notes

  • Sales/Margin read small monthly cubes and fall back to the line-level fact for cross-cube slices; the tool reports which path it took in source.
  • Finance returns an explicit unavailable payload until the G/L account mapping is loaded - surface that rather than working around it.

Security

  • Read-only enforced (SELECT / WITH...SELECT only)
  • Table scope limited to the curated allow-list
  • Max rows limited
  • Session header echoed to prevent ChatGPT link expiry
post/api/mcp/StoveKraft

Request

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

unknown required

Changes