Metadata-Version: 2.4
Name: mcp-server-pp
Version: 1.0.1
Summary: MCP server for PharmaPendium data extraction — converts extraction results to XLSX and uploads to Azure Blob Storage
Author: ELS-RJED Team
License-Expression: MIT
License-File: LICENSE
Keywords: excel,extraction,mcp,pharmacokinetic,pharmapendium,xlsx
Classifier: Development Status :: 4 - Beta
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Requires-Python: >=3.11
Requires-Dist: azure-storage-blob>=12.19.0
Requires-Dist: mcp>=1.0.0
Requires-Dist: openpyxl>=3.1.5
Requires-Dist: pandas>=2.0.0
Description-Content-Type: text/markdown

# mcp-server-pp

MCP server for PharmaPendium data extraction — converts extraction results to XLSX and uploads to Azure Blob Storage.

## Tool

### `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

**Required environment variable:** `AZURE_STORAGE_CONNECTION_STRING`

## Usage

### With uvx (no installation needed)

```bash
uvx mcp-server-pp@1.0.1
```

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

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