SharePoint MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SITE_URL | Yes | Initial SharePoint site URL (e.g., https://contoso.sharepoint.com/sites/mysite) |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| set_siteA | Set the SharePoint site URL to work with. Must be called before any other tool if SITE_URL is not set in .env. |
| list_listsA | List all lists and document libraries in the SharePoint site. Returns name, id, type (list / documentLibrary), item count, etc. |
| get_list_schemaA | Get the full schema of a list or library: all columns (type, required, default, indexed), all views, and list metadata. Works on both lists (baseTemplate 100) and document libraries (101). |
| get_list_schema_xmlA | Export the full SharePoint SchemaXml of a list or library. The XML contains every field, view, content type, and JSON formatting definition. Useful for backup or cloning. |
| create_listA | Create a new SharePoint list or document library with optional columns and views. Columns are described using structured specs (type, choices, required, indexed, etc.). New columns are automatically added to the default view. |
| create_list_from_xmlA | Create a list from a full SharePoint SchemaXml string (e.g. obtained from get_list_schema_xml). Useful for cloning or restoring a list. |
| delete_listC | Permanently delete a list or document library. |
| get_itemsC | Query items in a list. Supports OData $filter, $select, $orderby, $top, $skip, $expand. |
| create_itemB | Create a new item in a list. Pass field values as key-value pairs using internal column names. For person fields use the format {FieldNameId: userId}. For date fields use ISO 8601 strings. |
| update_itemC | Update fields of an existing list item by its numeric ID. |
| delete_itemC | Delete a list item by its numeric ID. |
| add_columnB | Add a new column to an existing list or library. The column is automatically added to the default view unless addToDefaultView is false. |
| update_columnC | Update settings of an existing column (display name, description, required, default value, indexed, choices). |
| delete_columnA | Delete a column from a list (by internal name). Cannot delete read-only or sealed columns. |
| get_viewsC | List all views of a list or library with their columns, filters, and row limits. |
| create_viewC | Create a new view for a list or library with specified columns, row limit, and optional CAML filter. |
| update_viewC | Update an existing view: change columns, CAML query, row limit, or make it the default. |
| list_filesC | List files and sub-folders inside a document library or a specific folder within it. |
| upload_fileC | Upload a file to a document library. Content must be base64-encoded. |
| download_fileC | Download a file from SharePoint. Returns base64-encoded content. |
| delete_fileB | Permanently delete a file from a document library. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/LukasSevcik/sharepoint-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server