What Cursor can do with Sharepoint
Ask your agent in plain language. Each of these maps to a real tool on the server.
- Ask Cursor to use the manage list items tool in Sharepoint
- Ask Cursor to use the get content types tool in Sharepoint
- Ask Cursor to use the get site user tool in Sharepoint
- Ask Cursor to use the get site tool in Sharepoint
- Ask Cursor to use the manage list tool in Sharepoint
Add the Sharepoint MCP server to Cursor
Run these once. Afterwards, everyone you give access to signs in the same way.
1. Enable Sharepoint in Metorial
In your Metorial portal, enable the Sharepoint MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
2. Add Metorial to your MCP config
Use ~/.cursor/mcp.json for every project, or .cursor/mcp.json for one.
{"mcpServers": {"metorial": {"url": "<your-magic-mcp-url>"}}}3. Sign in
Open Customize in the sidebar, find Metorial and sign in to load Sharepoint tools.
Give your team Sharepoint in Cursor
Once Sharepoint is enabled in Metorial, teammates sign in with SSO and get the same connection in Cursor, with only the tools their role allows.
One link covers every app you approve. See how the MCP gateway handles access, roles and audit logs for the whole company.
Sharepoint tools available in Cursor
Full descriptions and inputs are on the Sharepoint MCP server page.
- Get Site: Retrieve detailed information about a SharePoint site.
- Manage List: Create, read, update, or delete SharePoint lists within a site.
- Manage Columns: List, create, update, or delete column definitions (fields) on a SharePoint list.
- Manage File: Upload, download, move, copy, rename, or delete files and folders in a SharePoint document library.
- Search Drive: Search for files and folders within a specific SharePoint document library (drive).
- Get File Versions: Retrieve the version history of a file in a SharePoint document library.
- List Sites: Search for SharePoint sites by keyword, or list subsites of a given site.
- Manage Permissions: View, grant, and revoke permissions on SharePoint files and folders.
- Search: Search across SharePoint content using the Microsoft Search API.
- Get Drives: Retrieve document libraries (drives) for a SharePoint site.
- Manage List Items: Full CRUD operations on SharePoint list items.
- Get Content Types: Retrieve content types and site columns for a SharePoint site.
- Get Site User: Resolve a user email or UPN to the numeric SharePoint site-scoped user ID required for Person/Group list column LookupId fields.
Using Sharepoint tools in Cursor
What to expect once Sharepoint is connected.
- Cursor picks MCP tools automatically when they are relevant, including in Plan Mode. Name a Sharepoint tool to steer it.
- Cursor asks for approval before it uses an MCP tool by default. Click the arrow next to the tool name to check the arguments first.
- Switch the Metorial server off from Customize in the sidebar without removing it.
- Cursor shows each Sharepoint tool response in chat, with expandable views of the arguments and the result.
Troubleshooting Cursor
- Metorial connects but tools are missing or failing
- Open the Output panel (Cmd+Shift+U), choose MCP Logs, and look for authentication or connection errors.
- Your company blocks the server
- Enterprise admins approve remote servers in Team Settings, then MCP Configuration. Ask them to add a URL entry for your Metorial URL.
- Cursor asks before every tool call
- That is the default. Allowlist the Metorial tools you trust in your Run Mode settings to run them without a prompt.
Based on the Cursor MCP documentation.
Frequently asked questions
Common questions about connecting Sharepoint to AI agents with Metorial.
GitHub
Confluence