m365-reporting-mcp
Allows interaction with Microsoft Loop components and workspaces by querying .loop/.fluid elements via Microsoft Search and SharePoint/OneDrive drives within delegated user access.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@m365-reporting-mcp What's on my calendar this week?"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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
Create an App registration (single tenant).
Expose an API: Application ID URI =
api://<CLIENT_ID>, scope:access_as_user. SetaccessTokenAcceptedVersionto 2 (manifest).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.AllWRITE (mail only):
Mail.ReadWrite,Mail.Send,Mail.ReadWrite.Shared,Mail.Send.SharedAdmin consent is required for the
.Allscopes.
For HTTP mode: Certificates & secrets → client secret.
For stdio/dev mode: Authentication → "Allow public client flows" = Yes (device code).
Note to spec point 11:
Sites.Selectedexists 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 delegatedSites.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 startEndpoints in HTTP mode:
URL | Description |
| MCP endpoint (stateless Streamable HTTP), bearer token required |
| MCP OAuth resource metadata → points to the built-in OAuth proxy |
| OAuth AS metadata (the proxy) |
| Built-in OAuth proxy in front of Entra ID |
| Admin dashboard: Settings / Tools / Log (X-Admin-Key) |
| 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:
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).ChatGPT → Settings → Connectors → join a new Connector, URL:
https://<BASE_URL>/mcp.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 toolscreate-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.
download-drive-itemdownload-drive-itemARead-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-itemARead-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-timesARead-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-urlARead-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.
get-calendarget-calendarARead-onlyIdempotent
Get a single calendar by id.
Inputs: calendarId (required).
get-calendar-eventget-calendar-eventARead-onlyIdempotent
Get a single event with full body/description, attendees, online meeting info and recurrence.
Inputs: eventId (required), select.
get-calendar-viewget-calendar-viewARead-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-messageBRead-onlyIdempotent
Get a single channel message.
Inputs: teamId (required), channelId (required), messageId (required).
get-chatget-chatARead-onlyIdempotent
Get a single chat including its members.
Inputs: chatId (required).
get-chat-messageget-chat-messageBRead-onlyIdempotent
Get a single chat message.
Inputs: chatId (required), messageId (required).
get-driveget-driveARead-onlyIdempotent
Get a drive (document library) by id.
Inputs: driveId (required).
get-drive-itemget-drive-itemARead-onlyIdempotent
Get file/folder metadata (includes @microsoft.graph.downloadUrl for files).
Inputs: itemId (required), driveId (required).
get-loop-component-contentget-loop-component-contentARead-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-contentARead-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-messageBRead-onlyIdempotent
Get a single message including its full body.
Inputs: messageId (required), select.
get-meeting-transcript-contentget-meeting-transcript-contentARead-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-driveARead-onlyIdempotent
Get the signed-in user's OneDrive (drive id, quota, owner).
Inputs: no named parameters.
get-my-drive-itemget-my-drive-itemBRead-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-urlARead-onlyIdempotent
Get a short-lived direct download URL for a OneDrive file without fetching its content.
Inputs: itemId (required).
get-onenote-notebookget-onenote-notebookARead-onlyIdempotent
Get a single OneNote notebook.
Inputs: notebookId (required).
get-onenote-pageget-onenote-pageARead-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-contentARead-onlyIdempotent
Get the FULL HTML content of a OneNote page (the actual note body, not just metadata).
Inputs: pageId (required).
get-online-meetingget-online-meetingARead-onlyIdempotent
Get an online meeting by its onlineMeeting id (subject, organizer, participants, join URL, start/end).
Inputs: meetingId (required).
get-people-availabilityget-people-availabilityARead-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-siteget-siteARead-onlyIdempotent
Get a SharePoint site by id (or 'hostname:/sites/path' form).
Inputs: siteId (required).
get-site-listget-site-listARead-onlyIdempotent
Get a SharePoint list by id.
Inputs: listId (required), siteId (required).
get-site-list-itemget-site-list-itemARead-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-contentARead-onlyIdempotent
Get the FULL HTML content of a SharePoint-hosted OneNote page.
Inputs: pageId (required), siteId (required).
get-teamget-teamBRead-onlyIdempotent
Get a team's properties.
Inputs: teamId (required).
get-team-channelget-team-channelBRead-onlyIdempotent
Get a single channel of a team.
Inputs: teamId (required), channelId (required).
get-userget-userARead-onlyIdempotent
Get a user by object id or userPrincipalName (email).
Inputs: userIdOrUpn (required), select.
get-user-account-status-historyget-user-account-status-historyARead-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-eventsARead-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-calendarsBRead-onlyIdempotent
List the signed-in user's calendars.
Inputs: cursor, maxItems.
list-channel-message-replieslist-channel-message-repliesARead-onlyIdempotent
List replies (thread) of a channel message.
Inputs: teamId (required), channelId (required), messageId (required), cursor, +1 more.
list-channel-messageslist-channel-messagesARead-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-messagesARead-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-chatsARead-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-auditsARead-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-itemsBRead-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-itemsBRead-onlyIdempotent
List files/folders in the root of a drive (document library).
Inputs: driveId (required), cursor, filter, select, +2 more.
list-event-attachmentslist-event-attachmentsARead-onlyIdempotent
List attachments of a calendar event (metadata).
Inputs: eventId (required), cursor, maxItems.
list-joined-teamslist-joined-teamsARead-onlyIdempotent
List the Microsoft Teams teams the signed-in user is a member of.
Inputs: cursor, maxItems.
list-mail-attachmentslist-mail-attachmentsARead-onlyIdempotent
List attachments of a message (metadata only: name, contentType, size).
Inputs: messageId (required), cursor, maxItems.
list-mail-child-folderslist-mail-child-foldersBRead-onlyIdempotent
List child folders of a mail folder.
Inputs: folderId (required), cursor, maxItems.
list-mail-folder-messageslist-mail-folder-messagesARead-onlyIdempotent
List/search messages inside a specific mail folder.
Inputs: folderId (required), to, from, cursor, +6 more.
list-mail-folderslist-mail-foldersARead-onlyIdempotent
List top-level mail folders of the signed-in user's mailbox.
Inputs: cursor, maxItems.
list-mail-messageslist-mail-messagesARead-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-recordsARead-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-reportsCRead-onlyIdempotent
List attendance reports of an online meeting.
Inputs: meetingId (required), cursor, maxItems.
list-meeting-recordingslist-meeting-recordingsARead-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-transcriptsBRead-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-itemsBRead-onlyIdempotent
List files/folders inside a OneDrive folder.
Inputs: itemId (required), cursor, filter, select, +2 more.
list-my-drive-root-itemslist-my-drive-root-itemsARead-onlyIdempotent
List files/folders in the root of the user's OneDrive.
Inputs: cursor, filter, select, orderby, +1 more.
list-onenote-notebookslist-onenote-notebooksARead-onlyIdempotent
List the signed-in user's OneNote notebooks.
Inputs: cursor, filter, orderby, maxItems.
list-onenote-notebook-section-groupslist-onenote-notebook-section-groupsARead-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-sectionsARead-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-sectionsARead-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-pagesCRead-onlyIdempotent
List pages of a OneNote section.
Inputs: sectionId (required), cursor, filter, search, +2 more.
list-onenote-sectionslist-onenote-sectionsARead-onlyIdempotent
List all OneNote sections across the user's notebooks (newest-modified first; paginates past 100 automatically).
Inputs: cursor, filter, orderby, maxItems.
list-site-driveslist-site-drivesARead-onlyIdempotent
List document libraries (drives) of a SharePoint site.
Inputs: siteId (required), cursor, maxItems.
list-site-list-itemslist-site-list-itemsBRead-onlyIdempotent
List items of a SharePoint list including their field values.
Inputs: listId (required), siteId (required), cursor, filter, +1 more.
list-site-listslist-site-listsBRead-onlyIdempotent
List SharePoint lists of a site.
Inputs: siteId (required), cursor, maxItems.
list-site-onenote-notebookslist-site-onenote-notebooksARead-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-groupsARead-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-sectionsARead-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-pagesBRead-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-sectionsARead-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-pagesARead-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-sectionsARead-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-channelsCRead-onlyIdempotent
List channels of a team.
Inputs: teamId (required), cursor, filter, select, +1 more.
list-team-memberslist-team-membersARead-onlyIdempotent
List members of a team (name, email, roles).
Inputs: teamId (required), cursor, maxItems.
list-userslist-usersARead-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-mailreply-mailA
Reply to a message as the signed-in user. Requires confirm=true.
Inputs: comment (required), confirm (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-itemsARead-onlyIdempotent
Search files by keyword within one drive (document library).
Inputs: q (required), driveId (required), cursor, maxItems.
search-loop-componentssearch-loop-componentsARead-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-m365ARead-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-driveARead-onlyIdempotent
Search the user's OneDrive (and items shared with them) by keyword.
Inputs: q (required), cursor, maxItems.
search-onenote-pagessearch-onenote-pagesARead-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-peopleARead-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-sitesARead-onlyIdempotent
Search SharePoint sites the signed-in user can access, by keyword.
Inputs: query (required), cursor, maxItems.
search-userssearch-usersARead-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.
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
Scored across 103 tools
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.
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.
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.
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
Related MCP Connectors
Permissioned access to Outlook, OneDrive and Teams via the user's own Microsoft account
Governed memory and workspace for any AI: tasks, calendar, mail and pages, with per-action consent.
Asking support MCP: read conversations, contacts and reports, and reply with scoped consent.
MCP server connecting AI agents to 100+ apps (Gmail, Slack, Notion, GitHub) via one-click OAuth.
Related MCP Servers
- FlicenseNot gradedqualityAmaintenanceEnables 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.-
- FlicenseNot gradedqualityAmaintenanceEnables 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.-
- FlicenseNot gradedqualityAmaintenanceEnables 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.-
- FlicenseNot gradedqualityAmaintenanceEnables 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.-