Microsoft 365 SharePoint MCP server
Integrate SharePoint with AI agents to automate document management, list operations, site administration, and content discovery. An AI agent connected to SharePoint can upload and manage files, create and modify lists, search documents, manage permissions, apply metadata and retention policies, and generate reports—all from natural language requests. Use this for enterprise document workflows, team collaboration automation, content governance, or knowledge management.
Setting up an MCP server
This article covers the standard steps for creating an MCP server in AI Gateway and connecting it to an AI client. The steps are the same for every integration — application-specific details (API credentials, OAuth endpoints, and scopes) are covered in the Authentication section on this page.
Before you begin
You'll need:
- Access to AI Gateway with permission to create MCP servers.
- API credentials for the application you're connecting (see the Authentication section on this page for what to collect).
Create an MCP server
Find the app in the catalog
- Sign in to AI Gateway and select App Catalog from the left navigation.
- Search for the application you want to connect, then select it from the catalog.
- Select Create MCP Server to start the wizard.
App Configuration
Confirm the Base URL for the API, then, under Tools, select the endpoints you want to expose. Select Next.
MCP Server Setup
- Enter a Name for your server — something descriptive that identifies both the application and its purpose.
- Enter a Description so your team knows what the server is for.
- Set the log level: choose Production Mode for terser logs, or Non-Production Mode for more verbose logs that can help with debugging.
- Select Next.
Authentication
Enter the authentication details for the application. This varies by service — see the Authentication section on this page for the specific credentials, OAuth URLs, and scopes to use.
Review
Look over the summary of your MCP server configuration, then select Create & Deploy. AI Gateway provisions the server and provides a server URL you'll use when configuring your AI client.
Connect to an AI client
Once your server is deployed, you'll need to add it to the AI client your team uses. Select your client for setup instructions:
Tips
- You can create multiple MCP servers for the same application — for example, a read-only server for reporting agents and a read-write server for automation workflows.
- If you're unsure which OAuth scopes to request, start with the minimum read-only set and add write scopes only when needed. Most application pages include scope recommendations.
Authentication
SharePoint integration uses OAuth 2.0 authentication through Microsoft Graph. Register an application in Azure AD to receive your tenant-specific endpoints and configure your client ID and client secret. In the Azure Portal, go to Azure Active Directory > App registrations and click New registration to create your application.
| Value | Setting |
|---|---|
| Auth endpoint | https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/authorize |
| Token endpoint | https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/token |
| Scopes | Sites.Read.All, Sites.ReadWrite.All, Files.ReadWrite.All, TermStore.ReadWrite.All |
Available tools
These tools enable document management, list operations, site administration, search, and permission management across SharePoint.
| Tool | Description |
|---|---|
| List sites | Get all accessible SharePoint sites and team sites |
| Get site details | Retrieve metadata and properties for a site |
| List libraries | Get document libraries within a site |
| Upload file | Upload a document to a library |
| Download file | Retrieve a file's contents |
| Delete file | Remove a document from a library |
| Get file metadata | Retrieve file properties and custom metadata |
| Create list | Create a new list in a site |
| List items | Get items from a list with filtering |
| Create list item | Add a new item to a list |
| Update list item | Modify an existing list item |
| Delete list item | Remove an item from a list |
| Search content | Search across sites and libraries |
| Update permissions | Grant or revoke access to a file or folder |
| Create sharing link | Generate a shareable link with expiration |
| Get versions | List version history for a document |
| Update metadata | Set custom metadata fields on documents |
Tips
Use consistent metadata schemas across your site so the agent can reliably categorize and search documents.
Set retention policies on library roots to ensure compliance without managing individual item lifecycles.
Leverage list views to organize large datasets for the agent to query efficiently.
Filter by site type or metadata when searching across many sites to narrow results quickly.
Grant minimal permissions by default, then expand access only when needed for specific workflows.
Cequence AI Gateway