mcp-server-pp 1.1.1

MCP server for PharmaPendium data extraction — converts extraction results to XLSX, expands drug/concomitant rows, and uploads to Azure Blob Storage

mcp-server-pp

MCP server for PharmaPendium data extraction — converts extraction results to XLSX, expands drug/concomitant rows, and uploads to Azure Blob Storage.

Tools

save_extraction

Converts a JSON array of extraction results into an XLSX file, uploads it to Azure Blob Storage, and returns a download URL (valid 7 days).

If the user provided corrections or new rules during the extraction session, pass them in notes — they are saved as a separate Notes sheet inside the XLSX for traceability.

Parameters:

• json_data (required): JSON array string — extraction results, one object per row
• file_name (optional): Output filename (with or without .xlsx). Defaults to extraction_results.xlsx
• notes (optional): User corrections, comments, or new rules applied in this session

expand_concomitants

Takes an XLSX file with Drug Name and Concomitants columns, expands each row so every drug in the combined list gets its own row (rotating through the Drug Name slot while the rest fill Concomitants), uploads the result to Azure Blob Storage, and returns a download URL (valid 7 days).

Parameters:

• xlsx_base64 (required): Base64-encoded XLSX file content
• file_name (optional): Output filename (with or without .xlsx). Defaults to expanded_results.xlsx

Example — one source row becomes three:

Drug Name	Concomitants
DrugA	DrugB, DrugC

→

Drug Name	Concomitants
DrugA	DrugB, DrugC
DrugB	DrugA, DrugC
DrugC	DrugA, DrugB

Required environment variable: AZURE_STORAGE_CONNECTION_STRING

Usage

With uvx (no installation needed)

uvx mcp-server-pp@1.1.1

MCP client config (e.g. Codemie, Claude Desktop)

{
  "mcpServers": {
    "pp-tools": {
      "command": "uvx",
      "args": ["mcp-server-pp@1.1.1"],
      "env": {
        "AZURE_STORAGE_CONNECTION_STRING": "${AZURE_STORAGE_CONNECTION_STRING}"
      }
    }
  }
}