Skip to main content
Glama
m365-reporting-mcp
by kharonx

Microsoft 365 Reporting MCP — v1.0

Enterprise MCP server through which ChatGPT, Claude, and other MCP-compatible AI clients get controlled access to Microsoft 365 information sources (Outlook, Calendar, Teams, meeting transcripts, OneNote, SharePoint, OneDrive, Loop, Search, Users).

Principle: read broadly, write narrowly. A broad READ layer within the signed-in user's actual M365 permissions; the only WRITE capability is Outlook email sending (draft / send / reply / forward), and every actual send is gated by a separate confirm=true requirement.

Architecture

ChatGPT / Claude / MCP kliens
        │  MCP over HTTPS (Streamable HTTP) + OAuth bearer token
        ▼
┌──────────────────────────────┐
│  m365-reporting-mcp          │   Tool allowlist (86 tool, 11 WRITE = csak mail)
│  · JWT validálás (Entra)     │   Nincs generikus graph-request / $batch passthrough
│  · On-Behalf-Of tokencsere   │   Audit log (JSONL, tartalom nélkül)
│  · Pagination + 429 retry    │   Forráskövetés (_source blokk minden objektumon)
│  · Admin dashboard (/admin)  │
└──────────────┬───────────────┘
               │  OAuth 2.0 OBO → delegated Graph token
               ▼
    Microsoft Entra ID → Microsoft Graph API (v1.0)

The server never uses app-only permissions: every Graph call runs on behalf of the signed-in user (delegated), so the MCP cannot bypass existing M365 access rules.

Related MCP server: MS 365-21V MCP Server

Entra ID app registration

  1. Create an App registration (single tenant).

  2. Expose an API: Application ID URI = api://<CLIENT_ID>, scope: access_as_user. Set accessTokenAcceptedVersion to 2 (manifest).

  3. API permissions (Microsoft Graph, Delegated) — the full list is in the docs/tool-matrix.md appendix; in summary:

    • READ: Mail.Read, Mail.Read.Shared, Calendars.Read, Chat.Read, Team.ReadBasic.All, Channel.ReadBasic.All, ChannelMessage.Read.All, TeamMember.Read.All, OnlineMeetings.Read, OnlineMeetingTranscript.Read.All, OnlineMeetingRecording.Read.All, OnlineMeetingArtifact.Read.All, Notes.Read, Notes.Read.All, Sites.Read.All, Files.Read, Files.Read.All, People.Read, User.Read, User.ReadBasic.All, User.Read.All

    • WRITE (mail only): Mail.ReadWrite, Mail.Send, Mail.ReadWrite.Shared, Mail.Send.Shared

    • Admin consent is required for the .All scopes.

  4. For HTTP mode: Certificates & secrets → client secret.

  5. For stdio/dev mode: Authentication → "Allow public client flows" = Yes (device code).

Note to spec point 11: Sites.Selected exists as an application permission; in a delegated (user-context) model, site-level narrowing is provided by the user's own SharePoint permissions — the MCP uses delegated Sites.Read.All, which alone does not give access to a site the user cannot otherwise reach.

Installation and execution

npm install
cp .env.example .env      # töltsd ki: TENANT_ID, CLIENT_ID, CLIENT_SECRET, BASE_URL, ADMIN_KEY
npm run build

# Webapp (remote MCP) mód:
npm run start:http

# Lokális/dev (stdio, device code login):
npm run login             # egyszeri bejelentkezés, token cache-elve
npm start

Endpoints in HTTP mode:

URL

Description

POST /mcp

MCP endpoint (stateless Streamable HTTP), bearer token required

GET /.well-known/oauth-protected-resource

MCP OAuth resource metadata → points to the built-in OAuth proxy

GET /.well-known/oauth-authorization-server

OAuth AS metadata (the proxy)

POST /register, GET /authorize, POST /token, GET /auth/callback

Built-in OAuth proxy in front of Entra ID

GET /admin

Admin dashboard: Settings / Tools / Log (X-Admin-Key)

GET /healthz

Health check

In HTTP mode the server starts even without Entra data: initial configuration can be done on the /admin interface (Tenant ID, Client ID, Client Secret, Base URL, connection test) — the save takes effect immediately, and the settings are stored in data/settings.json and override .env values.

Connecting ChatGPT (and other MCP clients)

The server has a built-in OAuth proxy in front of Entra ID, because the ChatGPT connector expects dynamic client registration per RFC 7591, which Entra does not support. The proxy provides a complete OAuth 2.1 interface (DCR + PKCE) to the client and uses the single registered enterprise app toward Entra; the access token issued to the client is the one Entra itself issues for api://<CLIENT_ID>, so the /mcp validation and the OBO Graph exchange are unchanged — all calls run on behalf of the signed-in user.

Connecting from ChatGPT:

  1. In the Entra app's Authentication section, add as Web redirect URI: https://<BASE_URL>/auth/callback (the exact value is shown on the admin Settings tab).

  2. ChatGPT → Settings → Connectors → join a new Connector, URL: https://<BASE_URL>/mcp.

  3. The login shown is the corporate Entra ID login — the user signs in with their own account and only receives their own M365 permissions.

Claude Desktop / Claude Code: the same URL as remote MCP, or locally in stdio mode (claude large.


Note: The source contains `claude mcp add m365-reporting -- node dist/index.js --stdio`; I must preserve this verbatim.

## Security layer (spec 19-20)

* **No** generic `graph_request(method, url, body)` tool, and **no** `$batch` passthrough — only the 86 allowlisted endpoints are available.
* **No** Calendar/Teams/Files/Sites/OneNote/User/Group write, and no delete anywhere.
* Creating a draft is not sending permission: any send/reply/forward requires `confirm=true`, and the tool description instructs the AI to first ask for explicit user approval.
* With the environment variable `READ_ONLY=true`, all write tools can be disabled; with `ENABLED_TOOLSETS`, the toolset-level profile can be narrowed down (e.g. `mail,calendar,meetings`).

## Audit (spec 21)

Every call is logged in JSONL (`logs/audit-YYYY-MM-DD.jsonl`): `timestamp, user, session, tool, operation (READ, WRITE|, resourceType, graphEndpoint, httpMethod, is, success, durationMs`, and for WRITE `sender, recipients, cc, subject, messageId, result`. **actual content (body, transcript, document, token) is never logged.**

## Fault tolerance (spec 22–23)

* HTTP 429/503/504: automatic retry, honoring `Retry-Afterer` (max. 4 attempts);
* `@odata.nextLink` pagination on all list tools (`max MaxSize` param, marked truncation);
* expired token / permission denied / missing resource: an error message that is user-understandable and actionable;
* file download with size limit (`MAX_MAX_DOWNLOAD_BYTES`), DOCX/XLSX/PPTX/PDF/TXT/CSV → text extraction, other binary → base64.

## Tool matrix (dev appendix)

The complete *MCP tool → Graph endpoint → HTTP method → delegated permission → READ / WRITE → enabled* matrix as a generated document: [docs/tool-matrix.md](docs/tool-matrix.md) (`npm run matrix` updates it from the `src/tools/endpoints/*.ts` definitions).

## Loop-Loop adapter limitations (spec 13)

There is no generally available dedicated Graph Loop workspace API, so the Loop adapter **does not invent fictitious endpoints**: it addresses `.loop`/`.fluid` components via the Search API and SharePoint/OneDrive drives. Loop workspaces stored in SharePoint Embedded storage containers are not necessarily available via delegated Graph — the tool description signals this to the AI, so that the limitation is also pointed out to the user.

## Acceptance test (spec 26)

From a connected client, in natural language: *"Examine my past 30 days' email, calendar, Teams conversations, and meeting transcripts… Make me a summary about project X… Turn it into an email, then after separate approval, send it."* — the expected tool chain is: `get-calendar-view` → `find-online-meeting-by-join-url` → `list-meeting-transcripts` → `get-meeting-transcripts-content` + `list-mail-messages` + `list-chat-messages` + `search-onenote-pages` + `search-m365` → `create-draft-email` → (user approval) → `send-draft-email` tool.

Available Tools

103 tools
create-calendar-eventcreate-calendar-eventA

CREATE a calendar event in the signed-in user's default calendar (optionally as a Teams online meeting; attendees get invitations). WRITE operation - requires confirm=true after explicit user approval.

Inputs: end (required), start (required), confirm (required), subject (required), +6 more.

create-draft-emailcreate-draft-emailA

Create a DRAFT email in the signed-in user's Drafts folder. Does NOT send anything - use send-draft-email (with explicit user approval) to send it.

Inputs: to (required), body (required), subject (required), cc, +3 more.

create-shared-mailbox-draftcreate-shared-mailbox-draftA

Create a DRAFT in a shared mailbox. Does NOT send.

Inputs: to (required), body (required), mailbox (required), subject (required), +4 more.

download-drive-itemdownload-drive-itemA
Read-onlyIdempotent

Download a file's content from SharePoint. DOCX/XLSX/PPTX/PDF/TXT/CSV are converted to text; other binaries come back as base64. Size-limited by MAX_DOWNLOAD_BYTES.

Inputs: itemId (required), driveId (required), fileName.

download-my-drive-itemdownload-my-drive-itemA
Read-onlyIdempotent

Download a OneDrive file's content. DOCX/XLSX/PPTX/PDF/TXT/CSV are converted to text; other binaries come back as base64. Size-limited by MAX_DOWNLOAD_BYTES.

Inputs: itemId (required), fileName.

find-meeting-timesfind-meeting-timesA
Read-onlyIdempotent

Suggest meeting time slots that work for the signed-in user and the given attendees (findMeetingTimes), based on free/busy data and working hours.

Inputs: attendees (required), windowEnd (required), windowStart (required), durationMinutes (required), +2 more.

find-online-meeting-by-join-urlfind-online-meeting-by-join-urlA
Read-onlyIdempotent

Resolve an onlineMeeting from a Teams join URL (calendar event -> onlineMeeting.joinUrl -> this tool). This is how a calendar event is connected to its transcripts/recordings/attendance.

Inputs: joinWebUrl (required), cursor, maxItems.

forward-mailforward-mailA

Forward a message as the signed-in user. Requires confirm=true.

Inputs: to (required), confirm (required), messageId (required), comment.

forward-shared-mailbox-mailforward-shared-mailbox-mailA

Forward a shared-mailbox message. Requires confirm=true.

Inputs: to (required), confirm (required), mailbox (required), messageId (required), +1 more.

get-calendarget-calendarA
Read-onlyIdempotent

Get a single calendar by id.

Inputs: calendarId (required).

get-calendar-eventget-calendar-eventA
Read-onlyIdempotent

Get a single event with full body/description, attendees, online meeting info and recurrence.

Inputs: eventId (required), select.

get-calendar-viewget-calendar-viewA
Read-onlyIdempotent

PRIMARY meeting-lookup tool: list all calendar events (including recurring occurrences) within a time range. Requires timeRange or from/to. Returns organizer, participants, start/end, location, onlineMeeting join URL, recurrence.

Inputs: to, from, cursor, filter, +4 more.

get-channel-messageget-channel-messageB
Read-onlyIdempotent

Get a single channel message.

Inputs: teamId (required), channelId (required), messageId (required).

get-chatget-chatA
Read-onlyIdempotent

Get a single chat including its members.

Inputs: chatId (required).

get-chat-messageget-chat-messageB
Read-onlyIdempotent

Get a single chat message.

Inputs: chatId (required), messageId (required).

get-driveget-driveA
Read-onlyIdempotent

Get a drive (document library) by id.

Inputs: driveId (required).

get-drive-itemget-drive-itemA
Read-onlyIdempotent

Get file/folder metadata (includes @microsoft.graph.downloadUrl for files).

Inputs: itemId (required), driveId (required).

get-loop-component-contentget-loop-component-contentA
Read-onlyIdempotent

Download a Loop component's raw content by driveId + itemId (from search-loop-components hit resource.parentReference). Content is Fluid/JSON-like text.

Inputs: itemId (required), driveId (required), fileName.

get-mail-attachment-contentget-mail-attachment-contentA
Read-onlyIdempotent

Download an attachment and return its content. DOCX/XLSX/PPTX/PDF/TXT/CSV are converted to text; other binaries (images) come back as base64.

Inputs: messageId (required), attachmentId (required), fileName.

get-mail-messageget-mail-messageB
Read-onlyIdempotent

Get a single message including its full body.

Inputs: messageId (required), select.

get-meeting-transcript-contentget-meeting-transcript-contentA
Read-onlyIdempotent

Get the FULL TEXT of a meeting transcript in WebVTT format (speaker, timestamp, text preserved). Use for meeting summaries, decisions and commitments extraction.

Inputs: meetingId (required), transcriptId (required).

get-my-driveget-my-driveA
Read-onlyIdempotent

Get the signed-in user's OneDrive (drive id, quota, owner).

Inputs: no named parameters.

get-my-drive-itemget-my-drive-itemB
Read-onlyIdempotent

Get OneDrive file/folder metadata (includes @microsoft.graph.downloadUrl for files).

Inputs: itemId (required).

get-my-drive-item-download-urlget-my-drive-item-download-urlA
Read-onlyIdempotent

Get a short-lived direct download URL for a OneDrive file without fetching its content.

Inputs: itemId (required).

get-onenote-notebookget-onenote-notebookA
Read-onlyIdempotent

Get a single OneNote notebook.

Inputs: notebookId (required).

get-onenote-pageget-onenote-pageA
Read-onlyIdempotent

Get metadata of a OneNote page. Use get-onenote-page-content for the actual body.

Inputs: pageId (required).

get-onenote-page-contentget-onenote-page-contentA
Read-onlyIdempotent

Get the FULL HTML content of a OneNote page (the actual note body, not just metadata).

Inputs: pageId (required).

get-online-meetingget-online-meetingA
Read-onlyIdempotent

Get an online meeting by its onlineMeeting id (subject, organizer, participants, join URL, start/end).

Inputs: meetingId (required).

get-people-availabilityget-people-availabilityA
Read-onlyIdempotent

Free/busy availability (getSchedule) of one or more colleagues' calendars for a time window. Returns availabilityView (0=free, 1=tentative, 2=busy, 3=out of office) and busy time slots - event details stay hidden unless their calendar is shared with the user.

Inputs: end (required), start (required), emails (required), timeZone, +1 more.

get-shared-mailbox-attachment-contentget-shared-mailbox-attachment-contentA
Read-onlyIdempotent

Download an attachment from a shared-mailbox message (text extraction like get-mail-attachment-content).

Inputs: mailbox (required), messageId (required), attachmentId (required), fileName.

get-shared-mailbox-messageget-shared-mailbox-messageA
Read-onlyIdempotent

Get a single shared-mailbox message including its full body.

Inputs: mailbox (required), messageId (required), select.

get-siteget-siteA
Read-onlyIdempotent

Get a SharePoint site by id (or 'hostname:/sites/path' form).

Inputs: siteId (required).

get-site-listget-site-listA
Read-onlyIdempotent

Get a SharePoint list by id.

Inputs: listId (required), siteId (required).

get-site-list-itemget-site-list-itemA
Read-onlyIdempotent

Get a single SharePoint list item including field values.

Inputs: itemId (required), listId (required), siteId (required).

get-site-onenote-page-contentget-site-onenote-page-contentA
Read-onlyIdempotent

Get the FULL HTML content of a SharePoint-hosted OneNote page.

Inputs: pageId (required), siteId (required).

get-teamget-teamB
Read-onlyIdempotent

Get a team's properties.

Inputs: teamId (required).

get-team-channelget-team-channelB
Read-onlyIdempotent

Get a single channel of a team.

Inputs: teamId (required), channelId (required).

get-userget-userA
Read-onlyIdempotent

Get a user by object id or userPrincipalName (email).

Inputs: userIdOrUpn (required), select.

get-user-account-status-historyget-user-account-status-historyA
Read-onlyIdempotent

When was a user DISABLED (or re-enabled), by whom, with what result? Reads the Entra directory audit log (category UserManagement) for the given user and returns only the events that changed accountEnabled: 'Disable account' / 'Enable account' activities and 'Update user' events whose modifiedProperties contain AccountEnabled (true -> false = disabled). Other user updates are excluded. Newest first. RETENTION: Entra keeps directory audits 30 days (P1/P2; 7 days Free) - if the change is older the result is explicitly 'not available in audit log'; no date is estimated. Read-only; needs delegated AuditLog.Read.All + Directory.Read.All with admin consent and a reader role (Reports Reader / Security Reader / Global Reader).

Inputs: userIdOrUpn (required), to, from, change, +3 more.

list-calendar-eventslist-calendar-eventsA
Read-onlyIdempotent

List events of the default calendar (series masters + single events). For time-ranged queries prefer get-calendar-view which expands recurrences.

Inputs: cursor, filter, select, orderby, +1 more.

list-calendarslist-calendarsB
Read-onlyIdempotent

List the signed-in user's calendars.

Inputs: cursor, maxItems.

list-channel-message-replieslist-channel-message-repliesA
Read-onlyIdempotent

List replies (thread) of a channel message.

Inputs: teamId (required), channelId (required), messageId (required), cursor, +1 more.

list-channel-messageslist-channel-messagesA
Read-onlyIdempotent

List messages of a team channel, newest first (Graph does not support server-side filtering here; use search-m365 for keyword search).

Inputs: teamId (required), channelId (required), cursor, maxItems.

list-chat-messageslist-chat-messagesA
Read-onlyIdempotent

List messages of a chat, newest first. Supports a time range (lastModifiedDateTime filter). Keyword filtering must be done client-side or via search-m365 with entityTypes=["chatMessage"].

Inputs: chatId (required), to, from, cursor, +2 more.

list-chatslist-chatsA
Read-onlyIdempotent

List the signed-in user's Teams chats (1:1, group, meeting chats).

Inputs: cursor, filter, select, orderby, +1 more.

list-directory-auditslist-directory-auditsA
Read-onlyIdempotent

Entra directory audit log (who changed what, when): user/group/app changes, password resets, role assignments. Time filter on activityDateTime; $filter e.g. "category eq 'UserManagement' and activityDisplayName eq 'Update user'" or "targetResources/any(t:t/id eq '')". Retention: 30 days (P1/P2). Read-only; needs AuditLog.Read.All + Directory.Read.All (admin consent).

Inputs: to, from, cursor, filter, +3 more.

list-drive-folder-itemslist-drive-folder-itemsB
Read-onlyIdempotent

List files/folders inside a folder of a drive.

Inputs: itemId (required), driveId (required), cursor, filter, +3 more.

list-drive-root-itemslist-drive-root-itemsB
Read-onlyIdempotent

List files/folders in the root of a drive (document library).

Inputs: driveId (required), cursor, filter, select, +2 more.

list-event-attachmentslist-event-attachmentsA
Read-onlyIdempotent

List attachments of a calendar event (metadata).

Inputs: eventId (required), cursor, maxItems.

list-joined-teamslist-joined-teamsA
Read-onlyIdempotent

List the Microsoft Teams teams the signed-in user is a member of.

Inputs: cursor, maxItems.

list-mail-attachmentslist-mail-attachmentsA
Read-onlyIdempotent

List attachments of a message (metadata only: name, contentType, size).

Inputs: messageId (required), cursor, maxItems.

list-mail-child-folderslist-mail-child-foldersB
Read-onlyIdempotent

List child folders of a mail folder.

Inputs: folderId (required), cursor, maxItems.

list-mail-folder-messageslist-mail-folder-messagesA
Read-onlyIdempotent

List/search messages inside a specific mail folder.

Inputs: folderId (required), to, from, cursor, +6 more.

list-mail-folderslist-mail-foldersA
Read-onlyIdempotent

List top-level mail folders of the signed-in user's mailbox.

Inputs: cursor, maxItems.

list-mail-messageslist-mail-messagesA
Read-onlyIdempotent

List/search messages in the signed-in user's mailbox. Supports full-text KQL search (sender, recipient, cc, subject, keyword, attachment, read/unread, importance) and time ranges.

Inputs: to, from, cursor, filter, +5 more.

list-meeting-attendance-recordslist-meeting-attendance-recordsA
Read-onlyIdempotent

List attendance records (who joined, when, for how long) of an attendance report.

Inputs: reportId (required), meetingId (required), cursor, maxItems.

list-meeting-attendance-reportslist-meeting-attendance-reportsC
Read-onlyIdempotent

List attendance reports of an online meeting.

Inputs: meetingId (required), cursor, maxItems.

list-meeting-recordingslist-meeting-recordingsA
Read-onlyIdempotent

List recordings of an online meeting (metadata + content URL; the recording itself stays in OneDrive/SharePoint).

Inputs: meetingId (required), cursor, maxItems.

list-meeting-transcriptslist-meeting-transcriptsB
Read-onlyIdempotent

List transcripts available for an online meeting (metadata: id, created date).

Inputs: meetingId (required), cursor, maxItems.

list-my-drive-folder-itemslist-my-drive-folder-itemsB
Read-onlyIdempotent

List files/folders inside a OneDrive folder.

Inputs: itemId (required), cursor, filter, select, +2 more.

list-my-drive-root-itemslist-my-drive-root-itemsA
Read-onlyIdempotent

List files/folders in the root of the user's OneDrive.

Inputs: cursor, filter, select, orderby, +1 more.

list-onenote-notebookslist-onenote-notebooksA
Read-onlyIdempotent

List the signed-in user's OneNote notebooks.

Inputs: cursor, filter, orderby, maxItems.

list-onenote-notebook-section-groupslist-onenote-notebook-section-groupsA
Read-onlyIdempotent

List section groups of a OneNote notebook (sections nested in groups are NOT returned by list-onenote-notebook-sections).

Inputs: notebookId (required), cursor, filter, orderby, +1 more.

list-onenote-notebook-sectionslist-onenote-notebook-sectionsA
Read-onlyIdempotent

List sections of a OneNote notebook (newest-modified first; paginates past 100 sections automatically).

Inputs: notebookId (required), cursor, filter, orderby, +1 more.

list-onenote-section-group-sectionslist-onenote-section-group-sectionsA
Read-onlyIdempotent

List sections inside a OneNote section group (newest-modified first; paginates past 100 automatically).

Inputs: sectionGroupId (required), cursor, filter, orderby, +1 more.

list-onenote-section-pageslist-onenote-section-pagesC
Read-onlyIdempotent

List pages of a OneNote section.

Inputs: sectionId (required), cursor, filter, search, +2 more.

list-onenote-sectionslist-onenote-sectionsA
Read-onlyIdempotent

List all OneNote sections across the user's notebooks (newest-modified first; paginates past 100 automatically).

Inputs: cursor, filter, orderby, maxItems.

list-shared-mailbox-folder-messageslist-shared-mailbox-folder-messagesB
Read-onlyIdempotent

List/search messages inside a folder of a shared mailbox.

Inputs: mailbox (required), folderId (required), to, from, +7 more.

list-shared-mailbox-folderslist-shared-mailbox-foldersA
Read-onlyIdempotent

List mail folders of a shared mailbox the user has access to.

Inputs: mailbox (required), cursor, maxItems.

list-shared-mailbox-messageslist-shared-mailbox-messagesA
Read-onlyIdempotent

List/search messages of a shared mailbox the signed-in user has access to.

Inputs: mailbox (required), to, from, cursor, +6 more.

list-site-driveslist-site-drivesA
Read-onlyIdempotent

List document libraries (drives) of a SharePoint site.

Inputs: siteId (required), cursor, maxItems.

list-site-list-itemslist-site-list-itemsB
Read-onlyIdempotent

List items of a SharePoint list including their field values.

Inputs: listId (required), siteId (required), cursor, filter, +1 more.

list-site-listslist-site-listsB
Read-onlyIdempotent

List SharePoint lists of a site.

Inputs: siteId (required), cursor, maxItems.

list-site-onenote-notebookslist-site-onenote-notebooksA
Read-onlyIdempotent

List OneNote notebooks hosted on a SharePoint site.

Inputs: siteId (required), cursor, filter, orderby, +1 more.

list-site-onenote-notebook-section-groupslist-site-onenote-notebook-section-groupsA
Read-onlyIdempotent

List section groups of a SharePoint-hosted OneNote notebook.

Inputs: siteId (required), notebookId (required), cursor, filter, +2 more.

list-site-onenote-notebook-sectionslist-site-onenote-notebook-sectionsA
Read-onlyIdempotent

List sections of a SharePoint-hosted OneNote notebook (newest-modified first; paginates past 100 sections automatically).

Inputs: siteId (required), notebookId (required), cursor, filter, +2 more.

list-site-onenote-pageslist-site-onenote-pagesB
Read-onlyIdempotent

List/search OneNote pages of a SharePoint site's notebooks.

Inputs: siteId (required), cursor, filter, search, +2 more.

list-site-onenote-section-group-sectionslist-site-onenote-section-group-sectionsA
Read-onlyIdempotent

List sections inside a section group of a SharePoint-hosted OneNote notebook (newest-modified first).

Inputs: siteId (required), sectionGroupId (required), cursor, filter, +2 more.

list-site-onenote-section-pageslist-site-onenote-section-pagesA
Read-onlyIdempotent

List pages of a section in a SharePoint-hosted OneNote notebook.

Inputs: siteId (required), sectionId (required), cursor, filter, +3 more.

list-site-onenote-sectionslist-site-onenote-sectionsA
Read-onlyIdempotent

List ALL sections of a SharePoint site's OneNote notebooks regardless of section-group nesting (newest-modified first; paginates past 100 automatically). Each item carries parentNotebook and parentSectionGroup. Best entry point for large notebooks.

Inputs: siteId (required), cursor, filter, orderby, +1 more.

list-team-channelslist-team-channelsC
Read-onlyIdempotent

List channels of a team.

Inputs: teamId (required), cursor, filter, select, +1 more.

list-team-memberslist-team-membersA
Read-onlyIdempotent

List members of a team (name, email, roles).

Inputs: teamId (required), cursor, maxItems.

list-userslist-usersA
Read-onlyIdempotent

List ALL users of the organization including disabled accounts (accountEnabled=false) and guests. Paged: for directories larger than maxItems follow nextCursor. Supports $filter (e.g. "accountEnabled eq false") and advanced $search.

Inputs: cursor, filter, select, orderby, +1 more.

reply-all-mailreply-all-mailA

Reply-all to a message as the signed-in user. Requires confirm=true.

Inputs: comment (required), confirm (required), messageId (required).

reply-all-shared-mailbox-mailreply-all-shared-mailbox-mailB

Reply-all to a shared-mailbox message. Requires confirm=true.

Inputs: comment (required), confirm (required), mailbox (required), messageId (required).

reply-mailreply-mailA

Reply to a message as the signed-in user. Requires confirm=true.

Inputs: comment (required), confirm (required), messageId (required).

reply-shared-mailbox-mailreply-shared-mailbox-mailB

Reply to a shared-mailbox message. Requires confirm=true.

Inputs: comment (required), confirm (required), mailbox (required), messageId (required).

reply-to-channel-messagereply-to-channel-messageA

REPLY to an existing channel message (thread) as the signed-in user. WRITE operation - requires confirm=true.

Inputs: teamId (required), confirm (required), message (required), channelId (required), +2 more.

respond-to-calendar-eventrespond-to-calendar-eventA

Respond to a meeting invitation (accept / decline / tentativelyAccept); the organizer is notified. WRITE operation - requires confirm=true.

Inputs: confirm (required), eventId (required), response (required), comment.

search-drive-itemssearch-drive-itemsA
Read-onlyIdempotent

Search files by keyword within one drive (document library).

Inputs: q (required), driveId (required), cursor, maxItems.

search-loop-componentssearch-loop-componentsA
Read-onlyIdempotent

Search Microsoft Loop components (.loop/.fluid files stored in SharePoint/OneDrive) by keyword. Note: Loop workspaces in SharePoint Embedded containers are not exposed via delegated Graph and may be missing from results.

Inputs: query (required), from, size.

search-m365search-m365A
Read-onlyIdempotent

Cross-source Microsoft 365 search (Mail, Calendar, Teams messages, SharePoint, OneDrive). KQL supported. Restriction from Graph: driveItem/drive/site/list/listItem can be combined in one call; message, event and chatMessage must each be searched in a SEPARATE call. Use the returned pointers with dedicated tools to fetch full content.

Inputs: query (required), from, size, entityTypes.

search-my-drivesearch-my-driveA
Read-onlyIdempotent

Search the user's OneDrive (and items shared with them) by keyword.

Inputs: q (required), cursor, maxItems.

search-onenote-pagessearch-onenote-pagesA
Read-onlyIdempotent

List OneNote pages across all personal notebooks, newest first (time filter on lastModifiedDateTime; filter e.g. "contains(title,'x')"). Full-text search is not supported by Graph v1.0 (error 20108). Accounts with many sections get Graph error 20266 here - then go notebook -> sections -> list-onenote-section-pages instead.

Inputs: to, from, cursor, filter, +4 more.

search-peoplesearch-peopleA
Read-onlyIdempotent

Search people relevant to the signed-in user (colleagues, frequent contacts). Good first step for fuzzy name resolution.

Inputs: query, cursor, maxItems.

search-sitessearch-sitesA
Read-onlyIdempotent

Search SharePoint sites the signed-in user can access, by keyword.

Inputs: query (required), cursor, maxItems.

search-userssearch-usersA
Read-onlyIdempotent

Resolve a person by (partial) display name or email, e.g. "Móré Attila" -> Entra user with email + id. Use search-people first for fuzzy matches among the user's contacts.

Inputs: name (required), cursor, maxItems.

send-channel-messagesend-channel-messageA

POST a new message to a team channel as the signed-in user. WRITE operation - requires confirm=true after explicit user approval.

Inputs: teamId (required), confirm (required), message (required), channelId (required), +1 more.

send-chat-messagesend-chat-messageA

SEND a message to a Teams chat (1:1 or group) as the signed-in user. WRITE operation - requires confirm=true after explicit user approval.

Inputs: chatId (required), confirm (required), message (required), contentType.

send-draft-emailsend-draft-emailA

SEND a previously created draft. WRITE operation - requires confirm=true and explicit user approval.

Inputs: confirm (required), messageId (required).

send-mailsend-mailA

Compose and SEND an email in one step as the signed-in user. WRITE operation - requires confirm=true and explicit user approval. Prefer create-draft-email + user review for report emails.

Inputs: to (required), body (required), confirm (required), subject (required), +5 more.

send-shared-mailbox-mailsend-shared-mailbox-mailB

Compose and SEND an email from a shared mailbox. Requires confirm=true and explicit user approval.

Inputs: to (required), body (required), confirm (required), mailbox (required), +5 more.

update-calendar-eventupdate-calendar-eventA

UPDATE an existing calendar event (only the provided fields change; attendees are notified of changes). WRITE operation - requires confirm=true.

Inputs: confirm (required), eventId (required), end, body, +7 more.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3.3/5.0

    Scored across 103 tools

    Disambiguation3/5

    The toolset is organized by domain and descriptions are highly detailed, but with 103 tools there are several near-overlapping pairs (list-calendar-events vs get-calendar-view, search-drive-items vs search-my-drive, search-people vs search-users/list-users) that create selection risk. The explicit 'primary' and 'prefer' notes reduce ambiguity somewhat, but the sheer number of similar retrieval variants makes it hard for an agent to always pick the right one.

    Naming Consistency4/5

    Tool names consistently use kebab-case verb-noun phrasing, and domain prefixes like mail-, calendar-, team-, onenote-, and site- make the hierarchy fairly predictable. Minor inconsistencies exist such as get-calendar-view vs list-calendar-events, search-drive-items vs search-my-drive, and the long shared-mailbox variants, but there is no chaotic mixing of naming conventions.

    Tool Count1/5

    103 tools is an extreme count, especially for a server named m365-reporting-mcp, which implies a reporting focus rather than a full Microsoft Graph client surface. This exceeds the '50+ tools' threshold for extreme mismatch, even though each tool maps to a real Graph operation.

    Completeness4/5

    The server covers a remarkably broad set of M365 data sources: mail including shared mailboxes, calendar, Teams chats/channels/meetings/transcripts/recordings, OneNote, SharePoint/OneDrive, Loop, people, users, and audit logs. Minor gaps exist, such as no event-attachment content download, no shared-mailbox draft sending, and no direct channel keyword search, but these are documented with workarounds and the core reporting/read workflows are well covered.

    Maintenance

    ActivityActive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      Not graded
      quality
      A
      maintenance
      Enables MCP-capable AI clients to access a user's 21Vianet Microsoft 365 mail, calendar, OneDrive, and SharePoint through Microsoft Graph China with delegated permissions, operation confirmation, and audit boundaries.
      -
    • F
      license
      Not graded
      quality
      A
      maintenance
      Enables MCP-compatible AI clients to access and act on a user's 21Vianet Microsoft 365 data—including mail, calendar, OneDrive, and SharePoint—through Microsoft Graph China while preserving delegated permissions, confirmation prompts, and audit boundaries.
      -
    • F
      license
      Not graded
      quality
      A
      maintenance
      Enables MCP-capable AI clients to act on a user's behalf against 21Vianet-operated Microsoft 365 through Microsoft Graph China, covering mail reading and sending, calendar conflict checks, OneDrive and SharePoint file search, Teams, contacts and organization lookup. Access is gated by OAuth with delegated permissions and app roles, plus operation confirmation and audit boundaries, so clients get only the data rights the user already holds.
      -
    • F
      license
      Not graded
      quality
      A
      maintenance
      Enables MCP-capable AI clients to access and manage a user's 21Vianet Microsoft 365 mail, calendar, OneDrive, SharePoint, Teams, contacts, org users, and search through Microsoft Graph China, while respecting delegated permissions, confirmations, and audit boundaries.
      -