SharePoint List as MCP for Claude Plugin

(0) Share

Report

Posted on by Krupesh_PowerUp

I’d like to create a MCP server or something similar that can connect to my SharePoint list data and assist users in answering questions and taking action on their behalf using Claude AI chat browser.

I believe the solution lies in creating an MCP server and hosting it on a server. Then, I can connect this server to your Claude. However, I want to make it easy and straightforward for users to install it as a plugin for their Claude and start receiving answers from the SharePoint list. Additionally, I’d like for me to provide a skill file that defines the columns and other relevant information.

any idea on how can I achieve this ?

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

sannavajjala87 312 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Your instinct is right, a remote MCP server is the way to do this. The simple version:

Build a remote MCP server (HTTP, hosted publicly over HTTPS, not a local one) that exposes tools to read and act on your SharePoint list. Under the hood it calls the Microsoft Graph API, so it can both answer questions and create or update list items on the user's behalf.

Users add it in the browser via Settings > Connectors > Add custom connector, pasting your server's URL. That's the "plugin" install you're picturing. Custom connectors work on Pro, Max, Team, and Enterprise (Free can add one). On Team or Enterprise, an owner adds it first and then each member connects individually.

For acting on each user's behalf, wire up OAuth. Your server uses Microsoft Entra OAuth so each person signs into Microsoft, and you enter the OAuth Client ID and Secret in the connector's Advanced settings. Add Claude's callback URL (https://claude.ai/api/mcp/auth_callback) to your Entra app's redirect URIs. One note: pure machine-to-machine auth isn't supported, it needs that user sign-in flow, which is exactly what you want for per-user SharePoint permissions anyway.

On the skill file for columns: you don't strictly need a separate one. The list schema (columns, types, and what each tool does) lives in your MCP tool definitions, which is how Claude learns the structure. You can layer a Skill on top for extra usage guidance, but the tools themselves carry the column info.

And if you want the install to be even easier, you can submit the server to Claude's Connectors Directory so people add it in a click instead of pasting a URL.

Hope that helps you get started.

Was this reply helpful? Yes No
Suggested answer

11manish 3,033 on at

Like (0)

Report
Copy link

Link copied!

Yes, your proposed approach is feasible. For an enterprise-grade solution,

I would recommend building an MCP server that exposes SharePoint list operations through Microsoft Graph APIs, and then connecting that

server to Claude.

Was this reply helpful? Yes No