What is Ms 365 Mcp Server

ms-365-mcp-server is a Model Context Protocol (MCP) server designed for interacting with Microsoft 365 services via the Graph API.

Use cases

Use cases include automating Excel tasks, building applications that interact with Microsoft 365 data, and enhancing productivity tools that require data manipulation and visualization.

How to use

To use ms-365-mcp-server, install it using the command ‘npx @softeria/ms-365-mcp-server’. Integrate it with Claude Desktop by adding it in the MCP settings or by editing the configuration file directly.

Key features

Key features include authentication via Microsoft Authentication Library (MSAL), Excel file operations such as updating cell values, creating and managing charts, formatting cells, sorting data, creating tables, reading cell values, and listing worksheets.

Where to use

ms-365-mcp-server can be used in various fields that require integration with Microsoft 365 services, particularly in data analysis, reporting, and application development.

ms-365-mcp-server

Microsoft 365 MCP Server

A Model Context Protocol (MCP) server for interacting with Microsoft 365 and Microsoft Office services through the Graph API.

Prerequisites

• Node.js >= 14

Features

• Authentication via Microsoft Authentication Library (MSAL)
• Excel file operations
• Calendar event management
• Mail operations
• OneDrive file management
• OneNote notebooks and pages
• To Do tasks and task lists
• Planner plans and tasks
• Outlook contacts

Quick Start Example

Test login in Claude Desktop:

Examples

Integration

Claude Desktop

To add this MCP server to Claude Desktop:

Edit the config file under Settings > Developer:

{
  "mcpServers": {
    "ms365": {
      "command": "npx",
      "args": [
        "-y",
        "@softeria/ms-365-mcp-server"
      ]
    }
  }
}

Claude Code CLI

claude mcp add ms365 -- npx -y @softeria/ms-365-mcp-server

For other interfaces that support MCPs, please refer to their respective documentation for the correct
integration method.

Authentication

⚠️ You must authenticate before using tools.

The server supports two authentication methods:

1. Device Code Flow (Default)

For interactive authentication via device code:

• MCP client login:
  • Call the login tool (auto-checks existing token)
  • If needed, get URL+code, visit in browser
  • Use verify-login tool to confirm
• CLI login:

  npx @softeria/ms-365-mcp-server --login
  

  Follow the URL and code prompt in the terminal.

Tokens are cached securely in your OS credential store (fallback to file).

2. OAuth Authorization Code Flow (HTTP mode only)

When running with --http, the server requires OAuth authentication:

npx @softeria/ms-365-mcp-server --http 3000

This mode:

• Advertises OAuth capabilities to MCP clients
• Provides OAuth endpoints at /auth/* (authorize, token, metadata)
• Requires Authorization: Bearer <token> for all MCP requests
• Validates tokens with Microsoft Graph API
• Disables login/logout tools by default (use --enable-auth-tools to enable them)

MCP clients will automatically handle the OAuth flow when they see the advertised capabilities.

Note: HTTP mode requires authentication. For unauthenticated testing, use stdio mode with device code flow.

Authentication Tools: In HTTP mode, login/logout tools are disabled by default since OAuth handles authentication.
Use --enable-auth-tools if you need them available.

CLI Options

The following options can be used when running ms-365-mcp-server directly from the command line:

--login           Login using device code flow
--logout          Log out and clear saved credentials
--verify-login    Verify login without starting the server

Server Options

When running as an MCP server, the following options can be used:

-v                Enable verbose logging
--read-only       Start server in read-only mode, disabling write operations
--http [port]     Use Streamable HTTP transport instead of stdio (optionally specify port, default: 3000)
                  Starts Express.js server with MCP endpoint at /mcp
--enable-auth-tools Enable login/logout tools when using HTTP mode (disabled by default in HTTP mode)
--enabled-tools <pattern> Filter tools using regex pattern (e.g., "excel|contact" to enable Excel and Contact tools)

Environment variables:

• READ_ONLY=true|1: Alternative to --read-only flag
• ENABLED_TOOLS: Filter tools using regex pattern (alternative to --enabled-tools flag)
• LOG_LEVEL: Set logging level (default: ‘info’)
• SILENT=true: Disable console output
• MS365_MCP_CLIENT_ID: Custom Azure app client ID (defaults to built-in app)
• MS365_MCP_TENANT_ID: Custom tenant ID (defaults to ‘common’ for multi-tenant)

Support

If you’re having problems or need help:

• Create an issue
• Start a discussion
• Email: [email protected]
• Discord: https://discord.gg/WvGVNScrAZ or @eirikb

License

MIT © 2025 Softeria