How to connect Sharepoint to Claude Code

1. 1. Enable Sharepoint in Metorial

   In your Metorial portal, enable the Sharepoint MCP server and sign in with the account that owns the data. Access stays governed by your team policies.

2. 2. Add the server over HTTP

   Add --scope user to use it in every project.

   Copy

   claude mcp add --transport http metorial <your-magic-mcp-url>

3. 3. Sign in

   Run /mcp, select Metorial and sign in to load Sharepoint tools.

• Get Site: Retrieve detailed information about a SharePoint site.
• Manage List: Create, read, update, or delete SharePoint lists within a site.
• Manage Columns: List, create, update, or delete column definitions (fields) on a SharePoint list.
• Manage File: Upload, download, move, copy, rename, or delete files and folders in a SharePoint document library.
• Search Drive: Search for files and folders within a specific SharePoint document library (drive).
• Get File Versions: Retrieve the version history of a file in a SharePoint document library.
• List Sites: Search for SharePoint sites by keyword, or list subsites of a given site.
• Manage Permissions: View, grant, and revoke permissions on SharePoint files and folders.
• Search: Search across SharePoint content using the Microsoft Search API.
• Get Drives: Retrieve document libraries (drives) for a SharePoint site.
• Manage List Items: Full CRUD operations on SharePoint list items.
• Get Content Types: Retrieve content types and site columns for a SharePoint site.
• Get Site User: Resolve a user email or UPN to the numeric SharePoint site-scoped user ID required for Person/Group list column LookupId fields.

• Sharepoint tools appear as mcp__metorial__<tool>. Use that name in permission rules to allow or deny a tool.
• Run /mcp to see whether Metorial is connected and to sign in again.
• Claude Code warns when a tool result passes 10,000 tokens and caps it at 25,000 by default. Raise the cap with MAX_MCP_OUTPUT_TOKENS.
• Pre-approve trusted Sharepoint tools with allow rules in your settings so Claude Code stops asking each time.

claude mcp list shows "Needs authentication"

Run /mcp, select Metorial, and sign in. If sign-in keeps failing, choose Clear authentication in the same menu and sign in again.

A teammate sees "Pending approval"

Servers shared through a project .mcp.json need approval. Run claude in the project and approve Metorial when asked.

Large tool results are cut off

Claude Code limits MCP tool output to 25,000 tokens by default. Raise it with the MAX_MCP_OUTPUT_TOKENS environment variable.

Based on the Claude Code MCP documentation.