How to integrate Share point MCP with Pi

Connect Pi to Share point MCP. Create a new project folder in sharepoint, add a task item to the marketing list, and more using natural language, with authentication handled for you.

Share point logoShare point
Oauth2S2s Oauth2

SharePoint is a Microsoft platform for secure document management and team collaboration. It helps organizations store, organize, and share content efficiently.

86 Tools

Introduction

Pi is a minimal, self-extensible coding agent that lives in your terminal — one agent loop over Claude, GPT-5, Gemini, Grok, DeepSeek, and 20+ other providers, with maximum extension surface and minimum product opinion. Its core ships four tools (read, write, edit, bash) and self-extends at runtime through skills, extensions, and packages.

This guide explains the easiest and most robust way to connect your Share point account to Pi. You can do this through either Composio Connect CLI or Composio Connect MCP. Because Pi already runs shell commands as first-class tools and ships no built-in MCP, the CLI is the recommended path — it's faster to set up, needs no server config, and chains multi-step tasks more reliably. The MCP path is also fully supported through Pi's official pi-mcp-adapter extension.

Also integrate Share point with

What is Composio Connect?

Composio Connect is a consumer offering that lets anyone plug 1,000+ applications directly into their agent harness — including Pi. It can:

  • Search and load tools from relevant toolkits on-demand, reducing context usage.
  • Chain multiple tools to accomplish complex workflows via a remote workbench, without excessive back-and-forth with the LLM.
  • Manage app authentication end-to-end with zero manual overhead.

Connect Share point to Pi with Composio

Prerequisites: Install Pi

Pi needs Node.js 18+ (Node 22 recommended). Install the agent globally with npm:

bash
npm install -g --ignore-scripts @earendil-works/pi-coding-agent

On Linux or macOS you can use the installer script instead:

bash
curl -fsSL https://pi.dev/install.sh | sh

Then run pi in any project directory and authenticate your model provider — use /login inside Pi for subscription providers (Claude Pro/Max, ChatGPT, GitHub Copilot), or set an API key such as ANTHROPIC_API_KEY before starting. Confirm it's working:

bash
pi --version

Full first-run details are in the Pi Quickstart.

Option 1: Composio CLI (recommended)

Pi runs shell commands as first-class tools, so the Composio Universal CLI is the most natural fit — no MCP server to configure and reliable multi-step tool chaining. Install and authenticate:

bash
# Install the Composio CLI
curl -fsSL https://composio.dev/install | bash

# Log in to Composio
composio login

Connect to Share point

Ask Pi to connect to Share point, or simply request any Share point-related task. Under the hood Pi calls Composio commands like any other shell tool:

bash
composio search "what can I do with Share point?"
composio link share_point

On the first Share point call, composio link share_point opens an OAuth prompt so you can authorize access. After that, every Share point command works with your stored credentials automatically — just talk to Pi and it will search, execute, and chain Share point tools as needed.

Option 2: Composio MCP

Pi's core intentionally ships no built-in MCP, but the official pi-mcp-adapter extension adds full MCP support — exposing every server through a single lightweight proxy tool (~200 tokens) instead of loading hundreds of tool definitions into context.

1. Install the MCP adapter extension

bash
pi install npm:pi-mcp-adapter

Restart Pi after installation.

2. Add the Composio MCP server

Create (or edit) a .mcp.json file in your project root, or ~/.config/mcp/mcp.json for a user-global setup:

bash
{
  "mcpServers": {
    "composio": {
      "url": "https://connect.composio.dev/mcp"
    }
  }
}

The adapter connects lazily by default — the server won't start until Pi actually calls one of its tools, and cached metadata keeps search and describe working without a live connection.

3. Authenticate

Run /mcp-auth inside Pi to open the authentication modal and select composio from the list. Complete the sign-in in your browser, then on the consent screen click Allow access to authorize Composio. Once approved, the server shows as connected inside Pi:

Pi /mcp-auth modal listing the composio MCP server
Composio OAuth consent screen with the Allow access button
Composio MCP server connected inside Pi

4. Done!

Confirm the server is live with /mcp to open the interactive panel, then ask Pi to connect to Share point or request any Share point-related task — it will prompt you to authorize Share point on first use.

What is the Share point MCP server, and what's possible with it?

The Share point MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your SharePoint account. It provides structured and secure access to your SharePoint sites, so your agent can create folders, manage lists, handle users, and organize your team's content with ease.

  • Automated folder creation and organization: Instruct your agent to create new folders in SharePoint to keep your documents neatly organized by project, department, or workflow.
  • List and item management: Let your agent create new SharePoint lists for tracking tasks, issues, or inventory, and add items to lists automatically as your needs evolve.
  • User provisioning and access control: Quickly create new SharePoint users or remove existing ones, helping you manage team access and collaboration securely and efficiently.
  • User lookup and verification: Have your agent search for users across Microsoft Graph and SharePoint to confirm their existence and check their status in your organization.

Way Forward

With Share point connected, Pi can now act on your behalf whenever you ask it to.

From here, you can extend Pi further:

  • Connect more apps: Calendar, Slack, Notion, Linear, and hundreds of others are available through the same Composio Connect setup. Each new integration compounds what Pi can do for you.
  • Build workflows across tools: Once multiple apps are connected, Pi can chain actions together — turn an email into a calendar invite, a Slack message into a Linear ticket, or a meeting note into a follow-up draft.
  • Lean into Pi's extension surface: Wrap common Share point flows as Pi skills or prompt templates so recurring tasks become one-line commands, and use directTools in the MCP adapter to promote your most-used Share point tools into Pi's tool list directly.

If you run into trouble or want to share what you've built, join the community or check out the Docs for deeper configuration options.

TOOLS

Supported Tools

Every Share point action and event your agent gets out of the box.

Add Attachment to List Item

Tool to add an attachment to a SharePoint list item.

Add Field Link to Content Type

Tool to add a field link to a list content type.

Add Role Assignment to List Item

Tool to add a role assignment to a list item.

Add Role Assignment to SharePoint List

Tool to add a role assignment to a SharePoint list.

Break Role Inheritance on List Item

Tool to break permission inheritance on a list item.

Break Role Inheritance on List

Breaks permission inheritance on a SharePoint list, allowing you to set unique permissions.

Check In SharePoint File

Tool to check in a file.

Create Content Type

Tool to create a new content type in SharePoint.

Create Drive Item Sharing Link

Tool to create a sharing link for a drive item in SharePoint or OneDrive.

Create SharePoint List Field

Tool to create a new field (column) in a SharePoint list.

Create SharePoint List Item by GUID

Tool to create a new item in a SharePoint list using the list's GUID.

Create List Item in Folder

Tool to create a list item in a specific folder within a SharePoint list.

Create SharePoint Subsite

Tool to create a new SharePoint subsite under the current site.

Delete Drive Item Version Content

Tool to delete content for a specific version of a drive item in SharePoint.

Delete SharePoint Folder

Deletes a folder from a SharePoint document library.

Delete SharePoint List

Tool to delete a SharePoint list.

Delete SharePoint List By Title

Tool to delete a SharePoint list by its title.

Delete SharePoint List Item

Tool to delete a SharePoint list item.

Delete Recycle Bin Item Permanently

Tool to permanently delete a SharePoint Recycle Bin item.

Download File by Server-relative URL

Tool to download a file by server-relative URL.

Ensure SharePoint User

Ensures a user exists in a SharePoint site by their login name.

Follow SharePoint Actor

Follow a SharePoint user, document, site, or tag.

Get All SharePoint Folders

Tool to retrieve all folders in the SharePoint web.

Get SharePoint List Changes

Tool to retrieve changes from SharePoint list change log.

Get Content Type

Tool to retrieve a single SharePoint content type by its ID.

Get Site Content Types

Retrieves all content types from the current SharePoint site.

Get Content Types for List

Tool to retrieve all content types for a specific SharePoint list by GUID.

Get SharePoint Context Info

Tool to retrieve SharePoint context information including the form digest value.

Get Current SharePoint User

Tool to retrieve the current user for the site.

Get Drive Item Analytics

Tool to get analytics for a SharePoint drive item.

Get Group Users

Retrieves all users who are members of a specified SharePoint group.

Get Group Users By ID

Tool to retrieve all users in a specific SharePoint site group by group ID.

Download List Item Attachment

Tool to download an attachment from a SharePoint list item.

Get SharePoint List by GUID

Tool to retrieve a SharePoint list by its GUID.

Get SharePoint List By Title

Tool to retrieve a SharePoint list by its title.

Get Content Type by ID

Tool to retrieve a specific content type from a SharePoint list by its ID.

Get List Item by ID

Tool to retrieve a SharePoint list item by ID.

Get SharePoint List Items

Tool to retrieve items from a SharePoint list.

Get SharePoint List Items by GUID

Tool to retrieve items from a SharePoint list using its GUID.

Get List Item Version

Tool to retrieve a specific version of a SharePoint list item.

Get Followed Entities

Tool to get entities the current user is following.

Get My Followers

Retrieves the list of users who are following the authenticated user in SharePoint.

Get Role Definitions

Tool to list role definitions at the web level.

Get SharePoint Site Collection Info

Tool to fetch site collection metadata (URL, ID, root web URI) only—not list item or document-level details.

Get Site Drive Item by Path

Tool to retrieve a file or folder by its server-relative path in a SharePoint site.

Get SharePoint Site Page Content

Tool to retrieve modern SharePoint Site Pages content by reading list item fields.

Get User Effective Permissions on Web

Get a user's effective permissions on the current SharePoint site (Web).

Get SharePoint Webhook Subscription

Tool to retrieve a specific webhook subscription by ID from a SharePoint list.

Get SharePoint Webhook Subscriptions

Tool to retrieve all webhook subscriptions on a SharePoint list.

Get SharePoint Web Info

Tool to retrieve information about the current SharePoint web (site) using REST API.

Check Follow Status

Tool to check if the current user is following a specified actor.

List SharePoint Lists

Retrieves all lists in the current SharePoint web/site.

List Drive Children

Tool to list children (files and folders) in a SharePoint drive using REST API v2.

List Recently Modified Drive Items

Tool to list recently modified items in a SharePoint drive using Microsoft Graph API.

List Drives via SharePoint REST API

Tool to retrieve drives using SharePoint REST API v2.

List Files in Folder

Tool to list files within a SharePoint folder (non-recursive; does not enumerate subfolders).

List Item Attachments

Tool to list all attachments for a SharePoint list item.

List SharePoint List Columns

Tool to list all column definitions in a SharePoint list.

List Recycle Bin Items

Tool to list items in the SharePoint Recycle Bin.

List Site Groups

Tool to list SharePoint site groups for a site collection.

List SharePoint Sites

Tool to retrieve all SharePoint sites accessible to the user.

List Site Users

Tool to list users in the site collection.

List Subfolders in Folder

Tool to list immediate child folders within a SharePoint folder.

Log SharePoint Event

Log custom usage analytics events in SharePoint for tracking user activities.

Recycle SharePoint File

Tool to move a file to the Recycle Bin.

Recycle SharePoint List Item

Tool to move a list item to the Recycle Bin.

Rename SharePoint Folder

Renames a SharePoint folder by updating its list item metadata.

Render List Data As Stream

Retrieve list items from SharePoint with rich metadata and formatting.

Restore Drive Item Version

Tool to restore a previous version of a SharePoint drive item.

Restore Recycle Bin Item

Tool to restore a SharePoint Recycle Bin item.

Search SharePoint Site

Search SharePoint content using Keyword Query Language (KQL).

Search Suggest

Tool to get search query suggestions.

Check Out SharePoint File

Tool to check out a file in a document library.

Create SharePoint Folder

Creates a new folder in SharePoint using the REST API.

Create SharePoint List

Creates a new list in SharePoint using the REST API.

Create SharePoint List Item

Creates a new item in a SharePoint list.

Find SharePoint User

Searches for a user in the SharePoint site by email address and returns their profile information if found.

Remove SharePoint User

Removes a user from SharePoint.

Undo SharePoint File Checkout

Tool to undo a file checkout, discarding any changes made while checked out.

Update SharePoint Content Type

Tool to update a SharePoint content type's properties such as name, description, group, or hidden status.

Update Drive Item

Tool to update the properties of a drive item (file or folder) in SharePoint using SharePoint REST API.

Update SharePoint List

Tool to update properties of an existing SharePoint list.

Update SharePoint List Item

Tool to update fields on an existing SharePoint list item.

Update SharePoint Site

Tool to update properties of the current SharePoint site (web).

Upload File to Folder

Tool to upload a file to a SharePoint document library or folder.

Upload File from URL to SharePoint

Tool to fetch a file from a URL and upload it to SharePoint.

FAQ

Frequently asked questions

With a standalone Share point MCP server, the agents and LLMs can only access a fixed set of Share point tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Share point and many other apps based on the task at hand, all through a single MCP endpoint.

Yes, you can. Pi fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Share point tools.

Yes, absolutely. You can configure which Share point scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Share point data and credentials are handled as safely as possible.

Start with Share point.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Share point tool your agent needs.Free to start.

Start building