MCP server for SharePoint & Power Automate management via Microsoft Graph API
MCP server for SharePoint & Power Automate management via Microsoft Graph API. Exposed over MCP by the sp mcp mcp server, that capability becomes something an assistant can invoke while it works, not something you go and do afterwards.
SharePoint Bridge is an open-source MCP server that connects Claude to your SharePoint environment via the Microsoft Graph API. Ask questions, create lists, update items, query data, and trigger Power Automate flows — all through conversation.
Everything the assistant can do here goes through one of these:
sp_list_lists — List all lists and document libraries on a sitesp_list_get — Get a list's full schema including column definitions, types, and relationshipssp_list_create — Create a new list (add columns separately via sp_column_add)sp_column_add — Add columns: text, number, dateTime, choice, lookup, calculated, boolean, currency, personOrGroupsp_items_query — Query items with OData filtering, sorting, field selection, and paginationsp_item_create — Create new items with field values (supports lookup IDs)sp_item_update — Update existing item fieldssp_item_delete — Delete itemspa_flows_list — List all flows in an environmentpa_flow_get — Get full flow definition including triggers and actionspa_flow_runs — View run history with status and error detailspa_flow_trigger — Manually trigger a flowYou will need 6 environment variables: TRANSPORT, AZURE_TENANT_ID, AZURE_CLIENT_ID, AZURE_CLIENT_SECRET, SP_HOSTNAME, SP_DEFAULT_SITE_PATH. The server will not start without them, which is usually why the tools fail to appear on a first run. Keep credentials in your client's env block or a secrets manager rather than in a file you might commit.
Installation goes through your MCP client rather than a global install: point it at npm on npm and it is fetched when the client starts. The copy-paste blocks for Claude Desktop, Claude Code and Cursor are further down this page.
Among the knowledge and memory options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. Sp MCP's toolset — sp_list_lists, sp_list_get, sp_list_create and 11 more — is a fair guide to whether it matches your workflow. It is maintained by tuttoone; worth a glance at recent repository activity before you build anything load-bearing on it.
This entry was verified against Sp MCP's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.
| Tool | What it does |
|---|---|
| sp_list_lists | List all lists and document libraries on a site |
| sp_list_get | Get a list's full schema including column definitions, types, and relationships |
| sp_list_create | Create a new list (add columns separately via sp_column_add) |
| sp_column_add | Add columns: text, number, dateTime, choice, lookup, calculated, boolean, currency, personOrGroup |
| sp_items_query | Query items with OData filtering, sorting, field selection, and pagination |
| sp_item_create | Create new items with field values (supports lookup IDs) |
| sp_item_update | Update existing item fields |
| sp_item_delete | Delete items |
| pa_flows_list | List all flows in an environment |
| pa_flow_get | Get full flow definition including triggers and actions |
| pa_flow_runs | View run history with status and error details |
| pa_flow_trigger | Manually trigger a flow |
| ms_docs_search | Search Microsoft Learn docs (Graph API, Power Automate, SharePoint) |
| ms_docs_fetch | Fetch full content of a documentation page |
{
"mcpServers": {
"sp": {
"command": "npx",
"args": ["-y", "npm"],
"env": {
"TRANSPORT": "your-value",
"AZURE_TENANT_ID": "your-value",
"AZURE_CLIENT_ID": "your-value",
"AZURE_CLIENT_SECRET": "your-value",
"SP_HOSTNAME": "your-value",
"SP_DEFAULT_SITE_PATH": "your-value"
}
}
}
}Add to claude_desktop_config.json, then restart Claude Desktop.
| Variable | Description | Required |
|---|---|---|
| TRANSPORT | Configuration value read at startup. | Optional |
| AZURE_TENANT_ID | Configuration value read at startup. | Optional |
| AZURE_CLIENT_ID | Configuration value read at startup. | Optional |
| AZURE_CLIENT_SECRET | Credential the server authenticates with. | Yes |
| SP_HOSTNAME | Endpoint or connection string the server talks to. | Optional |
| SP_DEFAULT_SITE_PATH | Filesystem location the server is allowed to use. | Optional |
A knowledge graph your assistant keeps between sessions — entities, relations and observations that persist.
Kill hallucinated APIs — version-accurate, up-to-date library documentation injected straight into context.
Your workspace, on speaking terms with AI — search, read and write Notion pages and databases.
A structured scratchpad for hard problems — stepwise reasoning with revisions, branches and visible logic.
Symbol-level code navigation, refactoring and memory for coding agents — the IDE brain your assistant has been missing.
Chat with your second brain — search, read and write vault notes through the Local REST API.