How to integrate SharePoint Graph MCP with Codex

Codex is one of the most popular coding harnesses out there. And MCP makes the experience even better. With SharePoint Graph MCP integration, you can draft, triage, summarise emails, and much more, all without leaving the terminal or the app, whichever you prefer.

Get started for freeGet a demo
SharePoint Graph logoSharePoint Graph
Oauth2S2s Oauth2

SharePoint Graph is Microsoft Graph access for SharePoint sites, lists, document libraries, files, folders, and sharing. Use it to work with SharePoint content through one secure Microsoft API.

161 Tools

Introduction

Codex is one of the most popular coding harnesses out there. And MCP makes the experience even better. With SharePoint Graph MCP integration, you can draft, triage, summarise emails, and much more, all without leaving the terminal or the app, whichever you prefer.

Also integrate SharePoint Graph with

OpenAI Agents SDKClaude Agent SDKClaude CodeClaude CoworkOpenClawHermesCLIGoogle ADKLangChainVercel AI SDKMastra AILlamaIndexCrewAI

Why use Composio?

Apart from a managed and hosted MCP server, you will get:

  • CodeAct: A dedicated workbench that allows GPT to write its code to handle complex tool chaining. Reduces to-and-fro with LLMs for frequent tool calling.
  • Large tool responses: Handle them to minimise context rot.
  • Dynamic just-in-time access to 20,000 tools across 1000+ other Apps for cross-app workflows. It loads the tools you need, so GPTs aren't overwhelmed by tools you don't need.

How to install SharePoint Graph MCP in Codex

Run the setup command

Run this command in your terminal to add the Composio MCP server to Codex.

Terminal

It will initiate the authentication in a browser window, authorize Codex to access your Composio account.

Composio authentication page

(Optional) Authenticate with OAuth

To authenticate manually, run the login command to open a browser window and authorize Codex to access your Composio account.

bash
codex mcp login composio

Verify the connection

Run codex mcp list to confirm Composio appears as a registered MCP server.

bash
codex mcp list

Codex App

Codex App follows the same approach as VS Code.

  1. Click ⚙️ on the bottom left → MCP Servers → + Add servers → Streamable HTTP:
  2. Fill the header and Key fields with { "x-consumer-api-key" = "ck_*******" }.
  3. The Key is the Composio API key, that you can find on dashboard.composio.dev
  4. Click on Authenticate and authorize Codex to your Composio account and you're all set.
Codex App MCP setup
  1. Restart and verify if it's there in .codex/config.toml
bash
[mcp_servers.composio]
url = "https://connect.composio.dev/mcp"
http_headers = { "x-consumer-api-key" = "ck_*******" }

What is the SharePoint Graph MCP server, and what's possible with it?

The SharePoint Graph 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 Graph account. It provides structured and secure access to your SharePoint sites, lists, document libraries, files, folders, pages, and workbooks, so your agent can organize content, manage lists, share files, update workbooks, and control site resources on your behalf.

  • File and folder organization: Have your agent create folders, copy or delete files and folders, and check documents in or out for controlled collaboration.
  • Lists and structured content: Let the agent create SharePoint lists, add columns and items, copy content types into lists, or remove lists, columns, items, and content types you no longer need.
  • Document sharing and protection: Direct your agent to create sharing links, revoke sharing permissions, delete file versions, or apply Microsoft Purview sensitivity labels to documents.
  • Site pages and content models: Instruct your agent to create or delete modern site pages, site columns, and site content types, and add columns or hub content types where needed.
  • Excel workbook updates: Have your agent add worksheets, tables, rows, charts, named items, and column filters to Excel workbooks stored in SharePoint.

Conclusion

You've successfully integrated SharePoint Graph with Codex using Composio's MCP server. Now you can interact with SharePoint Graph directly from your terminal, VS Code, or the Codex App using natural language commands.

Key benefits of this setup:

  • Seamless integration across CLI, VS Code, and standalone app
  • Natural language commands for SharePoint Graph operations
  • Managed authentication through Composio
  • Access to 20,000+ tools across 1000+ apps for cross-app workflows
  • CodeAct workbench for complex tool chaining

Next steps:

  • Try asking Codex to perform various SharePoint Graph operations
  • Explore cross-app workflows by connecting more toolkits
  • Build automation scripts that leverage Codex's AI capabilities
TOOLS

Supported Tools

Every SharePoint Graph action and event your agent gets out of the box.

Add Column To SharePoint Content Type

Add a column (column link) to a SharePoint site or list content type.

Add Content Type Copy From Hub

Add a copy of a content type from the tenant content type hub to a SharePoint site or list.

Add Content Type Copy To SharePoint List

Copy a site content type into a SharePoint list.

Add SharePoint Workbook Chart

Add a chart to a worksheet in an Excel workbook stored in SharePoint.

Add SharePoint Workbook Named Item

Add a named item at the workbook scope in an Excel workbook stored in SharePoint.

Add SharePoint Workbook Table

Add a table to an Excel workbook stored in SharePoint.

Add SharePoint Workbook Table Row

Add rows to an Excel workbook table stored in SharePoint.

Add SharePoint Workbook Worksheet

Add a worksheet to an Excel workbook stored in SharePoint.

Apply SharePoint Workbook Table Column Filter

Apply a filter to a column of an Excel workbook table stored in SharePoint.

Assign Sensitivity Label To SharePoint Drive Item

Assign a Microsoft Purview sensitivity label to a SharePoint drive item.

Check In SharePoint Drive Item

Check in a SharePoint drive item.

Checkout SharePoint Drive Item

Checkout SharePoint Drive Item.

Close SharePoint Workbook Session

Close an Excel workbook session.

Copy SharePoint Drive Item

Start an asynchronous copy of a SharePoint drive item.

Create SharePoint Folder

Create a folder inside a SharePoint drive folder.

Create SharePoint List

Create a SharePoint list.

Create SharePoint List Column

Create a SharePoint list column definition.

Create SharePoint List Item

Create a SharePoint list item.

Create SharePoint Sharing Link

Create a sharing link for a SharePoint drive item.

Create SharePoint Site Column

Create a SharePoint site column definition.

Create SharePoint Site Content Type

Create a SharePoint site content type.

Create SharePoint Site Page

Create a modern SharePoint site page.

Create SharePoint Site Permission

Grant an application (Sites.

Create Microsoft Graph Subscription

Create a Microsoft Graph webhook subscription.

Create SharePoint Upload Session

Create an upload session for large SharePoint file uploads.

Create SharePoint Workbook Session

Create an Excel workbook session for a workbook stored in SharePoint.

Delete SharePoint Drive Item

Delete a SharePoint drive item.

Delete SharePoint Drive Item Permission

Delete a sharing permission from a SharePoint drive item.

Delete SharePoint Drive Item Version

Delete a SharePoint drive item version.

Delete SharePoint List

Delete a SharePoint list.

Delete SharePoint List Column

Delete a SharePoint list column definition.

Delete SharePoint List Content Type

Delete a SharePoint list content type.

Delete SharePoint List Item

Delete a SharePoint list item.

Delete SharePoint Share Permission

Revoke the sharing-link permission for a shared SharePoint or OneDrive item.

Delete SharePoint Site Column

Delete a SharePoint site column definition.

Delete SharePoint Site Content Type

Delete a SharePoint site content type.

Delete SharePoint Site Page

Delete a SharePoint site page.

Delete SharePoint Site Permission

Revoke an application (Sites.

Delete Microsoft Graph Subscription

Delete a Microsoft Graph webhook subscription.

Delete SharePoint Workbook Table

Delete a table from an Excel workbook stored in SharePoint.

Delete SharePoint Workbook Worksheet

Delete a worksheet in an Excel workbook stored in SharePoint.

Discard SharePoint Drive Item Checkout

Discard SharePoint Drive Item Checkout.

Download SharePoint Drive Item

Download a SharePoint drive item.

Download SharePoint Drive Item By Path

Download a SharePoint drive item by path.

Download SharePoint Drive Item Version

Download the binary content of an earlier (non-current) version of a file in a SharePoint document library.

Execute Microsoft Graph Batch

Execute a Microsoft Graph JSON batch request.

Extract SharePoint Drive Item Sensitivity Labels

Extract the Microsoft Purview sensitivity labels currently applied to a SharePoint drive item.

Follow SharePoint Sites

Follow one or more SharePoint sites for a user.

Get All SharePoint Sites

Enumerate all SharePoint sites across geographies in the organization.

Get SharePoint Content Type Column

Get a single column of a SharePoint site or list content type.

Get SharePoint Content Type Published Status

Check whether a SharePoint content type is published to the content type hub.

Get Current Microsoft Graph User

Get the current Microsoft Graph user for delegated SharePoint Graph connections.

Get SharePoint Default Drive

Get the default document library drive for a SharePoint site.

Get SharePoint Document Comments

Extract comments from a SharePoint Word .

Get SharePoint Drive

Get a SharePoint document library drive by drive ID.

Get SharePoint Drive Item

Get a SharePoint drive item by ID.

Get SharePoint Drive Item Analytics

Get item analytics for a SharePoint drive item.

Get SharePoint Drive Item By Path

Get a SharePoint drive item by path.

Get SharePoint Drive Item Permission

Get a single sharing permission on a SharePoint drive item.

Get SharePoint Drive Item Version

Get a specific SharePoint drive item version.

Get SharePoint List

Get a SharePoint list by ID or display name.

Get SharePoint List Column

Get a SharePoint list column definition.

Get SharePoint List Content Type

Get a SharePoint list content type.

Get SharePoint List Item

Get a SharePoint list item.

Get SharePoint List Item Fields

Get field values for a SharePoint list item.

Get SharePoint List Item Version

Get a specific SharePoint list item version.

Get Signed-In User SharePoint My Site

Resolve the signed-in user's SharePoint hostname from OneDrive mySite.

Get Root SharePoint Site

Get the tenant's root SharePoint site.

Get Sensitivity Label

Get a Microsoft Purview sensitivity label by its ID.

Get SharePoint Shared Item

Access a shared SharePoint or OneDrive item by share ID or encoded sharing URL.

Get SharePoint Site

Get a SharePoint site by Microsoft Graph site ID.

Get SharePoint Site Column

Get a SharePoint site column definition.

Get SharePoint Site Content Type

Get a SharePoint site content type.

Get SharePoint Site Page

Get a SharePoint site page as a Microsoft Graph sitePage resource.

Get SharePoint Site Page Web Part

Get a single web part on a SharePoint site page.

Get SharePoint Site Permission

Get a single application (Sites.

Get SharePoint Special Folder

Get a SharePoint special folder by name.

Get Microsoft Graph Subscription

Get a Microsoft Graph webhook subscription.

Get SharePoint Workbook Chart Image

Render an Excel worksheet chart stored in SharePoint as a base64-encoded image.

Get SharePoint Workbook Named Item

Get a named item defined at the workbook scope in an Excel workbook stored in SharePoint.

Get SharePoint Workbook Worksheet

Get an Excel worksheet in a SharePoint workbook.

Grant SharePoint Share Permission

Grant users access to a shared SharePoint or OneDrive link via an encoded sharing URL.

Invite Users To SharePoint Drive Item

Invite recipients to a SharePoint drive item.

List SharePoint Content Type Columns

List the columns of a SharePoint site or list content type.

List SharePoint Drive Delta

Track changes in a SharePoint drive using Microsoft Graph delta.

List SharePoint Drive Item Children

List children under a folder drive item.

List SharePoint Drive Item Children By Path

List the children of a SharePoint folder addressed by its path under the drive root.

List SharePoint Drive Item Permissions

List sharing permissions on a SharePoint drive item.

List SharePoint Drive Item Thumbnails

Retrieve the available thumbnail sets (small, medium, large) for a SharePoint drive item.

List SharePoint Drive Item Versions

List versions for a SharePoint drive item.

List SharePoint Drive Root Children

List children in the root of a SharePoint drive.

List Followed SharePoint Sites

List the SharePoint sites followed by the signed-in user.

List SharePoint List Columns

List column definitions for a SharePoint list.

List SharePoint List Content Types

List content types for a SharePoint list.

List SharePoint List Item Delta

Track changes to SharePoint list items using Microsoft Graph delta.

List SharePoint List Items

List items in a SharePoint list.

List SharePoint List Item Versions

List versions for a SharePoint list item.

List SharePoint Lists

List SharePoint lists in a site.

List Recent Drive Items

List recent drive items for the delegated (signed-in) user.

List Sensitivity Labels

List the Microsoft Purview sensitivity labels available to the tenant.

List SharePoint Share Permission

Get the sharing-link permission details for a shared SharePoint or OneDrive item.

List SharePoint Site Columns

List column definitions for a SharePoint site.

List SharePoint Site Content Types

List content types for a SharePoint site.

List SharePoint Site Changes

Get newly created, updated, or deleted SharePoint sites using delta tracking.

List SharePoint Site Drives

List document library drives for a SharePoint site.

List SharePoint Site Pages

List modern SharePoint site pages as Microsoft Graph sitePage resources.

List SharePoint Site Page Web Parts

List web parts on a SharePoint site page.

List SharePoint Site Permissions

List the application (Sites.

List SharePoint Sites

Search for SharePoint sites available through Microsoft Graph.

List Microsoft Graph Subscriptions

List Microsoft Graph webhook subscriptions.

List SharePoint Subsites

List subsites for a SharePoint site.

List SharePoint Workbook Charts

List charts on a worksheet in an Excel workbook stored in SharePoint.

List SharePoint Workbook Named Items

List named items defined at the workbook scope in an Excel workbook stored in SharePoint.

List SharePoint Workbook Table Columns

List columns in an Excel workbook table stored in SharePoint.

List SharePoint Workbook Table Rows

List rows in an Excel workbook table stored in SharePoint.

List SharePoint Workbook Tables

List tables in an Excel workbook stored in SharePoint.

List SharePoint Workbook Worksheets

List worksheets in an Excel workbook stored in SharePoint.

Move SharePoint Drive Item

Move a SharePoint drive item by updating its parentReference.

Preview SharePoint Drive Item

Get a short-lived embeddable preview URL for a SharePoint drive item.

Publish SharePoint Content Type

Publish a SharePoint content type from the content type hub site.

Publish SharePoint Site Page

Publish a SharePoint site page.

Reauthorize Microsoft Graph Subscription

Reauthorize a Microsoft Graph webhook subscription.

Resolve SharePoint Site By Path

Resolve a SharePoint site from its hostname and server-relative path.

Restore SharePoint Drive Item Version

Restore a previous version of a SharePoint drive item.

Restore SharePoint List Item Version

Restore a previous version of a SharePoint list item.

Search SharePoint Drive Items

Search items in a SharePoint drive.

Run Microsoft Graph Search Query

Run Microsoft Graph search across SharePoint-supported entities.

Unfollow SharePoint Sites

Unfollow one or more SharePoint sites for a user.

Unpublish SharePoint Content Type

Unpublish a SharePoint content type from the content type hub site.

Update SharePoint Drive Item

Update drive item metadata such as name or description.

Update SharePoint Drive Item Permission

Update the roles of a direct sharing permission on a SharePoint drive item.

Update SharePoint List

Update SharePoint list metadata.

Update SharePoint List Column

Update a SharePoint list column definition.

Update SharePoint List Content Type

Update a SharePoint list content type.

Update SharePoint List Item

Update a SharePoint list item.

Update SharePoint List Item Fields

Update field values for a SharePoint list item.

Update SharePoint Site

Update editable SharePoint site metadata (description).

Update SharePoint Site Column

Update a SharePoint site column definition.

Update SharePoint Site Content Type

Update a SharePoint site content type.

Update SharePoint Site Page

Update editable metadata and layout for a SharePoint site page.

Update SharePoint Site Page Web Part

Update the properties of a web part on a SharePoint site page.

Update SharePoint Site Permission

Update the roles of an application (Sites.

Update Microsoft Graph Subscription

Update a Microsoft Graph webhook subscription.

Update SharePoint Workbook Table

Update properties of a table in an Excel workbook stored in SharePoint.

Update SharePoint Workbook Worksheet

Update worksheet metadata in an Excel workbook stored in SharePoint.

Upload Bytes To SharePoint Upload Session

Upload one byte range (chunk) of a file to an existing SharePoint upload session, or get the session status or cancel it.

Upload SharePoint File

Upload a file of any size to SharePoint via a chunked Microsoft Graph upload session, creating the destination folder path if needed.

Calculate SharePoint Workbook

Recalculate an Excel workbook stored in SharePoint.

Clear SharePoint Workbook Range

Clear the contents and/or formatting of a range in a SharePoint Excel workbook.

Delete SharePoint Workbook Range

Delete a range from a SharePoint Excel workbook and shift the remaining cells.

Run SharePoint Workbook Function

Run an Excel workbook function for a workbook stored in SharePoint.

Insert SharePoint Workbook Range

Insert a cell or range in an Excel workbook stored in SharePoint, shifting existing cells.

Merge SharePoint Workbook Range

Merge the cells of a range in a SharePoint Excel workbook into a single cell.

Read SharePoint Workbook Range

Read a cell or range from an Excel workbook stored in SharePoint.

Sort SharePoint Workbook Range

Sort a cell range in an Excel workbook stored in SharePoint.

Unmerge SharePoint Workbook Range

Unmerge previously merged cells of a range in a SharePoint Excel workbook.

Update SharePoint Workbook Range

Update a cell or range in an Excel workbook stored in SharePoint.

Update SharePoint Workbook Range Fill

Update the fill of a cell or range in an Excel workbook stored in SharePoint.

Update SharePoint Workbook Range Font

Update the font of a cell or range in an Excel workbook stored in SharePoint.

Update SharePoint Workbook Range Format

Update the format of a cell or range in an Excel workbook stored in SharePoint.

Get SharePoint Workbook Used Range

Get the used range of an Excel worksheet stored in SharePoint.

FRAMEWORKS

How to build SharePoint Graph MCP Agent with another framework

OpenAI Agents SDK logo

OpenAI Agents SDK

Use SharePoint Graph MCP with OpenAI Agents SDK

Claude Agent SDK logo

Claude Agent SDK

Use SharePoint Graph MCP with Claude Agent SDK

Claude Code logo

Claude Code

Use SharePoint Graph MCP with Claude Code

Claude Cowork logo

Claude Cowork

Use SharePoint Graph MCP with Claude Cowork

OpenClaw logo

OpenClaw

Use SharePoint Graph MCP with OpenClaw

Hermes logo

Hermes

Use SharePoint Graph MCP with Hermes

CLI logo

CLI

Use SharePoint Graph MCP with CLI

Google ADK logo

Google ADK

Use SharePoint Graph MCP with Google ADK

LangChain logo

LangChain

Use SharePoint Graph MCP with LangChain

Vercel AI SDK logo

Vercel AI SDK

Use SharePoint Graph MCP with Vercel AI SDK

Mastra AI logo

Mastra AI

Use SharePoint Graph MCP with Mastra AI

LlamaIndex logo

LlamaIndex

Use SharePoint Graph MCP with LlamaIndex

CrewAI logo

CrewAI

Use SharePoint Graph MCP with CrewAI

FAQ

Frequently asked questions

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

Yes, you can. Codex 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 SharePoint Graph tools.

Yes, absolutely. You can configure which SharePoint Graph 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 SharePoint Graph data and credentials are handled as safely as possible.

Start with SharePoint Graph.It takes 30 seconds.

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

Start building
Customer stories

Teams ship real agents on Composio

GET STARTED FOR FREEBOOK A DEMO
agent.aiZoomLettaGleanHubSpotAWSWabi

Karan skipped his own birthday party to fix our critical issue. It was 10pm and he diverted his Waymo to help us instead. This really sets the bar — it shows the commitment you need when users rely on your software.

Harsha Gaddipati
Harsha Gaddipati
Co-founder, Slashy

A lot of students tell us that the moment their connected tools start talking to each other inside Opennote feels almost magical. The agent just knows them, and it's immensely helped keep new users on the platform.

Abhi Arya
Abhi Arya
Co-founder, Opennote

We chose Composio over Pipedream because it delivered depth where it mattered — niche tools and tricky edge cases other platforms simply ignored. That gave us confidence to scale without compromising.

Nirman Dave
Nirman Dave
CEO, Zams

As a solo builder, shipping fast is life or death. The only way I can outcompete incumbents is by outmanoeuvring them. Getting bogged down managing agent auth would have been a death sentence.

Ryan Yu
Ryan Yu
Founder, Extra Thursday

Before Composio, adding tool integrations was slow and resource-intensive. Each one could take weeks of engineering time, and maintaining them meant constantly keeping up with API changes.

Tomisin Jenrola
Tomisin Jenrola
Founder & CEO, SwarmZero

With hands-on help from their founder, we integrated Gmail and Google Drive in just 30 minutes. This level of personal support and commitment is exactly what startups should strive for.

Jerome Leclanche
Jerome Leclanche
Co-Founder, Ingram Technologies