feyod-mcp

Overview

The Feyod MCP server provides a natural language interface to query Feyenoord football match data using the Model Context Protocol. It uses LangChain to convert natural language questions into SQL queries, validates them, and executes them against a SQLite database containing Feyenoord's open data. The server supports multiple LLM providers and can be run locally or via Docker with a public HTTP endpoint available.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• answer_feyenoord_question

  Answers questions about Feyenoord matches, players, and opponents.

  Try:Who scored the most goals in Feyenoord's last season?Try:What was the lineup in Feyenoord's match against Ajax last month?Try:Show me Feyenoord's away match results this season.

Comparable tools

Installation

# Pull the Docker image
docker pull jeroenvdmeer/feyod-mcp

# Run the container
docker run -p 8000:8000 \
  -e LLM_PROVIDER="google" \
  -e LLM_API_KEY="your_api_key" \
  jeroenvdmeer/feyod-mcp

# Clone repositories
git clone https://github.com/jeroenvdmeer/feyod-mcp.git
git clone https://github.com/jeroenvdmeer/feyod.git
cd feyod-mcp

# Create and activate virtual environment
uv venv
source .venv/bin/activate  # or .venv\Scripts\activate on Windows

# Install dependencies
uv add "mcp[cli]" langchain langchain-openai langchain-google-genai python-dotenv aiosqlite

# Set up database
cd ../feyod
sqlite3 feyod.db < feyod.sql

cd ../mcp

{
  "mcpServers": {
    "feyod": {
      "command": "python",
      "args": ["/path/to/feyod-mcp/main.py"],
      "env": {
        "LLM_PROVIDER": "google",
        "LLM_API_KEY": "your_api_key",
        "DATABASE_PATH": "../feyod/feyod.db"
      }
    }
  }
}

FAQ

What LLM providers are supported?

The server supports multiple LLM providers including OpenAI, Google (Gemini), and others through a configurable provider factory. You can add new providers by updating the llm_factory.py file.

How do I update the Feyod database?

The Feyod database is maintained in a separate repository (jeroenvdmeer/feyod). You need to download the latest SQL file from that repository and rebuild your SQLite database using the provided SQL statements.

Compare feyod-mcp with