sharepoint-mcp-server

Here is the complete text formatted inside a single code block. You can click the "Copy" button at the top-right corner of the block to copy everything in one click:

# SharePoint MCP Server & AI Orchestrator (.NET 9)

An end-to-end local AI-driven SharePoint orchestrator that connects a local LLM (**Ollama**) to Microsoft SharePoint via the **Model Context Protocol (MCP)** and **Microsoft Graph API**.

---

## 🏗️ Architecture Overview

┌────────────────────────────────┐ 1. Natural Language Prompt ┌───────────────────────┐ │ Console AI Orchestrator │ ─────────────────────────────────────>│ Ollama (qwen2.5:1.5b) │ │ (SharePointMcpClient) │ <──────────────────────────────────── │ (Local GPU Inference) │ └───────────────┬────────────────┘ 2. Tool Call Request (JSON) └───────────────────────┘ │ │ 3. Execute Tool via MCP (CallToolAsync) ▼ ┌────────────────────────────────┐ │ C# SharePoint MCP Server │ ───> Microsoft Graph API ───> SharePoint Online │ (SharePointMcpServer Web API)│ └────────────────────────────────┘

---

## 📁 Repository Structure

```text
.
├── SharePointMcpServer/          # ASP.NET Core Web API implementing MCP Server tools
│   ├── Controllers/             # MCP endpoints (/mcp)
│   ├── Services/                # SharePoint Graph API service methods
│   └── appsettings.json         # Azure Entra ID configuration
│
└── SharePointMcpClient/          # .NET 9 Console App (AI Orchestrator)
    └── Program.cs               # Interactive CLI with automatic tool invocation

---

📋 Prerequisites

• .NET 9 SDK
• Ollama installed locally
• Microsoft Entra ID (Azure AD) Tenant with Application Permissions to SharePoint/Graph API

---

⚙️ Setup & Configuration

1. Microsoft Entra ID (Azure AD) Setup

1. Go to the Microsoft Entra Admin Center (https://entra.microsoft.com/).
2. Navigate to Identity -> Applications -> App registrations -> New registration.
3. Name your application (e.g., SharePoint-MCP-Server) and select Single Tenant.
4. Note the Application (Client) ID and Directory (Tenant) ID.
5. Under Certificates & secrets, generate a new Client Secret and copy its Value.
6. Under API permissions, add the following Microsoft Graph Application Permissions:

• Sites.Read.All
• Files.Read.All

7. Click Grant admin consent for [Your Organization].

---

2. Configure Server (SharePointMcpServer)

Open SharePointMcpServer/appsettings.json and enter your Azure AD credentials:

"AzureEntra": {
  "Instance": "https://login.microsoftonline.com/",
  "TenantId": "",
  "ClientId": "",
  "ClientSecret": "",
  "Scopes": [ "https://graph.microsoft.com/.default" ]
},

---

3. Setup Ollama Model

Pull the recommended lightweight model for fast local tool execution (~1.2 GB VRAM footprint):

ollama pull qwen2.5:1.5b

Tip (Disk Space Optimization): To store Ollama models on a secondary drive (e.g., D:\OllamaModels), set the environment variable:

setx OLLAMA_MODELS "D:\OllamaModels"

---

🚀 Running the Solution

Step 1: Start the MCP Server

Navigate to the server directory and run:

cd SharePointMcpServer
dotnet run

The server will start listening at https://localhost:7149 (or your configured port).

---

Step 2: Start the AI Orchestrator Console App

In a separate terminal, navigate to the client directory and run:

cd SharePointMcpClient
dotnet run

---

💬 Usage Flow

1. Domain Onboarding: When prompted, enter your SharePoint tenant URL (e.g., https://yourtenant.sharepoint.com/).
2. Site Selection: The console runner calls list_sites directly and displays an interactive menu of all accessible sites.
3. Natural Language Querying: Select a site index (e.g., 1), then ask questions naturally without manually supplying site IDs:

[Main Site] User > list libraries
[Main Site] User > show recent documents
[Main Site] User > search documents for 'invoice'

---

🛠️ Key Technical Features

• Interactive Site Context Management: Automatically discovers tenant sites and retains active siteId context across multi-turn user queries.

• Middleware Integration: Utilizes Microsoft.Extensions.AI with .UseFunctionInvocation() middleware for automatic two-way execution between Ollama and MCP tools.

• Defensive Parameter Normalization:

• Handles key casing remappings (e.g., site_id -> siteId).

• Unwraps JsonElement primitive wrappers.

• Employs Regex lookahead sanitization to clean composite site IDs without corrupting server-relative URL paths.

• Deterministic Tool Binding: Configured with Temperature = 0.0f and strict context limits for accurate schema mapping.

---

🧪 Testing Endpoints Directly via Postman

You can test MCP endpoints directly via HTTP POST to https://localhost:7149/mcp:

Payload Example (list_libraries):

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "list_libraries",
    "arguments": {
      "siteId": "yourtenant.sharepoint.com,guid-1,guid-2"
    }
  }
}

---