How to integrate SharePoint Graph MCP with LlamaIndex

This guide walks you through connecting SharePoint Graph to LlamaIndex 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 LlamaIndex 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.

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

This guide walks you through connecting SharePoint Graph to LlamaIndex 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 LlamaIndex 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

TL;DR

Here's what you'll learn:
  • Set your OpenAI and Composio API keys
  • Install LlamaIndex and Composio packages
  • Create a Composio Tool Router session for SharePoint Graph
  • Connect LlamaIndex to the SharePoint Graph MCP server
  • Build a SharePoint Graph-powered agent using LlamaIndex
  • Interact with SharePoint Graph through natural language

What is LlamaIndex?

LlamaIndex is a data framework for building LLM applications. It provides tools for connecting LLMs to external data sources and services through agents and tools.

Key features include:

  • ReAct Agent: Reasoning and acting pattern for tool-using agents
  • MCP Tools: Native support for Model Context Protocol
  • Context Management: Maintain conversation context across interactions
  • Async Support: Built for async/await patterns

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:

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

Step-by-step Guide

Step by step10 STEPS
1

Prerequisites

Before you begin, make sure you have:
  • Python 3.8/Node 16 or higher installed
  • A Composio account with the API key
  • An OpenAI API key
  • A SharePoint Graph account and project
  • Basic familiarity with async Python/Typescript
2

Getting API Keys for OpenAI, Composio, and SharePoint Graph

OpenAI API key (OPENAI_API_KEY)
  • Go to the OpenAI dashboard
  • Create an API key if you don't have one
  • Assign it to OPENAI_API_KEY in .env
Composio API key and user ID
  • Log into the Composio dashboard
  • Copy your API key from Settings
    • Use this as COMPOSIO_API_KEY
  • Pick a stable user identifier (email or ID)
    • Use this as COMPOSIO_USER_ID
3

Installing dependencies

npm install @composio/llamaindex @llamaindex/openai @llamaindex/tools @llamaindex/workflow dotenv

Create a new Typescript project and install the necessary dependencies:

  • @composio/llamaindex: Composio's LlamaIndex integration
  • @llamaindex/openai: OpenAI LLM integration
  • @llamaindex/tools: MCP client for LlamaIndex
  • @llamaindex/workflow: Workflow framework for LlamaIndex
  • dotenv: Environment variable management
4

Set environment variables

bash
OPENAI_API_KEY=your-openai-api-key
COMPOSIO_API_KEY=your-composio-api-key
COMPOSIO_USER_ID=your-user-id

Create a .env file in your project root:

These credentials will be used to:

  • Authenticate with OpenAI's GPT-5 model
  • Connect to Composio's Tool Router
  • Identify your Composio user session for SharePoint Graph access
5

Import modules

import "dotenv/config";
import readline from "node:readline/promises";
import { stdin as input, stdout as output } from "node:process";

import { Composio } from "@composio/core";

import { mcp } from "@llamaindex/tools";
import { agent as createAgent } from "@llamaindex/workflow";
import { openai } from "@llamaindex/openai";

dotenv.config();

Create a new file called sharepoint graph_llamaindex_agent.ts and import the required modules:

Key imports:

  • dotenv.config loads .env at runtime
  • readline gives us a simple CLI chat loop
  • Composio is the main Composio SDK client
  • mcp connects to an MCP endpoint
  • createAgent builds a LlamaIndex agent
  • openai configures the LLM backend
6

Load environment variables and initialize Composio

const OPENAI_API_KEY = process.env.OPENAI_API_KEY;
const COMPOSIO_API_KEY = process.env.COMPOSIO_API_KEY;
const COMPOSIO_USER_ID = process.env.COMPOSIO_USER_ID;

if (!OPENAI_API_KEY) throw new Error("OPENAI_API_KEY is not set");
if (!COMPOSIO_API_KEY) throw new Error("COMPOSIO_API_KEY is not set");
if (!COMPOSIO_USER_ID) throw new Error("COMPOSIO_USER_ID is not set");

What's happening:

This ensures missing credentials cause early, clear errors before the agent attempts to initialise.

7

Create a Tool Router session and build the agent function

async function buildAgent() {

  console.log(`Initializing Composio client...${COMPOSIO_USER_ID!}...`);
  console.log(`COMPOSIO_USER_ID: ${COMPOSIO_USER_ID!}...`);

  const composio = new Composio({
    apiKey: COMPOSIO_API_KEY,
    provider: new LlamaindexProvider(),
  });

  const session = await composio.create(
    COMPOSIO_USER_ID!,
    {
      toolkits: ["sharepoint_graph"],
    },
  );

  const mcpUrl = session.mcp.url;
  console.log(`Composio Tool Router MCP URL: ${mcpUrl}`);

  const server = mcp({
    url: mcpUrl,
    clientName: "composio_tool_router_with_llamaindex",
    requestInit: {
      headers: {
        "x-api-key": COMPOSIO_API_KEY!,
      },
    },
    // verbose: true,
  });

  const tools = await server.tools();

  const llm = openai({ apiKey: OPENAI_API_KEY, model: "gpt-5" });

  const agent = createAgent({
    name: "composio_tool_router_with_llamaindex",
        description : "An agent that uses Composio Tool Router MCP tools to perform actions.",
    systemPrompt:
      "You are a helpful assistant connected to Composio Tool Router."+
"Use the available tools to answer user queries and perform SharePoint Graph actions." ,
    llm,
    tools,
  });

  return agent;
}

What's happening here:

  • We create a Composio client using your API key and configure it with the LlamaIndex provider
  • We then create a tool router MCP session for your user, specifying the toolkits we want to use (in this case, sharepoint graph)
  • The session returns an MCP HTTP endpoint URL that acts as a gateway to all your configured tools
  • LlamaIndex will connect to this endpoint to dynamically discover and use the available SharePoint Graph tools.
  • The MCP tools are mapped to LlamaIndex-compatible tools and plug them into the Agent.
8

Create an interactive chat loop

async function chatLoop(agent: ReturnType<typeof createAgent>) {
  const rl = readline.createInterface({ input, output });

  console.log("Type 'quit' or 'exit' to stop.");

  while (true) {
    let userInput: string;

    try {
      userInput = (await rl.question("\nYou: ")).trim();
    } catch {
      console.log("\nAgent: Bye!");
      break;
    }

    if (!userInput) {
      continue;
    }

    const lower = userInput.toLowerCase();
    if (lower === "quit" || lower === "exit") {
      console.log("Agent: Bye!");
      break;
    }

    try {
      process.stdout.write("Agent: ");

      const stream = agent.runStream(userInput);
      let finalResult: any = null;

      for await (const event of stream) {
        // The event.data contains the streamed content
        const data: any = event.data;

        // Check for streaming delta content
        if (data?.delta) {
          process.stdout.write(data.delta);
        }

        // Store final result for fallback
        if (data?.result || data?.message) {
          finalResult = data;
        }
      }

      // If no streaming happened, show the final result
      if (finalResult) {
        const answer =
          finalResult.result ??
          finalResult.message?.content ??
          finalResult.message ??
          "";
        if (answer && typeof answer === "string" && !answer.includes("[object")) {
          process.stdout.write(answer);
        }
      }

      console.log(); // New line after streaming completes
    } catch (err: any) {
      console.error("\nAgent error:", err?.message ?? err);
    }
  }

  rl.close();
}

What's happening:

  • We're creating a direct terminal interface to chat with SharePoint Graph
  • The LLM's responses are streamed to the CLI for faster interaction.
  • The agent uses context to maintain conversation history
  • The agent processes the request, selects appropriate SharePoint Graph tools, and returns a result
  • We extract the answer from the result data structure and display it to the user
  • You can type 'quit' or 'exit' to stop the chat loop gracefully
  • Agent responses and any errors are streamed in a clear, readable format
9

Define the main entry point

async function main() {
  try {
    const agent = await buildAgent();
    await chatLoop(agent);
  } catch (err) {
    console.error("Failed to start agent:", err);
    process.exit(1);
  }
}

main();

What's happening here:

  • We're orchestrating the entire application flow
  • The agent gets built with proper error handling
  • Then we kick off the interactive chat loop so you can start talking to SharePoint Graph
10

Run the agent

npx ts-node llamaindex-agent.ts

When prompted, authenticate and authorise your agent with SharePoint Graph, then start asking questions.

Complete Code

Here's the complete code to get you started with SharePoint Graph and LlamaIndex:

import "dotenv/config";
import readline from "node:readline/promises";
import { stdin as input, stdout as output } from "node:process";

import { Composio } from "@composio/core";
import { LlamaindexProvider } from "@composio/llamaindex";

import { mcp } from "@llamaindex/tools";
import { agent as createAgent } from "@llamaindex/workflow";
import { openai } from "@llamaindex/openai";

dotenv.config();

const OPENAI_API_KEY = process.env.OPENAI_API_KEY;
const COMPOSIO_API_KEY = process.env.COMPOSIO_API_KEY;
const COMPOSIO_USER_ID = process.env.COMPOSIO_USER_ID;

if (!OPENAI_API_KEY) {
    throw new Error("OPENAI_API_KEY is not set in the environment");
  }
if (!COMPOSIO_API_KEY) {
    throw new Error("COMPOSIO_API_KEY is not set in the environment");
  }
if (!COMPOSIO_USER_ID) {
    throw new Error("COMPOSIO_USER_ID is not set in the environment");
  }

async function buildAgent() {

  console.log(`Initializing Composio client...${COMPOSIO_USER_ID!}...`);
  console.log(`COMPOSIO_USER_ID: ${COMPOSIO_USER_ID!}...`);

  const composio = new Composio({
    apiKey: COMPOSIO_API_KEY,
    provider: new LlamaindexProvider(),
  });

  const session = await composio.create(
    COMPOSIO_USER_ID!,
    {
      toolkits: ["sharepoint_graph"],
    },
  );

  const mcpUrl = session.mcp.url;
  console.log(`Composio Tool Router MCP URL: ${mcpUrl}`);

  const server = mcp({
    url: mcpUrl,
    clientName: "composio_tool_router_with_llamaindex",
    requestInit: {
      headers: {
        "x-api-key": COMPOSIO_API_KEY!,
      },
    },
    // verbose: true,
  });

  const tools = await server.tools();

  const llm = openai({ apiKey: OPENAI_API_KEY, model: "gpt-5" });

  const agent = createAgent({
    name: "composio_tool_router_with_llamaindex",
    description:
      "An agent that uses Composio Tool Router MCP tools to perform actions.",
    systemPrompt:
      "You are a helpful assistant connected to Composio Tool Router."+
"Use the available tools to answer user queries and perform SharePoint Graph actions." ,
    llm,
    tools,
  });

  return agent;
}

async function chatLoop(agent: ReturnType<typeof createAgent>) {
  const rl = readline.createInterface({ input, output });

  console.log("Type 'quit' or 'exit' to stop.");

  while (true) {
    let userInput: string;

    try {
      userInput = (await rl.question("\nYou: ")).trim();
    } catch {
      console.log("\nAgent: Bye!");
      break;
    }

    if (!userInput) {
      continue;
    }

    const lower = userInput.toLowerCase();
    if (lower === "quit" || lower === "exit") {
      console.log("Agent: Bye!");
      break;
    }

    try {
      process.stdout.write("Agent: ");

      const stream = agent.runStream(userInput);
      let finalResult: any = null;

      for await (const event of stream) {
        // The event.data contains the streamed content
        const data: any = event.data;

        // Check for streaming delta content
        if (data?.delta) {
          process.stdout.write(data.delta);
        }

        // Store final result for fallback
        if (data?.result || data?.message) {
          finalResult = data;
        }
      }

      // If no streaming happened, show the final result
      if (finalResult) {
        const answer =
          finalResult.result ??
          finalResult.message?.content ??
          finalResult.message ??
          "";
        if (answer && typeof answer === "string" && !answer.includes("[object")) {
          process.stdout.write(answer);
        }
      }

      console.log(); // New line after streaming completes
    } catch (err: any) {
      console.error("\nAgent error:", err?.message ?? err);
    }
  }

  rl.close();
}

async function main() {
  try {
    const agent = await buildAgent();
    await chatLoop(agent);
  } catch (err: any) {
    console.error("Failed to start agent:", err?.message ?? err);
    process.exit(1);
  }
}

main();

Conclusion

You've successfully connected SharePoint Graph to LlamaIndex through Composio's Tool Router MCP layer. Key takeaways:
  • Tool Router dynamically exposes SharePoint Graph tools through an MCP endpoint
  • LlamaIndex's ReActAgent handles reasoning and orchestration; Composio handles integrations
  • The agent becomes more capable without increasing prompt size
  • Async Python provides clean, efficient execution of agent workflows
You can easily extend this to other toolkits like Gmail, Notion, Stripe, GitHub, and more by adding them to the toolkits parameter.
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.

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. LlamaIndex 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