MCP Server/Client Example

The server is a modified implementation following tutorial from Medium by Alex Merced.

The custom client is an implementation from Anthropic quickstart tutorial Build an MCP Client.

MCP Server

Navigate to your project directory, run these commands in the terminal.

source .venv/bin/activate

uv --directory . run mcp_server/main.py

NOTE: There are no outputs from the terminal - it's normal.

MCP Client

Claude Desktop

On MacOS or Linx, add the following entry to ~/Library/Application Support/Claude/claude_desktop_config.json

For Windows, add the following entry to %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "mcp-mix-server": {
      "command": "uv",
      "args": [
        "--directory",
        "{ABSOLUTE_PATH}/mcp-mix-server",
        "run",
        "mcp_server/main.py"
      ]
    }
  }
}

Verify server registery

1. Click on "Searches and tools" option.

2. Click on "mcp-mix-server", you should see the listed tools

3. Test with the following queries:

   • “Summarize the CSV file named sample.csv.”

   • “How many rows are in sample.parquet?”

Related MCP server: Excel MCP Server

Custom MCP client

Alternatively, use a custom client in mcp_client/ implemented following the Anthropic quickstart tutorial Build an MCP Client.

Create a .env file in the root folder and put your Athropic API access key in there. To obtain the API access key, login your Anthropic account and following instructions.

ANTHROPIC_API_KEY=<your_api_access_key>

You can always use your own reasoning model. But this repo is very basic to demonstrate how MCP Server/Client works so we stick with Claude.

When starting the client, it will automatically start the server in stdio transport mode. This means the client access the server locally, not remotely, which uses SSE transport mode. There is no need run the server script separately.

To run the custom client:

uv run mcp_client/client.py mcp_server/main.py

Test with the following queries:

• “Summarize the CSV file named sample.csv.”

• “How many rows are in sample.parquet?”

• or type "quit" to exit