Integrations
Required runtime environment for the MCP server to operate, with version 22.14.0 or later specified as necessary for installation.
Used for defining app permission requests when setting up SharePoint app access, enabling specification of security scopes and access rights.
SharePoint Online MCP Server
This is a MCP server for Claude Desktop that allows you to interact with SharePoint Online using the SharePoint REST API. It is designed to be used with the Claude Desktop app, but could be used by other MCP clients as well.
Implementation
Component | Operation | Available |
---|---|---|
Users | ❌ | |
Get User | ❌ | |
Sites | ❌ | |
List Sites | ❌ | |
Get Site Details | ✅ | |
Create Subsite | ❌ | |
Delete Site | ❌ | |
Lists | ❌ | |
Get All Lists | ✅ | |
Create List | ❌ | |
Read List | ❌ | |
Add to List | ❌ | |
Update List | ❌ | |
Delete List | ❌ | |
List Items | ❌ | |
Get All List Items | ✅ | |
Add Mock Items | ✅ | |
Add List Item | ❌ | |
Update List Item | ❌ | |
Delete List Item | ❌ |
Configuration steps
⚠️ You need to be a SharePoint tenant admin or a global admin to create a SharePoint app.
Allow SharePoint-only apps
- Download and install the SharePoint Online Management Shell from here.
- Open PowerShell and run the following command to make sure the SharePoint-only apps are enabled:
Create SharePoint-only App
- Open https://.sharepoint.com/_layouts/15/appregnew.aspx
- click
Generate
to create a new client ID and secret. - Fill in the following fields:
- App Domain:
www.example.com
(or any domain you own) - Redirect URL:
http://example.com
- App Domain:
- Click
Create
to create the app. - Copy the
Client ID
andClient Secret
values to a safe place. You will need them later.
Grant App Permissions
- Open https://.sharepoint.com/_layouts/15/appinv.aspx
- Paste the
Client ID
value in theApp Id
field and clickLookup
. - Paste the following XML in the
App Permission Request XML
field:
- Click
Create
and thenTrust It
to grant the app permissions.
Install Node.js
Install node.js version: 22.14.0 or later
Install abd Configure Claude Desktop
- Download Claude Desktop and install it.
- In Claude Desktop, go to
File
>Settings
>Developer
. - Click Edit Config
- Open the claude_desktop_config.json config file in the editor.
- Paste the following to the config and update the
mcpServers
section with your own values:
- Save the config file and restart Claude Desktop. Make sure to quick the app completely via the tasks tray icon:
How to "talk" to the MCP Server
- Open Claude Desktop and ask a question like
Get me the list of lists from https://<your-tenant>.sharepoint.com/sites/Dashboard-Communication. Present the results in a table form. don't use code
.
For contributors
- Build a new npm package
Run MCP Inspector locally
npx @modelcontextprotocol/inspector node build/index.js
You must be authenticated.
local-only server
The server can only run on the client's local machine because it depends on local resources.
Allows Claude to interact with SharePoint Online using the REST API, enabling users to query site information, lists, and list items through natural language commands.
Related MCP Servers
- AsecurityAlicenseAqualityEnables Claude to interact with Ethereum nodes, allowing users to check ENS token balances, view smart contract code, and decode transactions through natural language.Last updated -51JavaScriptMIT License
- AsecurityAlicenseAqualityEnables Claude to interact with Webflow's APIs for managing sites, retrieving information, and executing tasks using natural language.Last updated -24TypeScriptMIT License
- AsecurityFlicenseAqualityA server that enables Claude Desktop users to access the Claude API directly, allowing them to bypass Professional Plan limitations and use advanced features like custom system prompts and conversation management.Last updated -15Python
- -securityAlicense-qualityEnables Claude to interact with Webflow's APIs, allowing access to site information, collections, and other Webflow resources.Last updated -TypeScriptMIT License