MCP Alchemy Server

A Model Context Protocol (MCP) server that provides access to transaction data from the XB database. This server is designed to be used with MCP clients (like Claude Desktop or other AI agents) to retrieve financial transaction details.

Features

• Payout Transaction Lookup: Retrieve payout transaction details using either a UUID or a Client Transaction ID.
• MCP Standard: Built using the fastmcp SDK, compatible with any MCP client.

prerequisites

• Python 3.12 or higher
• uv (recommended for dependency management)

Installation

1. Clone the repository:

   git clone <repository-url>
   cd oncall-mcp
   

2. Install dependencies:

   uv sync
   

Configuration

1. Copy the example environment file:

   cp .env.example .env
   

2. Edit .env and add your database connection strings:

   XB_DATABASE_URL="mysql+pymysql://user:password@host:port/database"
   SNAP_DATABASE_URL="mysql+pymysql://user:password@host:port/database"
   

Running the Server

Development / Local Run

To run the server locally with hot-reloading (if supported by the runner) or for testing:

uv run main.py

Using with an MCP Client

You can configure your MCP client to run this server directly. For example, in claude_desktop_config.json:

{
  "mcpServers": {
    "PivotOnCall": {
        "serverUrl": "http://localhost:8000/mcp"
    }
  }
}

Available Tools

get_payout_transaction

Retrieves a payout transaction from the XB database.

• Arguments:

  • identifier (string): The UUID or Client Transaction ID.
  • by_client_id (boolean, optional): Set to True if searching by Client Transaction ID. Defaults to False (UUID).

• Example Prompts

check payout transaction with this uuid bc09aa1e-005a-48da-9837-bf68fa4969a9

check payout transaction with this client id 0199fd4f-b542-79fd-9666-a4b8397ace29