All clients

MCP Server

Microsoft Copilot

Query your business data from Microsoft 365

Connect Midday to Microsoft Copilot Studio. Ask about invoices, transactions, and reports from Word, Excel, Outlook, or any Copilot-enabled app.

What you can ask

  • "What invoices are overdue?"
  • "Show my profit for last month"
  • "How much did I spend on software?"
  • "List my top 5 customers by revenue"

Don't have an API key? Create one in Settings → Developer

Connection details

Use these settings when adding Midday as an MCP server in Copilot Studio:

Server URL: https://api.midday.ai/mcp
Authentication: API Key
Header Name: Authorization
Header Value: Bearer YOUR_API_KEY

Setup steps

  1. 1
    Open Copilot Studio

    Go to copilotstudio.microsoft.com and open your agent (or create a new one)

  2. 2
    Add an MCP server

    Go to Tools → Add a tool → New tool → Model Context Protocol

  3. 3
    Configure the connection

    Enter the server URL: https://api.midday.ai/mcp

    Select "API Key" authentication and add your key as a Bearer token in the Authorization header

  4. 4
    Start using Midday tools

    Midday's tools will appear in your agent. Ask questions about invoices, transactions, customers, and more.

Requirements

  • •Microsoft 365 license with Copilot Studio access
  • •Midday API key (create in Settings → Developer)
View Microsoft documentation