Microsoft 365 SharePoint MCP server reference

Important

• This is a preview feature.
• Preview features aren't meant for production use and might have restricted functionality. These features are subject to supplemental terms of use, and are available before an official release so that customers can get early access and provide feedback.

Overview

Server ID	Display name	Description
mcp_SharePointRemoteServer	Microsoft SharePoint MCP server	MCP server for SharePoint operations. Use this server for managing sites, lists, list items, columns, document libraries, files, folders, and file sharing. File operations are limited to ≤5MB.

Note

The Microsoft SharePoint and OneDrive MCP server is deprecated starting March 13, 2026. If it's an existing connection, it's still supported. To set up new connections, use the new Microsoft SharePoint MCP Server and the Microsoft OneDrive MCP Server.

Available tools

findSite

Find SharePoint sites accessible to the user. Returns specific sites matching a search query, or the top 20 relevant sites if no query is provided.

Optional parameters:

• searchQuery: Search query (entire or partial site name). Omit to return top 20 accessible sites

getSiteByPath

Resolve a SharePoint site using its exact hostname and server-relative path. Use only when you have the complete site URL structure. Use findSite when only a site name is known.

Required parameters:

• hostname: Exact hostname (for example, 'contoso.sharepoint.com')
• serverRelativePath: Server-relative path (for example, 'sites/Marketing'). The leading slash is optional.

listSubsites

List all subsites (child sites) of a SharePoint site.

Required parameters:

• siteId: ID of the parent SharePoint site (format: 'hostname,siteCollectionId,webId')

listDocumentLibrariesInSite

List document libraries (drives) in the specified SharePoint site.

Optional parameters:

• siteId: ID of the SharePoint site (default: 'root')

getDefaultDocumentLibraryInSite

Get the default document library (drive) in a SharePoint site.

Optional parameters:

• siteId: ID of the SharePoint site (default: 'root')

getFolderChildren

Enumerates top 20 files and folders (DriveItems) contained within a specified parent folder in a document library (drive).

Required parameters:

• documentLibraryId: ID of the document library (drive)

Optional parameters:

• parentFolderId: ID of the parent folder (default: 'root')

findFileOrFolder

Finds a file or folder (DriveItem) accessible to the user by search query. Searches across all sites and document libraries the user has access to.

Required parameters:

• searchQuery: Search query (entire or partial file name)

getFileOrFolderMetadata

Get metadata of a file or folder (DriveItem) from a specified document library (drive) in SharePoint.

Required parameters:

• fileOrFolderId: ID of the file or folder (DriveItem)
• documentLibraryId: ID of the document library (drive)

getFileOrFolderMetadataByUrl

Get metadata of a file or folder from a sharing URL. Only users with existing explicit permissions to access the file will be allowed.

Required parameters:

• fileOrFolderUrl: URL of the file or folder. The URL will not be redeemed to share it with the user; they must already have explicit access

readSmallTextFile

Read (download) a text file of size less than 5MB from a specific document library (drive).

Required parameters:

• fileId: ID of the file (DriveItem) to read/download
• documentLibraryId: ID of the document library (drive)

readSmallBinaryFile

Read a binary file of size less than 5MB from a specific document library (drive). File content is returned as a base64-encoded string.

Required parameters:

• fileId: ID of the file (DriveItem) to read/download
• documentLibraryId: ID of the document library (drive)

createSmallTextFile

Create or upload a text file of size less than 5MB to a specific document library (drive).

Required parameters:

• filename: Name of the file including extension
• contentText: Text content of the file
• documentLibraryId: ID of the document library (drive)

Optional parameters:

• parentfolderId: ID of the parent folder (default: 'root')

createSmallBinaryFile

Create a binary file of size less than 5MB by base64-encoding its content to a specific document library (drive).

Required parameters:

• filename: Name of the file including extension
• base64Content: Binary file content encoded as a base64 string
• documentLibraryId: ID of the document library (drive)

Optional parameters:

• parentfolderId: ID of the parent folder (default: 'root')

createFolder

Create a new folder (DriveItem) within a specified document library (drive). If a folder with the same name exists, a numeric suffix is added (for example, NewFolder (1)).

Required parameters:

• folderName: Name of the folder
• documentLibraryId: ID of the document library (drive)

Optional parameters:

• parentFolderId: ID of the parent folder (default: 'root')

renameFileOrFolder

Rename a file or folder (DriveItem) within a specified document library (drive). The new name must comply with naming conventions.

Required parameters:

• documentLibraryId: ID of the document library (drive)
• fileOrFolderId: ID of the file or folder to rename
• newFileOrFolderName: The new name

Optional parameters:

• etag: ETag for concurrency control

deleteFileOrFolder

Delete a file or folder (DriveItem) from a specified document library (drive).

Required parameters:

• documentLibraryId: ID of the document library (drive)
• fileOrFolderId: ID of the file or folder to delete

Optional parameters:

• etag: ETag for concurrency control

moveSmallFile

Move a file (DriveItem) to another folder within the same document library. Only supports files less than 5MB. Cannot move between drives.

Required parameters:

• documentLibraryId: ID of the document library (drive)
• fileId: ID of the file to move
• newParentFolderId: ID of the target folder (must be in the same document library)

Optional parameters:

• etag: ETag for concurrency control

copyFileOrFolder

Copy a file or folder (DriveItem) to a destination folder. Supports copying across different document libraries within SharePoint. This operation is asynchronous; use checkOperationStatus to monitor progress.

Required parameters:

• sourcedoclibid: ID of the source document library (drive)
• sourcefileid: ID of the source file or folder to copy
• destdoclibid: ID of the destination document library (drive)
• destfolderid: ID of the destination folder (must exist)

Optional parameters:

• newfilename: New name for the copied item

checkOperationStatus

Check the status of an asynchronous operation (such as a copy) using the operation token returned from the original operation.

Required parameters:

• operationToken: The operation token returned from an async operation like copyFileOrFolder

uploadFileFromUrl

Upload a file from a SharePoint or OneDrive URL to a destination folder in a document library (drive). The file is copied from the source URL; no changes are made to the original.

Required parameters:

• sourceUrl: Source URL (must be a valid SharePoint or OneDrive URL)
• destinationDocumentLibraryId: ID of the destination document library. Use 'me' for the user's OneDrive

Optional parameters:

• destinationFolderId: ID of the destination folder (default: 'root')
• filename: New filename; defaults to the original filename

shareFileOrFolder

Sends a sharing invitation to grant read/write permissions on a file or folder (DriveItem) within a specified document library (drive).

Required parameters:

• documentLibraryId: ID of the document library (drive)
• fileOrFolderId: ID of the file or folder to share
• recipientEmails: Array of email addresses of recipients
• roles: Array of roles: 'read', 'write' (write grants both read and write)

Optional parameters:

• message: Custom message for the invitation email (default: 'Here's the file we're collaborating on.')
• sendInvitation: Whether to send a sharing invitation (default: true)

setSensitivityLabelOnFile

Set the sensitivity label of a file from the specified document library (drive).

Required parameters:

• documentLibraryId: ID of the document library (drive)
• fileId: The driveItemId of the file
• sensitivityLabelId: ID of the sensitivity label, or empty string to remove

Optional parameters:

• assignmentMethod: Assignment method: 'standard', 'privileged', 'auto', or 'unknownFutureValue' (default: 'privileged')
• justificationText: Justification text for audit; required when downgrading or removing (default: 'Changed by MCPServer')

listLists

Get all SharePoint lists available on a specific site. Use to discover what lists exist within a site.

Required parameters:

• siteId: ID of the SharePoint site (format: 'hostname,siteCollectionId,webId')

createList

Create a new SharePoint list within a site.

Required parameters:

• siteId: ID of the SharePoint site
• displayName: Display name of the new list

Optional parameters:

• columns: Collection of columns as key-value pairs: [{ Key: 'JobTitle', Value: 'text' }]. Valid types: text, multilineText, number, boolean, dateTime, choice, lookup, personOrGroup, hyperlink, currency, calculated
• template: List template type (default: 'genericList'). Options: GenericList, DocumentLibrary, Events, Tasks, Announcements, Contacts, Links, Survey, IssueTracking, DiscussionBoard

deleteList

Delete a SharePoint list from a site. Deletes the entire list container and all items within it. Cannot be undone.

Required parameters:

• siteId: ID of the SharePoint site
• listId: ID of the list to delete

Optional parameters:

• etag: ETag for concurrency control

sendInviteForList

Sends a sharing invitation to grant permissions on a SharePoint list.

Required parameters:

• listId: ID of the SharePoint list to share
• recipientEmails: Array of email addresses of recipients
• role: Role: 'read' (view only), 'contribute' (view, add, update, delete items), 'edit' (full edit including list structure)

Optional parameters:

• siteUrl: Site URL of the SharePoint site containing the list
• sendEmail: Whether to send an email notification (default: true)

listListItems

Get items (rows/records) from a specific SharePoint list.

Required parameters:

• siteId: ID of the SharePoint site
• listId: ID of the SharePoint list

getListItem

Get a single item (row/record) from a SharePoint list by its ID.

Required parameters:

• siteId: ID of the SharePoint site
• listId: ID of the SharePoint list
• itemId: ID of the specific list item

createListItem

Create a new item (row/record) in a SharePoint list.

Required parameters:

• siteId: ID of the SharePoint site
• listId: ID of the SharePoint list
• fields: Key-value pairs for field values: [{ Key: 'Title', Value: 'Software Engineer' }, { Key: 'Department', Value: 'Engineering' }]. The 'Title' field is typically required

updateListItem

Update an existing item (row/record) in a SharePoint list. Only specified fields are updated; omitted fields retain their values.

Required parameters:

• siteId: ID of the SharePoint site
• listId: ID of the SharePoint list
• itemId: ID of the item to update
• fields: Key-value pairs of fields to update

Optional parameters:

• etag: ETag for concurrency control

deleteListItem

Delete an item (row/record) from a SharePoint list.

Required parameters:

• siteId: ID of the SharePoint site
• listId: ID of the SharePoint list
• itemId: ID of the item to delete

Optional parameters:

• etag: ETag for concurrency control

listColumns

Get all columns from a SharePoint list.

Required parameters:

• siteId: ID of the SharePoint site
• listId: ID of the SharePoint list

createColumn

Create a new column in a SharePoint list. Supports many column types including text, number, choice, dateTime, boolean, user, lookup, calculated, and more.

Required parameters:

• siteId: ID of the SharePoint site
• listId: ID of the SharePoint list
• name: Internal column name (programmatic identifier)
• columnType: Column type: text, note, number, integer, boolean, dateTime, choice, multichoice, currency, lookup, user, url, calculated, term, multiterm, location, geolocation, thumbnail, counter, computed, contentTypeId, file, attachment, guid, outcomeChoice, approvalStatus

Optional parameters:

• columnProperties: Type-specific settings (for example, { "maxLength": 255 } for text, { "choices": ["A","B","C"] } for choice)
• description: Description of the column
• displayName: Display name shown in UI (defaults to 'name')
• required: Make the column required (default: false)
• hidden: Hide column from views (default: false)

updateColumn

Update an existing column in a SharePoint list.

Required parameters:

• siteId: ID of the SharePoint site
• listId: ID of the SharePoint list
• columnId: ID of the column to update

Optional parameters:

• columnType: Column type (required when providing 'columnProperties')
• columnProperties: Type-specific properties to update
• description: New description
• displayName: New display name
• hidden: Hide or show column
• required: Make column required or optional

deleteColumn

Delete a column from a SharePoint list. Warning: Removes all data stored in that column for all items.

Required parameters:

• siteId: ID of the SharePoint site
• listId: ID of the SharePoint list
• columnId: ID of the column to delete

Key features

Site management

• Find sites by name or browse accessible sites
• Get site by exact URL path
• List child sites and subsites
• Comprehensive site hierarchy navigation

Document library management

• List all document libraries in a site
• Get default document library
• Browse folder contents (up to 20 items)
• Create and manage folder structures

File operations

• Create text and binary files (≤5MB)
• Read text and binary files (≤5MB)
• Delete, rename, and move files
• Copy files and folders across document libraries
• Upload files from SharePoint or OneDrive URLs
• Search for files and folders across all accessible sites
• Get file and folder metadata

Async operations

• Copy files and folders asynchronously across document libraries
• Check status of async operations using operation tokens

List operations

• Create, read, and delete lists
• Support for multiple list templates (generic, document library, events, tasks)
• Share lists with role-based permissions
• Manage list items (create, read, update, delete)

Column management

• Create columns with a wide variety of types (text, note, number, boolean, dateTime, choice, lookup, user, url, calculated, and more)
• Update column properties and metadata
• Configure column requirements and visibility
• Type-specific column properties

Sharing and permissions

• Share files, folders, and lists with users
• Role-based access control (read, write, contribute, edit)
• Email notifications for sharing
• Custom messages in invitations

Security and compliance

• Apply and remove sensitivity labels
• Multiple assignment methods (standard, privileged, auto)
• Audit justification support
• Concurrency control with eTags

Notes

• File operations are limited to ≤5MB for upload and download
• Move operations only work within the same document library
• Copy operations are asynchronous; use checkOperationStatus to monitor progress
• Copy operations support cross-library copying within SharePoint
• uploadFileFromUrl requires a valid SharePoint or OneDrive source URL
• eTags provide concurrency control for updates and deletes
• Automatic numeric suffix for duplicate folder names
• List deletion cannot be undone
• Column deletion removes all data stored in that column
• Search operations return top 20 results by default
• All operations use Microsoft Graph API

Note

MCP tool names and parameters are subject to change and hard-coded dependencies should be avoided. Scenario support will be maintained.