Aspire Sales DB MCP — Claude & ChatGPT Connector

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:

{ "jsonrpc": "2.0", "method": "tools/list", "params": {}, "id": 1 }

Example — Call tool:

{
  "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