AWO MCP Server

MCP (Model Context Protocol) server that exposes processed AWO facility data to AI assistants like Claude Desktop.

Overview

This MCP server provides a standardized interface between AI assistants and AWO organizational data. It enables natural language queries about AWO facilities, services, and statistics.

Data Source: Processed AWO datasets (facilities, addresses, services, providers)

Status: ✅ Production-ready

Related MCP server: CKAN MCP Server

Architecture

User
  │
Claude Desktop
  │
MCP Server (this repo)
  │
Processed AWO Data (CSV)

Features

Available Tools

Installation

1. Clone the Repository

git clone https://github.com/YOUR_USERNAME/awo-mcp-production.git
cd awo-mcp-production

2. Create and Activate Conda Environment

conda create -n awo-mcp python=3.11
conda activate awo-mcp

3. Install Dependencies

pip install -r requirements.txt

4. Verify Data Files

Ensure the following CSV files exist in the data/ directory:

• einrichtungSchema.csv - Facilities

• adresseSchema.csv - Addresses

• angebotSchema.csv - Services

• traegerSchema.csv - Providers

Running the Server

Start the MCP server:

python server.py

The server will start and wait for MCP requests. Leave this terminal running.

Connecting to Claude Desktop

Step 1: Install Claude Desktop

Download from Claude Desktop.

Note: No Claude subscription is required for MCP server integration.

Step 2: Configure MCP Server

1. Open Claude Desktop.

2. Go to Settings → Developer → Local MCP Servers → Edit Config.

3. Add the following configuration:

{
  "mcpServers": {
    "awo": {
      "command": "C:\\Users\\<YOUR_USERNAME>\\miniconda3\\envs\\awo-mcp\\python.exe",
      "args": [
        "D:\\path\\to\\awo-mcp-production\\server.py"
      ]
    }
  }
}

Step 3: Restart Claude Desktop

Save the configuration and restart Claude Desktop completely.

The MCP server should appear under Settings → Developer → Local MCP Servers with a green status.

Example Queries

Once connected, try asking Claude:

Count Facilities

"How many AWO facilities are in Berlin?"

Search by City

"Show me all AWO facilities in Berlin with their addresses"

Get Facility Details

"Tell me about AWO Sozialstation Wedding"

Search Services

"Find AWO services related to addiction counseling"

Get Statistics

"Show me statistics about AWO facilities"

Data Quality

"Check data completeness for AWO records"

Find Duplicates

"Are there any duplicates in the AWO datasets?"

Compare Facilities

"Compare AWO Mitte and AWO Spree-Wuhle"

Data Overview

The server uses four CSV datasets:

File Structure

awo-mcp-production/
├── data/                      # CSV datasets
│   ├── einrichtungSchema.csv
│   ├── adresseSchema.csv
│   ├── angebotSchema.csv
│   └── traegerSchema.csv
├── src/                       # Core modules
│   ├── data_loader.py
│   └── data_repository.py
├── server.py                  # MCP server
├── requirements.txt
└── README.md

Testing

Test the Server

python -c "from server import mcp; print('✅ Server loaded successfully')"

Run the Client (Optional)

If you have client.py for interactive testing:

python client.py

Deployment

Local Development

• Run python server.py directly.

• Connect Claude Desktop to the local server.

Cloud Deployment

• Deploy to a cloud VM or container.

• Configure Claude Desktop to use a remote endpoint when supported.

Troubleshooting

Server Not Showing in Claude Desktop

• Check the JSON syntax in the configuration file.

• Make sure there are no trailing commas.

• Verify that the Python path exists.

• Check Claude logs at:

%APPDATA%\Claude\logs\mcp*.log

Server Fails to Start

• Ensure all dependencies are installed.

• Verify the data/ folder exists with the required CSV files.

• Run the server manually to see any errors:

python server.py

License

MIT License

Contributing

1. Fork the repository.

2. Create a feature branch.

3. Commit your changes.

4. Push to the branch.

5. Open a Pull Request.