SharePoint MCP Server

A comprehensive MCP Server for seamless integration with Microsoft SharePoint, enabling MCP clients to interact with documents, folders and other SharePoint resources. Built with efficiency and ease of use in mind, supporting both text and binary file operations. Developed by sofias tech.

✨ Key Features

This server provides a clean, efficient interface to SharePoint resources through the Model Context Protocol (MCP), with optimized operations for document management and content processing.

🛠️ Available Tools

The server implements 10 comprehensive tools for complete SharePoint management:

📁 Folder Management

List_SharePoint_Folders: Lists all folders in a specified directory or root
Create_Folder: Creates new folders in specified directories
Delete_Folder: Safely deletes empty folders from SharePoint
Get_SharePoint_Tree: Gets a recursive tree view of SharePoint folder structure

📄 Document Management

List_SharePoint_Documents: Fetches all documents within a specified folder with metadata
Get_Document_Content: Retrieves and processes document content (supports text extraction from PDF, Word, Excel)
Upload_Document: Uploads new documents to specified folders (supports both text and binary content)
Upload_Document_From_Path: Direct file upload from local filesystem for large files
Update_Document: Updates content of existing documents
Delete_Document: Removes documents from specified folders

🎯 Advanced Content Processing

The server includes intelligent content extraction capabilities:

📊 Excel Files: Extracts data from all sheets, converts to readable text format (first 50 rows per sheet)
📝 Word Documents: Processes paragraphs and tables, maintaining structure
📄 PDF Files: Full text extraction using PyMuPDF for accurate content parsing
📃 Text Files: Direct processing of various text formats (JSON, XML, HTML, MD, code files)
🔧 Binary Support: Base64 encoding/decoding for seamless binary file handling

🏗️ Architecture

The server is built with resource efficiency and maintainability in mind:

Efficient SharePoint API usage with selective property loading to minimize bandwidth
Smart error handling through decorators for cleaner, more reliable code
Clear separation of concerns between resource management and tool implementation
Optimized content handling for both text and binary files with automatic type detection
Configurable tree operations with depth limits and batch processing for large directories
Async/await support throughout for non-blocking operations

Setup

Register an app in Azure AD with appropriate SharePoint permissions
Obtain the client ID and client secret for the registered app
Identify your SharePoint site URL and the document library path you want to work with

Environment Variables

The server requires these environment variables:

Required Variables

SHP_ID_APP: Your Azure AD application client ID
SHP_ID_APP_SECRET: Your Azure AD application client secret
SHP_SITE_URL: The URL of your SharePoint site
SHP_DOC_LIBRARY: Path to the document library (default: "Shared Documents/mcp_server")
SHP_TENANT_ID: Your Microsoft tenant ID

Optional Configuration Variables

SHP_MAX_DEPTH: Maximum folder depth for tree operations (default: 15)
SHP_MAX_FOLDERS_PER_LEVEL: Maximum folders to process per level (default: 100)
SHP_LEVEL_DELAY: Delay in seconds between processing levels (default: 0.5)

Quickstart

Installation

pip install -e .

Or install from PyPI once published:

pip install mcp-sharepoint-server

Using uv:

uv pip install mcp-sharepoint-server

Claude Desktop Integration

To integrate with Claude Desktop, update the configuration file:

On Windows: %APPDATA%/Claude/claude_desktop_config.json On macOS: ~/Library/Application\ Support/Claude/claude_desktop_config.json

Standard Integration

"mcpServers": {
  "sharepoint": {
    "command": "mcp-sharepoint",
    "env": {
      "SHP_ID_APP": "your-app-id",
      "SHP_ID_APP_SECRET": "your-app-secret",
      "SHP_SITE_URL": "https://your-tenant.sharepoint.com/sites/your-site",
      "SHP_DOC_LIBRARY": "Shared Documents/your-folder",
      "SHP_TENANT_ID": "your-tenant-id",
      "SHP_MAX_DEPTH": "15",
      "SHP_MAX_FOLDERS_PER_LEVEL": "100",
      "SHP_LEVEL_DELAY": "0.5"
    }
  }
}

Using uvx

"mcpServers": {
  "sharepoint": {
    "command": "uvx",
    "args": [
      "mcp-sharepoint"
    ],
    "env": {
      "SHP_ID_APP": "your-app-id",
      "SHP_ID_APP_SECRET": "your-app-secret",
      "SHP_SITE_URL": "https://your-tenant.sharepoint.com/sites/your-site",
      "SHP_DOC_LIBRARY": "Shared Documents/your-folder",
      "SHP_TENANT_ID": "your-tenant-id",
      "SHP_MAX_DEPTH": "15",
      "SHP_MAX_FOLDERS_PER_LEVEL": "100",
      "SHP_LEVEL_DELAY": "0.5"
    }
  }
}

Development

Requirements

Python 3.10+
Dependencies listed in requirements.txt and pyproject.toml

Local Development

Clone the repository

Create a virtual environment:

python -m venv .venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate

Install development dependencies:
```
pip install -e .
```

Create a .env file with your SharePoint credentials:

SHP_ID_APP=your-app-id
SHP_ID_APP_SECRET=your-app-secret
SHP_SITE_URL=https://your-tenant.sharepoint.com/sites/your-site
SHP_DOC_LIBRARY=Shared Documents/your-folder
SHP_TENANT_ID=your-tenant-id

Run the server:
```
python -m mcp_sharepoint
```

Debugging

For debugging the MCP server, you can use the MCP Inspector:

npx @modelcontextprotocol/inspector -- python -m mcp_sharepoint

License

This project is licensed under the MIT License - see the LICENSE file for details.