SharePoint Online MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
SHAREPOINT_CLIENT_IDYesThe client ID for your SharePoint app
SHAREPOINT_TENANT_IDYesYour SharePoint tenant ID from Entra ID
SHAREPOINT_CLIENT_SECRETYesThe client secret for your SharePoint app

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
getTitle

Get the title of a SharePoint website

getLists

Get the list of SharePoint lists along with their Titles, URLs, ItemCounts, last modified date, description and base templateID

getListItems

Get all items from a specific SharePoint list identified by site URL and list title

addMockData

Add mock data items to a specific SharePoint list

ID: ukikhn363m