Aanerud MCP

MCPAI代理

提供方 未标注

AI代理 HTTP · 远程 未标注 社区 / 第三方

全面解析MCP Microsoft OfficeMCP Server的核心功能、安装配置和实用案例。作为顶级Model Context Protocol服务器,MCP Microsoft Office能让AI助手访问实时数据、执行操作,为您提供更智能的工作体验和自动化解决方案。

一句话选型结论

按资料字段整理

Aanerud MCP 属于AI代理类 MCP 服务器,HTTP · 远程,鉴权方式未标注,没有现成安装命令,需按官方文档接入。接入前先确认权限范围;涉及写入、删除或付款的操作,建议先在测试环境验证。

分类AI代理 传输方式HTTP · 远程 鉴权未标注 部署方式远程部署
GitHub 星标 未标注 仓库热度,无公开仓库时显示未标注
工具数 未标注 暴露给模型的工具数量
资源 / 提示词 0 / 0 资源与提示词模板数量
维护方 社区 / 第三方 核验等级 仅资料核对

工具与能力

AI代理
数量来自来源目录的标注,具体工具清单以官方文档为准
工具数量未标注暴露给模型可调用的工具个数
资源数量0可读取的资源条目
提示词数量0内置提示词模板数量

能力标签

安装与配置

HTTP · 远程 未标注
连远程 HTTPS 端点,通常为 Streamable HTTP
  1. 1
    准备运行环境

    确认你的客户端支持远程端点,并拿到服务地址。

  2. 2
    安装服务

    复制上面的安装命令执行;命令里带占位符的位置,换成自己的密钥或路径。

  3. 3
    写入客户端配置

    在客户端的 MCP 配置里填好启动命令和参数,保存后完全退出客户端再打开,让新配置生效。

  4. 4
    验证是否可用

    连接成功后随便调一个只读工具,确认能返回结果,再接入正式流程。

典型使用场景

3 类
按分类与标签整理的常见用法,具体以官方文档为准
给代理接外部能力

让代理在任务中途调用搜索、数据库等真实工具。

多步任务编排

把一串操作拆成步骤,由代理按顺序执行。

自动化重复流程

把固定流程交给代理跑,减少手工操作。

选择建议

选之前先看这几条
按条目字段给出的判断,不替你决定用不用

值得选的地方

  • 基础信息齐全,可以先按官方文档接入试跑。

先想清楚的地方

  • 远程端点依赖网络与服务方可用性,注意密钥与调用额度。
  • 没有现成安装命令,需要按官方文档自己填启动命令和参数。
  • 资料没标注工具数量,实际能力要装好后确认。
  • 版本更新与行为细节以官方仓库为准。

更适合

  • 需要在AI代理场景里让模型直接调用外部能力的人。
  • 想先快速试一下、能接受在本地或自有环境跑服务的人。

不太适合

  • 需要厂商级 SLA 和技术支持的生产环境。

同类对比

6 个同类
同分类里挑最接近的几条,字段以各自详情页为准
MCP 服务器工具数传输方式部署方式安装命令最后核验
Aanerud MCP当前 未标注 HTTP · 远程 远程部署 无 2026-05-17
Filesystem 560c4363 13 未标注 本地部署 无 2026-05-17
Server Everything (everything) 11 stdio · 本地进程 本地部署 有 2026-05-17
Time 7365cb6d 2 SSE · 服务端推送 远程部署 有 2026-05-18
Everything Claude Code 未标注 stdio · 本地进程 本地部署 有 2026-05-17
Openmemory 557e1585 未标注 stdio · 本地进程 本地部署 有 2026-05-17

服务器档案

AI代理
字段来自项目仓库与公开索引,中文说明由本站标注
提供方未标注上游标注的维护方 未标注
分类AI代理本站按上游分类展示
连接方式HTTP · 远程连远程 HTTPS 端点,通常为 Streamable HTTP
鉴权方式未标注远程服务建议用最小权限凭据
维护方社区 / 第三方核验等级 仅资料核对
包名 / 运行时未标注 · 未标注本地安装时用到的包标识与运行时
部署类型远程部署上游给出的部署形态
最近核验2026-05-17上游最后核验时间

详细介绍

19.2 KB
来自项目仓库与上游目录的原文,未做删改

MCP Microsoft Office

One MCP server. Multiple users. Real Microsoft 365 traffic on your test tenant.


The Problem

Test tenants sit empty. Static test data does not exercise real workflows. When you need agents that send real emails, schedule real meetings, and collaborate in real Teams channels, mocks and stubs fall short.

What This Solves

This project connects any MCP-compatible AI client to Microsoft 365 through the Graph API. Each agent authenticates as a distinct tenant user and performs real operations against real data.

  • 117 tools across 12 modules: Mail, Calendar, Files, Excel, Word, PowerPoint, Teams, Contacts, To-Do, Groups, People, Search
  • Multi-user: one server supports your entire team, each with isolated data
  • Real Graph API calls: every operation hits the actual tenant, not a mock
  • Secure: tokens encrypted at rest, no credentials stored on third-party servers

Architecture```

                ┌──────────────────┐
                │  MCP Client      │
                │  (Claude, etc.)  │
                └────────┬─────────┘
                         │ JSON-RPC (stdin/stdout)
                ┌────────▼─────────┐
                │  MCP Adapter     │
                │  (runs locally)  │
                └────────┬─────────┘
                         │ HTTP + Bearer Token
                ┌────────▼─────────┐
                │  MCP Server      │
                │  (local or       │
                │   remote)        │
                └────────┬─────────┘
                         │ Microsoft Graph API
                ┌────────▼─────────┐
                │  Microsoft 365   │
                │  (your tenant)   │
                └──────────────────┘

**Three parts:**

1. **MCP Client** -- the AI you interact with
2. **MCP Adapter** -- a Node.js process that translates MCP protocol to HTTP requests (runs on the same machine as the client)
3. **MCP Server** -- handles authentication and calls the Microsoft Graph API (runs locally or on a remote server)

---

## Permissions

The server requires 18 Microsoft Graph delegated permissions. Twelve work without admin consent. Six require a tenant administrator to grant consent.

### No Admin Consent Required

| Permission | Tools Unlocked |
|---|---|
| `User.Read` | Authentication, user profile |
| `Mail.ReadWrite` | readMail, readMailDetails, markEmailRead, flagMail, getMailAttachments, addMailAttachment, removeMailAttachment |
| `Mail.Send` | sendMail, replyToMail |
| `Calendars.ReadWrite` | getEvents, createEvent, updateEvent, cancelEvent, acceptEvent, tentativelyAcceptEvent, declineEvent, getAvailability, findMeetingTimes, getRooms, getCalendars, addAttachment, removeAttachment |
| `Files.ReadWrite.All` | listFiles, uploadFile, downloadFile, getFileMetadata, getFileContent, setFileContent, updateFileContent, createSharingLink, getSharingLinks, removeSharingPermission, listChannelFiles, uploadFileToChannel, readChannelFile, **all Excel workbook tools**, **all Word/PowerPoint tools** |
| `Contacts.ReadWrite` | listContacts, getContact, createContact, updateContact, deleteContact, searchContacts |
| `Tasks.ReadWrite` | listTaskLists, getTaskList, createTaskList, updateTaskList, deleteTaskList, listTasks, getTask, createTask, updateTask, deleteTask, completeTask |
| `Chat.ReadWrite` | listChats, createChat, getChatMessages, sendChatMessage |
| `Channel.ReadBasic.All` | listTeamChannels, getChannelMessages |
| `ChannelMessage.Send` | sendChannelMessage, replyToMessage |
| `Channel.Create` | createTeamChannel |
| `OnlineMeetings.ReadWrite` | createOnlineMeeting, getOnlineMeeting, listOnlineMeetings, getMeetingByJoinUrl |

### Requires Admin Consent

| Permission | Additional Tools Unlocked |
|---|---|
| `User.Read.All` | Resolve user IDs across Teams, People search |
| `People.Read.All` | findPeople, getRelevantPeople, getPersonById |
| `Group.Read.All` | listGroups, getGroup, listGroupMembers, listMyGroups |
| `ChannelMember.ReadWrite.All` | addChannelMember |
| `ChannelMessage.Read.All` | Read channel message history |
| `OnlineMeetingTranscript.Read.All` | getMeetingTranscripts, getMeetingTranscriptContent |

**Without admin consent**, you get Mail, Calendar, Files, Excel workbooks, Word documents, PowerPoint presentations, Contacts, To-Do, Chat, and basic Teams channel operations. **With admin consent**, you add People directory search, Groups, channel member management, and meeting transcripts.

---

## Quick Start

### Prerequisites

- **Node.js 18+** (download)
- **Claude Desktop** (download) or another MCP client
- **Microsoft 365 account** (work, school, or personal)

### Step 1: Azure App Registration

1. Go to Azure Portal > **Microsoft Entra ID** > **App registrations** > **New registration**
2. Name it `MCP-Microsoft-Office`, register with your preferred account type
3. Copy the **Application (client) ID** and **Directory (tenant) ID**
4. Go to **API permissions** > **Add a permission** > **Microsoft Graph** > **Delegated permissions**
5. Add the 18 permissions listed above
6. If you are a tenant admin, click **Grant admin consent**
7. Go to **Authentication** > **Add a platform** > **Web**
   - Redirect URI: `http://localhost:3000/api/auth/callback`
   - Enable **Allow public client flows**

### Step 2: Clone and Configure```bash
git clone https://github.com/Aanerud/MCP-Microsoft-Office.git
cd MCP-Microsoft-Office
npm install

Copy .env.example to .env and fill in your Azure app details:```
MICROSOFT_CLIENT_ID=your-client-id
MICROSOFT_TENANT_ID=your-tenant-id


### Step 3: Start the Server and Authenticate```bash
npm run dev:web

Open http://localhost:3000 in your browser. Click Login with Microsoft, sign in, and grant permissions. Then click Generate MCP Token and copy the token.

Step 4: Configure Claude Desktop

Edit your Claude Desktop config:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json

Claude Desktop has a practical limit of ~55 tools per MCP server. This project exposes 117 tools, so we split them across three servers that share the same adapter and backend:```json
{
"mcpServers": {
"microsoft-365": {
"command": "node",
"args": ["/path/to/MCP-Microsoft-Office/mcp-adapter.cjs"],
"env": {
"MCP_SERVER_URL": "http://localhost:3000",
"MCP_BEARER_TOKEN": "paste-your-token-here",
"MCP_MODULES": "search,mail,calendar,files,people,contacts,groups,query"
}
},
"microsoft-365-teams": {
"command": "node",
"args": ["/path/to/MCP-Microsoft-Office/mcp-adapter.cjs"],
"env": {
"MCP_SERVER_URL": "http://localhost:3000",
"MCP_BEARER_TOKEN": "paste-your-token-here",
"MCP_MODULES": "teams,todo"
}
},
"microsoft-365-office": {
"command": "node",
"args": ["/path/to/MCP-Microsoft-Office/mcp-adapter.cjs"],
"env": {
"MCP_SERVER_URL": "http://localhost:3000",
"MCP_BEARER_TOKEN": "paste-your-token-here",
"MCP_MODULES": "excel,word,powerpoint,files"
}
}
}
}


`MCP_MODULES` filters which modules the adapter exposes. Omit it to expose all 117 tools (works with clients that have no tool cap).

Set `MCP_DEBUG=1` in the `env` block to enable diagnostic logging to stderr — useful for troubleshooting tool dispatch issues.

Restart Claude Desktop. Ask: *"What's on my calendar today?"* or *"Create an Excel workbook with a budget table."*

---

## Tools (117)

### Mail (9)

| Tool | Description |
|---|---|
| `readMail` | Read inbox messages |
| `sendMail` | Send an email |
| `replyToMail` | Reply to an email |
| `readMailDetails` | Get full email content |
| `markEmailRead` | Mark email as read/unread |
| `flagMail` | Flag or unflag an email |
| `getMailAttachments` | List email attachments |
| `addMailAttachment` | Add attachment to email |
| `removeMailAttachment` | Remove attachment from email |

### Calendar (13)

| Tool | Description |
|---|---|
| `getEvents` | Get calendar events |
| `createEvent` | Create a meeting or event |
| `updateEvent` | Modify an existing event |
| `cancelEvent` | Cancel an event |
| `acceptEvent` | Accept a meeting invitation |
| `tentativelyAcceptEvent` | Tentatively accept |
| `declineEvent` | Decline a meeting invitation |
| `getAvailability` | Check free/busy times |
| `findMeetingTimes` | Find optimal meeting slots |
| `getRooms` | Find meeting rooms |
| `getCalendars` | List all calendars |
| `addAttachment` | Add attachment to event |
| `removeAttachment` | Remove event attachment |

### Files (10)

| Tool | Description |
|---|---|
| `listFiles` | List OneDrive files |
| `uploadFile` | Upload a file |
| `downloadFile` | Download a file |
| `getFileMetadata` | Get file info |
| `getFileContent` | Read file contents |
| `setFileContent` | Write file contents |
| `updateFileContent` | Update existing file |
| `createSharingLink` | Create a sharing link |
| `getSharingLinks` | List sharing links |
| `removeSharingPermission` | Remove sharing access |

### Excel (30)

Work directly with Excel workbooks stored in OneDrive or SharePoint — no file download needed. All operations go through Microsoft Graph's workbook API with transparent session management.

| Tool | Description |
|---|---|
| `createWorkbookSession` | Open a workbook session (persistent or temporary) |
| `closeWorkbookSession` | Close an active workbook session |
| `listWorksheets` | List all worksheets in a workbook |
| `addWorksheet` | Add a new worksheet |
| `getWorksheet` | Get a worksheet by name or ID |
| `updateWorksheet` | Rename, reposition, or hide a worksheet |
| `deleteWorksheet` | Delete a worksheet |
| `getRange` | Read cell values, formulas, and formatting |
| `updateRange` | Write values to a cell range |
| `getRangeFormat` | Get formatting (font, fill, borders) |
| `updateRangeFormat` | Set formatting (bold, colors, number formats) |
| `sortRange` | Sort cells in a range |
| `mergeRange` | Merge cells |
| `unmergeRange` | Unmerge cells |
| `listTables` | List all tables in a worksheet |
| `createTable` | Create a table from a range |
| `updateTable` | Rename or restyle a table |
| `deleteTable` | Delete a table |
| `listTableRows` | List all rows in a table |
| `addTableRow` | Add a row to a table |
| `deleteTableRow` | Delete a row by index |
| `listTableColumns` | List all columns in a table |
| `addTableColumn` | Add a column to a table |
| `deleteTableColumn` | Delete a column |
| `sortTable` | Sort a table by column |
| `filterTable` | Apply a filter to a table column |
| `clearTableFilter` | Clear a column filter |
| `convertTableToRange` | Convert a table back to a plain range |
| `callWorkbookFunction` | Call any of 300+ Excel functions (SUM, VLOOKUP, PMT, etc.) |
| `calculateWorkbook` | Recalculate all formulas |

### Word (5)

Create, read, and convert Word documents. Documents are created from structured JSON and stored in OneDrive. Reading uses a multi-library fallback chain: mammoth (best HTML for .docx) → word-extractor (handles both .doc and .docx) → webUrl fallback. Binary downloads use the Graph beta `/contentStream` endpoint for reliable binary transfer.

| Tool | Description |
|---|---|
| `createWordDocument` | Create a .docx from structured content (headings, paragraphs, tables, lists, images) |
| `readWordDocument` | Read a document as HTML and plain text |
| `getWordDocumentMetadata` | Get title, author, dates, keywords |
| `getWordDocumentAsHtml` | Convert document content to HTML |
| `convertDocumentToPdf` | Convert a Word document to PDF |

> **Note:** Some SharePoint tenants convert uploaded .docx files to OLE2 binary format within seconds of upload. When this happens, client-side parsing libraries cannot read the file. The server gracefully falls back to returning the `webUrl` so the user can open the document in the browser.

### PowerPoint (4)

Create, read, and convert PowerPoint presentations. Presentations are built from structured slide data and stored in OneDrive. Reading uses Graph HTML conversion with jszip fallback for slide-level text extraction.

| Tool | Description |
|---|---|
| `createPresentation` | Create a .pptx with title, content, and blank slides |
| `readPresentation` | Read slide content (text elements per slide) |
| `getPresentationMetadata` | Get title, author, slide count, dates |
| `convertPresentationToPdf` | Convert a presentation to PDF |

### Teams (21)

| Tool | Description |
|---|---|
| `listChats` | List Teams chats |
| `createChat` | Create a new chat |
| `getChatMessages` | Read chat messages |
| `sendChatMessage` | Send a chat message |
| `listJoinedTeams` | List your teams |
| `listTeamChannels` | List team channels |
| `createTeamChannel` | Create a channel |
| `addChannelMember` | Add member to channel |
| `getChannelMessages` | Read channel messages |
| `sendChannelMessage` | Post to a channel |
| `replyToMessage` | Reply to a channel message |
| `listChannelFiles` | List files in a channel |
| `uploadFileToChannel` | Upload file to channel |
| `readChannelFile` | Read a channel file |
| `createOnlineMeeting` | Create a Teams meeting |
| `getOnlineMeeting` | Get meeting details |
| `listOnlineMeetings` | List online meetings |
| `getMeetingByJoinUrl` | Find meeting by join URL |
| `getMeetingTranscripts` | Get meeting transcripts |
| `getMeetingTranscriptContent` | Read transcript content |

*(Note: `addChannelMember` applies to private channels only. Standard channels auto-include all team members.)*

### Contacts (6)

| Tool | Description |
|---|---|
| `listContacts` | List contacts |
| `getContact` | Get contact details |
| `createContact` | Create a contact |
| `updateContact` | Update contact info |
| `deleteContact` | Delete a contact |
| `searchContacts` | Search contacts |

### To-Do (11)

| Tool | Description |
|---|---|
| `listTaskLists` | List task lists |
| `getTaskList` | Get a task list |
| `createTaskList` | Create a task list |
| `updateTaskList` | Rename a task list |
| `deleteTaskList` | Delete a task list |
| `listTasks` | List tasks |
| `getTask` | Get task details |
| `createTask` | Create a task |
| `updateTask` | Update a task |
| `deleteTask` | Delete a task |
| `completeTask` | Mark task complete |

### Groups (4)

| Tool | Description |
|---|---|
| `listGroups` | List Microsoft 365 groups |
| `getGroup` | Get group details |
| `listGroupMembers` | List group members |
| `listMyGroups` | List your groups |

### People (3)

| Tool | Description |
|---|---|
| `findPeople` | Search the directory |
| `getRelevantPeople` | Get frequent contacts |
| `getPersonById` | Get person details |

### Search (1)

| Tool | Description |
|---|---|
| `search` | Unified search across emails, files, events, and chat messages |

---

## Multi-User

Each user authenticates independently. The server isolates all data by user identity.```
  Alice (alice@contoso.com)          Bob (bob@contoso.com)
  ├─ Her own Microsoft tokens        ├─ His own Microsoft tokens
  ├─ Her own session                  ├─ His own session
  └─ Claude Desktop (her laptop)     └─ Claude Desktop (his PC)

              Complete data isolation.
         Alice never sees Bob's data.

For automated testing with multiple agents, use the ROPC (Resource Owner Password Credentials) flow to authenticate programmatically:```bash

Start the server

npm run dev:web

Run the E2E test suite (authenticates 3 users via ROPC)

node tests/run-all.cjs


The test suite authenticates multiple users, then exercises all 117 tools across 12 modules plus 5 cross-module workflows. See `tests/` for the full implementation.

---

## E2E Test Suite

The project includes a comprehensive test suite covering all 117 tools.```bash
# Run all tests (requires server running)
node tests/run-all.cjs

# Run a single module
node tests/run-all.cjs --bucket mail --buckets-only

# Run only workflows
node tests/run-all.cjs --workflows-only

Test structure:```
tests/
lib/ Shared auth, HTTP client, reporter
buckets/ One file per module (12 files, 117 tools)
workflows/ Cross-module tests (5 files)
run-all.cjs Master runner


Tests authenticate via ROPC (no manual token management) and run in ~100 seconds.

---

## Environment Variables

Copy `.env.example` to `.env` and configure:

| Variable | Required | Description |
|---|---|---|
| `MICROSOFT_CLIENT_ID` | Yes | Azure App Client ID |
| `MICROSOFT_TENANT_ID` | Yes | Azure Tenant ID |
| `MICROSOFT_REDIRECT_URI` | No | OAuth callback URL (default: `http://localhost:3000/api/auth/callback`) |
| `DEVICE_REGISTRY_ENCRYPTION_KEY` | Production | 32-byte encryption key for token storage |
| `JWT_SECRET` | Production | Secret for signing JWT tokens |
| `CORS_ALLOWED_ORIGINS` | Production | Comma-separated allowed origins |
| `PORT` | No | Server port (default: `3000`) |
| `NODE_ENV` | No | `development` or `production` |

---

## Deployment

### Local (Recommended for Getting Started)```bash
npm install
npm run dev:web

Azure App Service

See docs/azure-deployment.md for CI/CD deployment with GitHub Actions.


Security

  • Encrypted storage: all Microsoft tokens encrypted at rest with AES-256
  • No client secrets: uses public client flow (PKCE) for desktop authentication
  • Token isolation: each user's tokens stored separately with different encryption keys
  • Rate limiting: built-in rate limiting protects against abuse
  • CORS protection: origin allowlist in production
  • Session expiry: sessions expire after 24 hours

Production Checklist

  • [ ] Set NODE_ENV=production
  • [ ] Set DEVICE_REGISTRY_ENCRYPTION_KEY (32 bytes)
  • [ ] Set JWT_SECRET (strong random string)
  • [ ] Set CORS_ALLOWED_ORIGINS
  • [ ] Use HTTPS with a valid certificate

Project Structure```

MCP-Microsoft-Office/
├── mcp-adapter.cjs MCP protocol adapter (runs locally with Claude Desktop)
├── src/
│ ├── api/ Express routes and controllers
│ ├── auth/ MSAL authentication (OAuth2, ROPC, token exchange)
│ ├── core/ Services (cache, storage, tools, error handling)
│ ├── graph/ Microsoft Graph API services
│ │ ├── graph-client.cjs HTTP client with retry, binary support, sessions
│ │ ├── files-service.cjs OneDrive file operations
│ │ ├── excel-service.cjs Workbook API (sessions, ranges, tables, functions)
│ │ ├── word-service.cjs Word create/read (docx + mammoth + word-extractor)
│ │ └── powerpoint-service.cjs PPT create/read (pptxgenjs + jszip)
│ └── modules/ Feature modules (mail, calendar, excel, word, powerpoint, etc.)
├── public/ Web UI for authentication
└── tests/ E2E test suite (gitignored)
```


Contributing

  1. Fork the repository
  2. Create a feature branch
  3. Make your changes
  4. Submit a pull request

License

MIT License -- see LICENSE file.

常见问题

7 问
答案由本站依据条目字段整理,不引用上游原文
Aanerud MCP 怎么安装?

资料没有给出安装命令,请到官方仓库或文档按说明接入;这类条目多数是生态应用,或尚未发布可安装包。

Aanerud MCP 怎么在客户端里配置?

它的传输方式未标注,在客户端 MCP 配置里按官方文档填写启动命令和参数,保存后重启客户端生效。

Aanerud MCP 收费吗?

本站不代收费用,也没有标注具体价格。是否收费取决于服务本身和背后的接口额度,正式使用前按官方说明确认。

Aanerud MCP 需要 API Key 吗?

资料没有标注鉴权方式,是否需要密钥取决于服务本身,接入前按官方文档确认。

Aanerud MCP 能提供哪些能力?

资料显示能力标签包括 办公自动化、自然语言、HTTP。具体工具清单以官方文档为准。

Aanerud MCP 需要什么运行环境?

属于远程端点,不需要在本地装运行时。

Aanerud MCP 是本地还是远程?

它是远程端点,连服务地址即可。传输方式为HTTP · 远程。

热门专题

按标签挑服务器
全部专题 →

服务器信息以作者仓库与官方文档为准;分类、传输方式与鉴权方式的中文说明为中文整理,最近核验 2026-05-17。