SharePoint
MCP Servers

Configured Servers

Both servers are defined in .vscode/mcp.json in the appRepo workspace and connect using your M365 tenant ID.

Setup

Config file

Both servers are declared in c:\appRepo\.vscode\mcp.json:

{
  "servers": {
    "sharepoint-files": {
      "type": "http",
      "url": "https://agent365.svc.cloud.microsoft/agents/tenants/24528d2a-bbba-4be5-8de3-1bb70cb01654/servers/mcp_ODSPRemoteServer"
    },
    "sharepoint-lists": {
      "type": "http",
      "url": "https://agent365.svc.cloud.microsoft/agents/tenants/24528d2a-bbba-4be5-8de3-1bb70cb01654/servers/mcp_SharePointListsTools"
    }
  }
}

Authentication

VS Code prompts for sign-in with your Microsoft 365 account on first use. No tokens or secrets are stored in the config file.

Requirements

• VS Code 1.99 or later (MCP support built-in)
• Microsoft 365 / SharePoint Online subscription on tenant 24528d2a-bbba-4be5-8de3-1bb70cb01654
• Network access to agent365.svc.cloud.microsoft

Usage in Copilot

Asking about files

# List SharePoint sites
"List all SharePoint sites in my tenant"

# Search for a document
"Find documents about quarterly reports in SharePoint"

# Get a file
"Show me the contents of Budget.xlsx from the Finance site"

Working with lists

# List all lists on a site
"Show me all lists on the HR SharePoint site"

# Read list items
"Get all open tickets from the IT Support list"

# Add an item
"Add a new item to the Project Tasks list with title 'Deploy MCP'"

References