Skip to Content

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

A Microsoft 365 account is required to connect to SharePoint. Contact your organization’s Microsoft 365 administrator for permission settings.

Supported MCP Tools

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

searchContent

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

Recycle Bin

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.

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.

queryListItems

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

manageRecycleBin

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

manageItemComments

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

Pages

manageItem

Manage a file or folder. Supported actions:

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

listLists

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

listFolderContents

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

listDocumentLibraries

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

Files and Folders

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

getPages

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

getItemInfo

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

findSite

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

deleteListItem

Delete a list item.

createPage

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

createList

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

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.

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.
Last updated on