How to integrate SharePoint Graph MCP with Vercel AI SDK v6

This guide walks you through connecting SharePoint Graph to Vercel AI SDK v6 using the Composio tool router. By the end, you'll have a working SharePoint Graph agent that can list documents in the marketing library, find files shared externally this week, create folder in project document library through natural language commands. This guide will help you understand how to give your Vercel AI SDK agent real control over a SharePoint Graph account through Composio's SharePoint Graph MCP server. Before we dive in, let's take a quick look at the key ideas and tools involved.

Get started for free Get a demo

SharePoint 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

Managed auth

Connect SharePoint Graph without auth hassles

We manage OAuth, API keys, token refresh, and scopes — you just build.

Try for free

Introduction

This guide will help you understand how to give your Vercel AI SDK agent real control over a SharePoint Graph account through Composio's SharePoint Graph MCP server.

Before we dive in, let's take a quick look at the key ideas and tools involved.

Also integrate SharePoint Graph with

OpenAI Agents SDK Claude Agent SDK Claude Code Claude Cowork Codex OpenClaw Hermes CLI Google ADK LangChain Mastra AI LlamaIndex CrewAI

TL;DR

Here's what you'll learn:

How to set up and configure a Vercel AI SDK agent with SharePoint Graph integration
Using Composio's Tool Router to dynamically load and access SharePoint Graph tools
Creating an MCP client connection using HTTP transport
Building an interactive CLI chat interface with conversation history management
Handling tool calls and results within the Vercel AI SDK framework

What is Vercel AI SDK?

The Vercel AI SDK is a TypeScript library for building AI-powered applications. It provides tools for creating agents that can use external services and maintain conversation state.

Key features include:

streamText: Core function for streaming responses with real-time tool support
MCP Client: Built-in support for Model Context Protocol via @ai-sdk/mcp
Step Counting: Control multi-step tool execution with stopWhen: stepCountIs()
OpenAI Provider: Native integration with OpenAI models

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.

What is the Composio tool router, and how does it fit here?

What is Composio SDK?

Composio's Composio SDK helps agents find the right tools for a task at runtime. You can plug in multiple toolkits (like Gmail, HubSpot, and GitHub), and the agent will identify the relevant app and action to complete multi-step workflows. This can reduce token usage and improve the reliability of tool calls. Read more here: Getting started with Composio SDK

The tool router generates a secure MCP URL that your agents can access to perform actions.

How the Composio SDK works

The Composio SDK follows a three-phase workflow:

Discovery: Searches for tools matching your task and returns relevant toolkits with their details.
Authentication: Checks for active connections. If missing, creates an auth config and returns a connection URL via Auth Link.
Execution: Executes the action using the authenticated connection.

Step-by-step Guide

Step by step09 STEPS

Prerequisites

Before you begin, make sure you have:

Node.js and npm installed
A Composio account with API key
An OpenAI API key

Getting API Keys for OpenAI and Composio

OpenAI API Key

Go to the OpenAI dashboard and create an API key. You'll need credits to use the models, or you can connect to another model provider.
Keep the API key safe.

Composio API Key

Log in to the Composio dashboard.
Navigate to your API settings and generate a new API key.
Store this key securely as you'll need it for authentication.

Install required dependencies

bash

npm install @ai-sdk/openai @ai-sdk/mcp @composio/core ai dotenv

First, install the necessary packages for your project.

What you're installing:

@ai-sdk/openai: Vercel AI SDK's OpenAI provider
@ai-sdk/mcp: MCP client for Vercel AI SDK
@composio/core: Composio SDK for tool integration
ai: Core Vercel AI SDK
dotenv: Environment variable management

Set up environment variables

bash

OPENAI_API_KEY=your_openai_api_key_here
COMPOSIO_API_KEY=your_composio_api_key_here
COMPOSIO_USER_ID=your_user_id_here

Create a .env file in your project root.

What's needed:

OPENAI_API_KEY: Your OpenAI API key for GPT model access
COMPOSIO_API_KEY: Your Composio API key for tool access
COMPOSIO_USER_ID: A unique identifier for the user session

Import required modules and validate environment

typescript

import "dotenv/config";
import { openai } from "@ai-sdk/openai";
import { Composio } from "@composio/core";
import * as readline from "readline";
import { streamText, type ModelMessage, stepCountIs } from "ai";
import { createMCPClient } from "@ai-sdk/mcp";

const composioAPIKey = process.env.COMPOSIO_API_KEY;
const composioUserID = process.env.COMPOSIO_USER_ID;

if (!process.env.OPENAI_API_KEY) throw new Error("OPENAI_API_KEY is not set");
if (!composioAPIKey) throw new Error("COMPOSIO_API_KEY is not set");
if (!composioUserID) throw new Error("COMPOSIO_USER_ID is not set");

const composio = new Composio({
  apiKey: composioAPIKey,
});

What's happening:

We're importing all necessary libraries including Vercel AI SDK's OpenAI provider and Composio
The dotenv/config import automatically loads environment variables
The MCP client import enables connection to Composio's tool server

Create Tool Router session and initialize MCP client

typescript

async function main() {
  // Create a tool router session for the user
  const session = await composio.create(composioUserID!, {
    toolkits: ["sharepoint_graph"],
  });

  const mcpUrl = session.mcp.url;

What's happening:

We're creating a Tool Router session that gives your agent access to SharePoint Graph tools
The create method takes the user ID and specifies which toolkits should be available
The returned mcp object contains the URL and authentication headers needed to connect to the MCP server
This session provides access to all SharePoint Graph-related tools through the MCP protocol

Connect to MCP server and retrieve tools

typescript

const mcpClient = await createMCPClient({
  transport: {
    type: "http",
    url: mcpUrl,
    headers: session.mcp.headers, // Authentication headers for the Composio MCP server
  },
});

const tools = await mcpClient.tools();

What's happening:

We're creating an MCP client that connects to our Composio Tool Router session via HTTP
The mcp.url provides the endpoint, and mcp.headers contains authentication credentials
The type: "http" is important - Composio requires HTTP transport
tools() retrieves all available SharePoint Graph tools that the agent can use

Initialize conversation and CLI interface

typescript

let messages: ModelMessage[] = [];

console.log("Chat started! Type 'exit' or 'quit' to end the conversation.\n");
console.log(
  "Ask any questions related to sharepoint_graph, like summarize my last 5 emails, send an email, etc... :)))\n",
);

const rl = readline.createInterface({
  input: process.stdin,
  output: process.stdout,
  prompt: "> ",
});

rl.prompt();

What's happening:

We initialize an empty messages array to maintain conversation history
A readline interface is created to accept user input from the command line
Instructions are displayed to guide the user on how to interact with the agent

Handle user input and stream responses with real-time tool feedback

typescript

rl.on("line", async (userInput: string) => {
  const trimmedInput = userInput.trim();

  if (["exit", "quit", "bye"].includes(trimmedInput.toLowerCase())) {
    console.log("\nGoodbye!");
    rl.close();
    process.exit(0);
  }

  if (!trimmedInput) {
    rl.prompt();
    return;
  }

  messages.push({ role: "user", content: trimmedInput });
  console.log("\nAgent is thinking...\n");

  try {
    const stream = streamText({
      model: openai("gpt-5"),
      messages,
      tools,
      toolChoice: "auto",
      stopWhen: stepCountIs(10),
      onStepFinish: (step) => {
        for (const toolCall of step.toolCalls) {
          console.log(`[Using tool: ${toolCall.toolName}]`);
          }
          if (step.toolCalls.length > 0) {
            console.log(""); // Add space after tool calls
          }
        },
      });

      for await (const chunk of stream.textStream) {
        process.stdout.write(chunk);
      }

      console.log("\n\n---\n");

      // Get final result for message history
      const response = await stream.response;
      if (response?.messages?.length) {
        messages.push(...response.messages);
      }
    } catch (error) {
      console.error("\nAn error occurred while talking to the agent:");
      console.error(error);
      console.log(
        "\nYou can try again or restart the app if it keeps happening.\n",
      );
    } finally {
      rl.prompt();
    }
  });

  rl.on("close", async () => {
    await mcpClient.close();
    console.log("\n👋 Session ended.");
    process.exit(0);
  });
}

main().catch((err) => {
  console.error("Fatal error:", err);
  process.exit(1);
});

What's happening:

We use streamText instead of generateText to stream responses in real-time
toolChoice: "auto" allows the model to decide when to use SharePoint Graph tools
stopWhen: stepCountIs(10) allows up to 10 steps for complex multi-tool operations
onStepFinish callback displays which tools are being used in real-time
We iterate through the text stream to create a typewriter effect as the agent responds
The complete response is added to conversation history to maintain context
Errors are caught and displayed with helpful retry suggestions

Complete Code

Here's the complete code to get you started with SharePoint Graph and Vercel AI SDK:

typescript

import "dotenv/config";
import { openai } from "@ai-sdk/openai";
import { Composio } from "@composio/core";
import * as readline from "readline";
import { streamText, type ModelMessage, stepCountIs } from "ai";
import { createMCPClient } from "@ai-sdk/mcp";

const composioAPIKey = process.env.COMPOSIO_API_KEY;
const composioUserID = process.env.COMPOSIO_USER_ID;

if (!process.env.OPENAI_API_KEY) throw new Error("OPENAI_API_KEY is not set");
if (!composioAPIKey) throw new Error("COMPOSIO_API_KEY is not set");
if (!composioUserID) throw new Error("COMPOSIO_USER_ID is not set");

const composio = new Composio({
  apiKey: composioAPIKey,
});

async function main() {
  // Create a tool router session for the user
  const session = await composio.create(composioUserID!, {
    toolkits: ["sharepoint_graph"],
  });

  const mcpUrl = session.mcp.url;

  const mcpClient = await createMCPClient({
    transport: {
      type: "http",
      url: mcpUrl,
      headers: session.mcp.headers, // Authentication headers for the Composio MCP server
    },
  });

  const tools = await mcpClient.tools();

  let messages: ModelMessage[] = [];

  console.log("Chat started! Type 'exit' or 'quit' to end the conversation.\n");
  console.log(
    "Ask any questions related to sharepoint_graph, like summarize my last 5 emails, send an email, etc... :)))\n",
  );

  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout,
    prompt: "> ",
  });

  rl.prompt();

  rl.on("line", async (userInput: string) => {
    const trimmedInput = userInput.trim();

    if (["exit", "quit", "bye"].includes(trimmedInput.toLowerCase())) {
      console.log("\nGoodbye!");
      rl.close();
      process.exit(0);
    }

    if (!trimmedInput) {
      rl.prompt();
      return;
    }

    messages.push({ role: "user", content: trimmedInput });
    console.log("\nAgent is thinking...\n");

    try {
      const stream = streamText({
        model: openai("gpt-5"),
        messages,
        tools,
        toolChoice: "auto",
        stopWhen: stepCountIs(10),
        onStepFinish: (step) => {
          for (const toolCall of step.toolCalls) {
            console.log(`[Using tool: ${toolCall.toolName}]`);
          }
          if (step.toolCalls.length > 0) {
            console.log(""); // Add space after tool calls
          }
        },
      });

      for await (const chunk of stream.textStream) {
        process.stdout.write(chunk);
      }

      console.log("\n\n---\n");

      // Get final result for message history
      const response = await stream.response;
      if (response?.messages?.length) {
        messages.push(...response.messages);
      }
    } catch (error) {
      console.error("\nAn error occurred while talking to the agent:");
      console.error(error);
      console.log(
        "\nYou can try again or restart the app if it keeps happening.\n",
      );
    } finally {
      rl.prompt();
    }
  });

  rl.on("close", async () => {
    await mcpClient.close();
    console.log("\n👋 Session ended.");
    process.exit(0);
  });
}

main().catch((err) => {
  console.error("Fatal error:", err);
  process.exit(1);
});

Conclusion

You've successfully built a SharePoint Graph agent using the Vercel AI SDK with streaming capabilities! This implementation provides a powerful foundation for building AI applications with natural language interfaces and real-time feedback.

Key features of this implementation:

Real-time streaming responses for a better user experience with typewriter effect
Live tool execution feedback showing which tools are being used as the agent works
Dynamic tool loading through Composio's Tool Router with secure authentication
Multi-step tool execution with configurable step limits (up to 10 steps)
Comprehensive error handling for robust agent execution
Conversation history maintenance for context-aware responses

You can extend this further by adding custom error handling, implementing specific business logic, or integrating additional Composio toolkits to create multi-app workflows.

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

Use SharePoint Graph MCP with OpenAI Agents SDK

Claude Agent SDK

Use SharePoint Graph MCP with Claude Agent SDK

Claude Code

Use SharePoint Graph MCP with Claude Code

Claude Cowork

Use SharePoint Graph MCP with Claude Cowork

Codex

Use SharePoint Graph MCP with Codex

OpenClaw

Use SharePoint Graph MCP with OpenClaw

Hermes

Use SharePoint Graph MCP with Hermes

CLI

Use SharePoint Graph MCP with CLI

Google ADK

Use SharePoint Graph MCP with Google ADK

LangChain

Use SharePoint Graph MCP with LangChain

Mastra AI

Use SharePoint Graph MCP with Mastra AI

LlamaIndex

Use SharePoint Graph MCP with LlamaIndex

CrewAI

Use SharePoint Graph MCP with CrewAI

MORE TOOLKITS

Explore Other Toolkits

Toolkit marketplace

Boloforms

Api Key

BoloForms is an eSignature platform built for small businesses, offering unlimited signatures, templates, and forms. It simplifies digital document signing and team collaboration at a predictable, fixed price.

Box

Oauth2

Box is a cloud content management and file sharing platform for businesses. It helps teams securely store, organize, and collaborate on files from anywhere.

Carbone

Api Key

Carbone is a blazing-fast report generator that turns JSON data into PDFs, Word docs, spreadsheets, and more using flexible templates. It lets you automate document creation at scale with minimal code.

Castingwords

Api Key

CastingWords is a transcription service specializing in human-powered, accurate transcripts via a simple API. Get seamless audio-to-text conversion for interviews, meetings, podcasts, and more.

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. Vercel AI SDK v6 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 FREE BOOK A DEMO

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

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

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

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

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

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

Co-Founder, Ingram Technologies

How to integrate SharePoint Graph MCP with Vercel AI SDK v6

Connect SharePoint Graph without auth hassles

Introduction

Also integrate SharePoint Graph with

TL;DR

What is Vercel AI SDK?

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

What is the Composio tool router, and how does it fit here?

What is Composio SDK?

How the Composio SDK works

Step-by-step Guide

Prerequisites

Getting API Keys for OpenAI and Composio

Install required dependencies

Set up environment variables

Import required modules and validate environment

Create Tool Router session and initialize MCP client

Connect to MCP server and retrieve tools

Initialize conversation and CLI interface

Handle user input and stream responses with real-time tool feedback

Complete Code

Conclusion

Supported Tools

How to build SharePoint Graph MCP Agent with another framework

OpenAI Agents SDK

Claude Agent SDK

Claude Code

Claude Cowork

Codex

OpenClaw

Hermes

CLI

Google ADK

LangChain

Mastra AI

LlamaIndex

CrewAI

Explore Other Toolkits

Boloforms

Box

Carbone

Castingwords

Frequently asked questions

What are the differences in Tool Router MCP and SharePoint Graph MCP?+

Can I use Tool Router MCP with Vercel AI SDK v6?+

Can I manage the permissions and scopes for SharePoint Graph while using Tool Router?+

How safe is my data with Composio Tool Router?+

Start with SharePoint Graph.It takes 30 seconds.

Teams ship real agents on Composio