Microsoft SharePoint

Connect to Microsoft SharePoint sites, document libraries, lists, and pages to search and manage content. AI agents can directly search and utilize documents stored in your organization’s SharePoint.

Key Features

• Browse SharePoint sites and document libraries
• Read, create, move, copy, and delete files/folders
• Generate sharing links and send sharing invitations
• Create and manage list items (CRUD)
• View and create site pages
• Search content using KQL syntax
• View and restore recycle bin items

Basic Information

Authentication

OAuth 2.0 (Microsoft Entra ID)

Required Permissions

• Sites.ReadWrite.All: Read/write sites, lists, drives, and files
• Sites.Manage.All: Manage site structure including lists and pages

Supported MCP Tools

Site Management

findSite

Search for SharePoint sites accessible to the user. Returns a list of top accessible sites when called without a search query.

getSite

Get site details by site ID, special path (e.g. root), or hostname:path format. Use includeSubsites to also return child sites.

Document Libraries

listDocumentLibraries

List document libraries in a SharePoint site. Set defaultOnly to true to return only the default document library.

Files and Folders

listFolderContents

List files and subfolders in a folder within a document library. Returns up to 20 items.

getItemInfo

Get metadata for a file or folder. Use includeVersions for version history and includePermissions for sharing permission details.

readFile

Read file content from a document library. Automatically detects text and binary content. Use saveToTemp for binary/image files to save as an aip-temp:// URI.

createFileOrFolder

Create a file or folder in a document library. Set isFolder=true for folders. For files, specify encoding as text (default) or base64 to upload content.

manageItem

Manage a file or folder. Supported actions:

• rename: Rename (newName required)
• move: Move (newParentFolderId required)
• copy: Copy (newParentFolderId required)
• delete: Delete

shareItem

Create a sharing link or send an email invitation for a file or folder.

• Sharing link: Specify type (view/edit) and scope (organization/anonymous)
• Email invitation: Provide email address

Lists

createList

Create a new SharePoint list in a site with a display name and list template type.

listLists

List SharePoint lists in a site. Specify listId with includeColumns/includeContentTypes to get schema details for a specific list.

queryListItems

Query list items. Use itemId for a single item, or OData filter/select/expand for multiple items.

saveListItem

Create or update a list item. Omit itemId to create a new item, or provide it to update an existing one. Uses Key/Value field format.

deleteListItem

Delete a list item.

manageItemComments

List or add comments on a list item. Omit comment to list existing comments; provide it to add a new comment.

Pages

createPage

Create a new modern SharePoint page in a site with a title and optional description.

getPages

List site pages. Specify pageId to get detailed content including web parts for a specific page.

Search

searchContent

Search content across sites, list items, and drive items using KQL (Keyword Query Language) syntax.

Recycle Bin

manageRecycleBin

View or restore deleted items in a site’s recycle bin. Specify recycleBinItemId with action='restore' to restore a specific item.

Usage Examples

• A user enters the prompt “Find the 2025 sales report in the SharePoint Sales team site”.
• The LLM calls the searchContent tool via MCP to perform a KQL search.
• It then responds in chat based on the tool call results.

Other usage examples:

• “Read the contract file in the document library”
• “Create a ‘meeting-notes.docx’ file in the project folder”
• “Show me the list of recently deleted files”

Notes

• A Microsoft 365 account and appropriate SharePoint permissions are required.
• Deleted files are moved to the recycle bin and can be restored using manageRecycleBin.