MCP Server Outlook Email

🚀 Email Processing MCP Server

This MCP server offers email processing capabilities and integrates MongoDB for semantic search and SQLite for efficient storage and retrieval.

🚀 Quick Start

This MCP server provides comprehensive email processing features. It integrates MongoDB for semantic search and SQLite for efficient data storage and retrieval.

✨ Features

• Process Outlook emails with date range filtering.
• Store emails in the SQLite database with proper connection management.
• Generate vector embeddings using Ollama.
• Support multiple mailboxes.
• Support Inbox, Sent Items folders, and optionally the Deleted Items folder.

📋 Planned Features

• Email search with semantic capabilities.
• Email summarization using LLM.
• Automatic email classification.
• Customizable email reports.
• Advanced filtering options.
• Draft email replies in Outlook.
• Outlook rule suggestions.
• Expand database options by integrating Neo4j and ChromaDB.

📋 Prerequisites

• Python 3.10 or higher.
• Ollama running locally (for embeddings).
• Microsoft Outlook installed.
• Windows operating system (for Outlook integration).
• MongoDB server (for storing embeddings).

📦 Installation

1. Install uv (if not already installed):

   pip install uv
   

2. Create a virtual environment:

   uv venv .venv
   

3. Activate the virtual environment:

   Windows:

   .venv\Scripts\activate
   

   macOS/Linux:

   source .venv/bin/activate
   

4. Install dependencies:

   pip install -r requirements.txt
   

5. Run the server:

   python server.py
   

📚 Configuration Guide

Add the following content to the configuration file:

{
    "mongodb": {
        "uri": "mongodb://localhost:27017",
        "database": "email_processing"
    },
    "sqlite": {
        "path": "emails.db"
    },
    "ollama": {
        "url": "http://localhost:11434"
    }
}

📚 Detailed Configuration

• MongoDB configuration: Specify the connection URI and database name.
• SQLite configuration: Specify the database file path.
• Ollama configuration: Specify the service address.

💻 Usage Examples

Basic Usage

Get the email processing status:

from server import EmailProcessor

processor = EmailProcessor()
status = processor.get_status()
print(status)

🔧 Error Handling

Common errors include:

• Invalid date format.
• Outlook connection issues.
• MongoDB errors.
• Embedding generation failures.
• Database storage errors.
• Ollama server connection issues.

🔧 Debugging Guide

1. Check if emails are processed successfully (check the process_emails response).
2. Ensure the Ollama server is running for embedding generation.
3. Check the access permissions of the SQLite database.
4. Verify the MongoDB connection status.

⚠️ Security Notes

• The server only processes emails from specified mailboxes.
• All data is stored locally (SQLite and MongoDB).
• There are no external API calls, only communication with the local Ollama server.
• Email processing requires explicit user approval.
• No sensitive email data is exposed through the MCP interface.

📄 Final Note

If you have any questions or suggestions, please contact the support team.