mcp-sharepoint

A Model Context Protocol (MCP) server that exposes core Microsoft SharePoint / Microsoft Graph API functionalities as tools usable by LLM agents (e.g. Claude Desktop).

This server is designed with an agent-first approach:

• no direct access to the local filesystem
• deterministic inputs and outputs

✨ Features

The server allows an agent to:

📁 Folder management

A path can/must be passed as an argument

• List folders
• Create new folder
• Delete folder (only if empty)
• Retrieve the folder tree structure

📄 Document management

A path can/must be passed as an argument

• List documents
• Read document content (PDF, Word, Excel, PowerPoint)
• Upload new document (text or binary)
• Update an existing document (replace the full content)
• Delete document

🔐 Prerequisites

• Node.js ≥ 18
• A Microsoft 365 tenant
• An app registered in Microsoft Entra ID with Graph permissions

Recommended Graph permissions

Sites.Read.All
Sites.ReadWrite.All
Files.Read.All
Files.ReadWrite.All

⚠️ Use Application permissions

• Authentication through Microsoft Entra ID App Registration
• All operations are performed via Microsoft Graph

Sharepoint guide

1. On Sharepoint, click on the left "app registration"
2. Click on top "New registration"
3. Insert a name and click "Register"
4. Open the new registered app, by clicking on its name in "app registration"
5. On top you can see the client id and tenant id
6. Click on top-right "Client credentials: 0 certificates, 0 secrets"
7. Click on "New client secret"
8. Insert the desired description and expire time, and click "Add"
9. In the table there will be the new client secret, copy the "Value" field.

⚠️You can copy it only once, after you will not be able to see the "Value" again

10. The copied "Value" is the client secret
11. Go to the following url: https://graph.microsoft.com/v1.0/sites/_yourdomain_.sharepoint.com:/sites/_yoursitename_ and copy the white/plain "id" value, this is the site id

⚠️You need to pass the access token as header param, Authorization: access_token

12. Go to the following url: https://_yourdomain_.sharepoint.com/sites/_yoursite_/_api/v2.0/drives and copy the "id" value of the desired drive, this is the drive id
13. Go to the following url: https://_yourdomain_.sharepoint.com/sites/_yoursite_/_api/v2.0/drives/_yourdriveid_/list and copy the "id" value of the desired list, this is the list id

⚙️ Configuration

The authorization is obtained using app variables. The agent needs to send these variables in every call.

Required app variables

| Variable | Description | | ------------- | ---------------------------------------- | | tenantId | Microsoft Entra directory tenant ID | | clientId | Microsoft Entra app client ID | | clientSecret| Microsoft Entra client secret |

Other common variables needed. These depends on the Sharepoint you are using.

| Variable | Description | | ------------- | ---------------------------------------- | | siteId | Sharepoint full site ID | | driveId | Sharepoint drive ID | | listId | Sharepoint list ID |

🧰 Available MCP tools

common parameters

// Microsoft Entra ID app authentication parameters

authParams: {
  {
    "name": "clientId",
    "type": "string",
    "required": "true",
    "descrciption": "The application (client) ID",
    "example": "ab12cd34-e5f6-g7h8-i9j9-ab12cd34e5f6"
  },
  {
    "name": "clientSecret",
    "type": "string",
    "required": "true",
    "descrciption": "The client secret",
    "example": "1~A1B~aB12Cd34E5f6aB12cd34E5f6ab~d37cD37"
  },
  {
    "name": "tenantId",
    "type": "string",
    "required": "true",
    "descrciption": "The directory (tenant) ID",
    "example": "ab12cd34-e5f6-g7h8-i9j9-ab12cd34e5f6"
  }
}

// SharePoint site and drive identifiers

siteDriveParams: {
  {
    "name": "siteId",
    "type": "string",
    "required": "true",
    "descrciption": "The ID of the SharePoint site",
    "example": "namexyz.sharepoint.com,ab12cd34-e5f6-g7h8-i9j9-ab12cd34e5f6,fb12cd34-e5f6-g7h8-i9j9-ab12cd34e5f9"
  },
  {
    "name": "driveId",
    "type": "string",
    "required": "true",
    "descrciption":" The ID of the drive within the SharePoint site",
    "example": "f!aB12Cd34E5f6aB12cd34E5f6abd37cD37aB12Cd34E5f6aB12cd34E5f6abd3712"
  }
}

📁 Folders

getFolders

List folders in a given path.

Input:

{
  "name": "auth",
  "type": "authParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "siteDrive",
  "type": "siteDriveParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "path",
  "type": "string",
  "required": "true",
  "descrciption": "The path in SharePoint to retrieve folders from",
  "example": "cartella_1/cartella_2"
}

createFolder

Create a new folder.

Input:

{
  "name": "auth",
  "type": "authParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "siteDrive",
  "type": "siteDriveParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "path",
  "type": "string",
  "required": "true",
  "descrciption": "The parent path where the folder will be created",
  "example": "cartella_1/cartella_2"
},
{
  "name": "folderName",
  "type": "string",
  "required": "true",
  "descrciption": "The name of the new folder to create",
  "example": "cartella_3"
}

deleteFolder

Delete a folder only if it is empty.

Input:

{
  "name": "auth",
  "type": "authParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "siteDrive",
  "type": "siteDriveParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "path",
  "type": "string",
  "required": "true",
  "descrciption": "The path to the folder to delete",
  "example": "cartella_1/cartella_2/cartella_3"
}

getFolderTree

Retrieve the folder tree structure.

Input:

{
  "name": "auth",
  "type": "authParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "siteDrive",
  "type": "siteDriveParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "path",
  "type": "string",
  "required": "false",
  "descrciption": "The starting path (default: 'root')",
  "example": "cartella_1/cartella_2"
},
{
  "name": "maxDepth",
  "type": "number",
  "required": "false",
  "descrciption": "Maximum depth to traverse (default: 10)",
  "example": 5
}

📄 Documents

getDocuments

List documents in a folder.

Input:

{
  "name": "auth",
  "type": "authParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "siteDrive",
  "type": "siteDriveParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "path",
  "type": "string",
  "required": "true",
  "descrciption": "The path in SharePoint to retrieve documents from",
  "example": "cartella_1/cartella_2"
}

getDocumentContent

Retrieve and extract the textual content of a document.

Supported formats:

• Native PDFs
• Word / Excel / PowerPoint (converted to PDF via Graph)

Input:

{
  "name": "auth",
  "type": "authParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "siteDrive",
  "type": "siteDriveParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "filePath",
  "type": "string",
  "required": "true",
  "descrciption": "The path to the file",
  "example": "cartella_1/cartella_2/file.txt"
}

uploadDocument

Upload a new document.

Input:

{
  "name": "auth",
  "type": "authParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "siteDrive",
  "type": "siteDriveParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "filePath",
  "type": "string",
  "required": "true",
  "descrciption": "The path where the file will be uploaded",
  "example": "cartella_1/cartella_2"
},
{
  "name": "content",
  "type": "string",
  "required": "true",
  "descrciption": "The string or base64-encoded content of the file to upload",
  "example": "Questo è il testo del doc .txt"
},
{
  "name": "contentType",
  "type": "string",
  "required": "false",
  "descrciption": "The MIME type of the content (default: 'application/octet-stream')",
  "example": "application/octet-stream"
},
{
  "name": "overwrite",
  "type": "boolean",
  "required": "false",
  "descrciption": "Whether to overwrite existing files (default: false)",
  "example": true
}

updateDocumentContent

Fully update an existing document.

⚠️ The operation replace the full content of the file.
⚠️ The operation fails if the file does not exist.

Input:

{
  "name": "auth",
  "type": "authParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "siteDrive",
  "type": "siteDriveParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "filePath",
  "type": "string",
  "required": "true",
  "descrciption": "The path to the existing file to update",
  "example": "cartella_1/cartella_2"
},
{
  "name": "content",
  "type": "string",
  "required": "true",
  "descrciption": "The new string or base64-encoded content of the file",
  "example": "Questo è il nuovo testo del doc .txt"
},
{
  "name": "contentType",
  "type": "string",
  "required": "false",
  "descrciption": "The MIME type of the content (default: 'application/octet-stream')",
  "example": "application/pdf"
}

deleteDocument

Delete a document (moved to the SharePoint recycle bin).

Input:

{
  "name": "auth",
  "type": "authParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "siteDrive",
  "type": "siteDriveParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "filePath",
  "type": "string",
  "required": "true",
  "descrciption": "The path to the file to delete",
  "example": "cartella_1/cartella_2/file.docx"
},

searchDocumentsByKeywords

Search for documents containing at least one of the keywords in the given attribute.

Input:

{
  "name": "auth",
  "type": "authParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "siteDrive",
  "type": "siteDriveParams",
  "required": "true",
  "descrciption": "refer to the `common parameters` section",
  "example": "refer to the `common parameters` section"
},
{
  "name": "listId",
  "type": "string",
  "required": "true",
  "descrciption": "The ID of the SharePoint list to search in",
  "example": "ab12cd34-e5f6-g7h8-i9j9-ab12cd34e5f6"
},
{
  "name": "keywords",
  "type": "Array<string>",
  "required": "true",
  "descrciption": "Array of keywords to search for",
  "example": "["word_1", "word_2", "word_3"]"
},
{
  "name": "attributeName",
  "type": "string",
  "required": "true",
  "descrciption": The document attribute to search in",
  "example": "name"
},

🚀 Try it on Aisuru!

This MCP server is easily integrated into aisuru, our AI agent platform where you can create, test, and deploy intelligent agents with access to powerful tools like this mcp-sharepoint server.

Visit Aisuru.com to start building with your agents today!

⚠️ Known limitations

• Partial document updates are not supported
• Large files (>4MB) require upload sessions (not yet implemented)
• Text extraction from complex PDFs/Excel files may lose structure

🔒 Security

• Never expose client secret publicly
• Rotate secrets regularly
• Grant the minimum required Graph permissions