Sp MCP Server

MCP server for SharePoint & Power Automate management via Microsoft Graph API

Local serverstdioTypeScript

What is the Sp MCP Server?

MCP server for SharePoint & Power Automate management via Microsoft Graph API

What it actually does

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.

Configuration

  • Node.js 18+ - A Microsoft 365 tenant with SharePoint Online - An Azure App Registration with Graph API permissions - A Claude account (Pro, Team, or Enterprise) for Claude.ai, or Claude Code for local use

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
sp_list_listsList all lists and document libraries on a site
sp_list_getGet a list's full schema including column definitions, types, and relationships
sp_list_createCreate a new list (add columns separately via sp_column_add)
sp_column_addAdd columns: text, number, dateTime, choice, lookup, calculated, boolean, currency, personOrGroup
sp_items_queryQuery items with OData filtering, sorting, field selection, and pagination
sp_item_createCreate new items with field values (supports lookup IDs)
sp_item_updateUpdate existing item fields
sp_item_deleteDelete items
pa_flows_listList all flows in an environment
pa_flow_getGet full flow definition including triggers and actions
pa_flow_runsView run history with status and error details
pa_flow_triggerManually trigger a flow
ms_docs_searchSearch Microsoft Learn docs (Graph API, Power Automate, SharePoint)
ms_docs_fetchFetch full content of a documentation page

How to install the Sp MCP Server

{
  "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.

Configuration

  • Node.js 18+ - A Microsoft 365 tenant with SharePoint Online - An Azure App Registration with Graph API permissions - A Claude account (Pro, Team, or Enterprise) for Claude.ai, or Claude Code for local use
VariableDescriptionRequired
TRANSPORTConfiguration value read at startup.Optional
AZURE_TENANT_IDConfiguration value read at startup.Optional
AZURE_CLIENT_IDConfiguration value read at startup.Optional
AZURE_CLIENT_SECRETCredential the server authenticates with.Yes
SP_HOSTNAMEEndpoint or connection string the server talks to.Optional
SP_DEFAULT_SITE_PATHFilesystem location the server is allowed to use.Optional

Example prompts to try

  • “Use Sp MCP to sp list lists.”
  • “Use Sp MCP to sp list get.”
  • “Use Sp MCP to sp list create.”

Frequently asked questions

MCP server for SharePoint & Power Automate management via Microsoft Graph API Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.