Microsoft SharePoint MCP Server

List Sites

List all SharePoint sites that the authenticated user has access to. This returns a comprehensive list of sites across the organization, making it ideal for discovering available SharePoint sites. Use this when you need to see all accessible sites or when you're not sure which site contains the information you're looking for.

Get Site

Get detailed information about a specific SharePoint site by its ID. This retrieves site metadata including display name, description, web URL, creation date, and other properties. Use this when you have a site ID and need to get its details or verify site information.

Search Sites

Search for SharePoint sites by keyword or phrase. This performs a full-text search across site names, descriptions, and other metadata. Use this when you're looking for sites related to a specific topic, project, or team but don't know the exact site name or ID.

Get Site by Path

Get a SharePoint site by its hostname and server-relative path. This is useful when you know the site's URL structure. For example, to access a site at 'https://contoso.sharepoint.com/sites/marketing', you would use hostname 'contoso.sharepoint.com' and path '/sites/marketing'.

List Subsites

List all subsites (child sites) of a parent SharePoint site. Subsites are sites that exist within the hierarchy of a parent site. Use this to explore the site structure and discover nested sites within a site collection.

List Documents

List all documents and folders in a SharePoint document library. By default, this lists items in the root folder of the default document library. You can optionally specify a folder path to list contents of a specific folder. Returns file metadata including name, size, creation date, modification date, and web URLs.

Get Document

Get detailed metadata and download information for a specific document. Returns comprehensive information including file name, size, MIME type, creation/modification dates, download URL, web view link, and sharing information. Use this to retrieve a file's properties or to get a download link.

Search Documents

Search for documents and files within a SharePoint site's document library. Performs full-text search across file names, content, and metadata. This is useful when you need to find specific files but don't know their exact location or when searching for files containing specific keywords.

Upload Document

Upload a new file to a SharePoint document library. You can upload to the root folder or specify a folder path. The file content should be provided as base64-encoded data. For files larger than 4MB, consider using upload sessions (not currently supported). Returns the newly created file's metadata including its ID.

Update Document

Update the content of an existing document in SharePoint. This replaces the entire file content. The new content should be provided as base64-encoded data. This operation preserves the file's ID and metadata while updating only the content. For files larger than 4MB, consider using upload sessions (not currently supported).

Delete Document

Permanently delete a document or file from SharePoint. This operation cannot be easily undone (the file may be in the recycle bin for a period). Use with caution. This works for both files and folders - deleting a folder will delete all its contents.

Create Folder

Create a new folder in a SharePoint document library. You can create folders in the root of the library or within existing folders. This is useful for organizing documents into a hierarchical structure. Returns the newly created folder's metadata including its ID.

List Site Lists

Get all SharePoint lists in a site. This includes custom lists, task lists, calendar lists, and other list types but excludes document libraries. Returns basic information about each list including name, description, list template type, and item count. Use this to discover what lists are available in a site.

Get List

Get detailed information about a specific SharePoint list including its display name, description, list template, column definitions, content types, and configuration settings. Use this when you need to understand a list's structure before querying or modifying its items.

List Items

Get all items from a SharePoint list. Returns the items with their field values expanded. You can optionally filter and sort the results using OData query parameters. This is useful for retrieving data from custom lists, task lists, or any other SharePoint list type.

Create List Item

Create a new item in a SharePoint list. Provide the field values as a JSON object where keys are the internal field names and values are the field values. For example: {'Title': 'New Task', 'Status': 'Not Started', 'Priority': 'High'}. Returns the newly created item with its ID.

Update List Item

Update an existing item in a SharePoint list. Provide the field values to update as a JSON object. Only the fields you specify will be updated; other fields remain unchanged. For example: {'Status': 'Completed', 'CompletedDate': '2024-03-15'}. Returns the updated item.

Delete List Item

Delete an item from a SharePoint list. This permanently removes the item from the list. Use with caution as this operation cannot be easily undone. The item may be recoverable from the site's recycle bin for a period of time.

List Pages

List all site pages in a SharePoint site. Site pages are the modern pages used to create content in SharePoint. This returns information about each page including its name, title, web URL, creation date, and publication status. Use this to discover what pages exist in a site.

Get Page

Get the content and metadata of a specific SharePoint site page. This returns the page's title, description, web parts, layout information, and full content. Use this to read the content of a page or to understand its structure before making updates.

Create Page

Create a new site page in SharePoint. You can specify the page name, title, and page layout type. The page is created as a draft and can be published later. This creates a modern SharePoint page with a blank layout that you can populate with content.

List Permissions

List all permissions on a SharePoint site or item. This returns information about who has access to the site/item, their permission levels (roles), and whether permissions are inherited or directly assigned. Use this to audit access or understand the current permission structure.

Create Sharing Link

Create a sharing link for a file or folder in SharePoint. This generates a URL that can be shared with others to provide access to the item. You can specify the link type (view, edit, or embed) and scope (anonymous, organization, or specific users). Returns the sharing link URL and other details.

Grant Access

Grant access to a file or folder by sending an invitation to specific users or groups. This sends an email invitation with a link to the item and assigns the specified permission level. Use this when you need to give specific people access to a file or folder with notification.

Remove Permission

Remove a specific permission from a file or folder. This revokes access that was previously granted to a user, group, or sharing link. You need the permission ID, which can be obtained from the 'List Permissions' tool. Use this to revoke access when it's no longer needed.