SharePoint MCP Server (Certificate Auth)

A comprehensive MCP Server for seamless integration with Microsoft SharePoint using certificate-based authentication. Enables MCP clients to interact with documents, folders and other SharePoint resources securely without client secrets.

Quick Start

1. Install

Using uvx (recommended):

Or install with uv:

2. Run Interactive Setup

The setup wizard will:

1. Generate a certificate for authentication

2. Guide you through Azure configuration

3. Collect your Azure app details

4. Ask which AI assistant you use (Claude Desktop, Claude Code, Cursor, Windsurf)

5. Output an AI-ready prompt that you paste into your assistant to finish configuration

The wizard generates INSTALL_WITH_AI.md - just paste it into your AI assistant and let it configure everything for you!

3. Configure Azure (One-time setup)

1. Go to Azure Portal → App registrations → New registration

2. Name it (e.g., mcp-sharepoint), click Register

3. Save the Application (client) ID and Directory (tenant) ID

4. Go to Certificates & secrets → Certificates → Upload certificate

   • Upload the certs/sharepoint.crt file generated by the setup command

5. Go to API permissions → Add permission → SharePoint → Application permissions

   • Add Sites.FullControl.All (or Sites.ReadWrite.All for read/write only)

   • Click Grant admin consent

4. Configure Your AI Assistant

The setup wizard outputs INSTALL_WITH_AI.md - paste this into your AI assistant (Claude, Cursor, etc.) and it will configure the MCP server for you automatically.

Or configure manually - create a .env file:

5. Run (Standalone)

You should see:

Claude Desktop Integration

Add to your Claude Desktop config:

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

Available Tools

The server provides 14 tools for complete SharePoint management:

Folder Management

• List_SharePoint_Folders - List folders in a directory

• Create_Folder - Create new folders

• Delete_Folder - Delete empty folders

• Get_SharePoint_Tree - Get recursive folder structure

Document Management

• List_SharePoint_Documents - List documents with metadata

• Get_Document_Content - Read document content (supports PDF, Word, Excel)

• Upload_Document - Upload new documents (text or binary)

• Upload_Document_From_Path - Upload from local filesystem

• Update_Document - Update existing documents

• Delete_Document - Remove documents

• Download_Document - Download to local filesystem

Metadata Operations

• Get_File_Metadata - Get file metadata fields

• Update_File_Metadata - Update file metadata

Content Processing

Intelligent content extraction for common file types:

• PDF - Full text extraction via PyMuPDF

• Word (.docx) - Paragraphs and tables

• Excel (.xlsx) - All sheets, first 50 rows each

• Text files - JSON, XML, HTML, MD, code files

• Binary - Base64 encoding for other types

Environment Variables

Required

Optional

Development

Requirements

• Python 3.12+

• uv

Setup

Run Locally

Code Quality

Debugging with MCP Inspector

Troubleshooting

"Authentication failed" (401)

• Verify certificate is uploaded to Azure AD

• Check thumbprint matches

• Ensure certificate hasn't expired

"Access denied" (403)

• Grant admin consent for API permissions

• Verify Sites.FullControl.All or Sites.ReadWrite.All is granted

"Site not found" (404)

• Check SHP_SITE_URL is correct

• Verify site exists and is accessible

License

MIT License - see LICENSE for details.

Copyright (c) 2025 Chieji Mofor