---
title: "Aspire Sales DB MCP — Claude & ChatGPT Connector"
method: POST
path: "/api/mcp/aspire"
tags: ["MCP Server"]
---

# Aspire Sales DB MCP — Claude & ChatGPT Connector

`POST /api/mcp/aspire`

## 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/aspire`
- Auth: none declared
- TypeScript: <https://skmtc.dev/leapsurgebi/apis/leapsurgeapi/docs/api/mcp/aspire/post.ts> (a function with typed inputs; its response is checked against the schema)

**MCP Aspire Pharma Sales Database Endpoint (Claude & ChatGPT Connector)**

Read-only access to four pre-approved pharma sales-summary tables.

**URL:** `POST /api/mcp/aspire`

**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": "aspire_execute_query",
    "arguments": { "query": "SELECT TOP 10 * FROM dbo.Sales_Summary_Month_Wise ORDER BY 1 DESC" }
  },
  "id": 1
}
```

**Tools**
- `aspire_list_tables`
- `aspire_describe_table`
- `aspire_execute_query`
- `aspire_get_table_stats`
- `aspire_list_schemas`
- `aspire_search_tables`
- `aspire_sample_table`

**Accessible Tables**
- `dbo.HQ_Wise_Monthly_Sales_Summary`
- `dbo.Sales_Summary_Customer_Wise`
- `dbo.Sales_Summary_Division_Wise`
- `dbo.Sales_Summary_Month_Wise`

**Security**
- Read-only enforced (SELECT / WITH…SELECT only)
- DML/DDL blocked
- Multiple statements blocked
- Max 500 rows returned
- Table whitelist enforced
- Session header echoed to prevent ChatGPT link expiry

**Required env vars:** ASPIRE_SERVER, ASPIRE_DATABASE, ASPIRE_USERNAME, ASPIRE_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/aspire/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)