CIAOPS AI Dojo 005–MCP Servers

bp1

What’s the session about?

Empower attendees to design, build, and deploy intelligent chat agents using MCP servers, with a focus on real-world automation, integration, and user experience

Who should attend?

This session is perfect for:

  • IT administrators and support staff
  • Business owners
  • People looking to get more done with Microsoft 365
  • Anyone looking to automate their daily grind

Save the Date

Date: Friday the 31st of October 2025

Time: 9:30 AM Sydney AU time

Location: Online (link will be provided upon registration)

Cost: $80 per attendee (free for Dojo subscribers)

Register Now

Small Business, Big AI Impact: Understanding the AI MCP Server

bp1

Imagine Artificial Intelligence (AI) as a super-smart assistant that can answer questions, write emails, or even create images. However, this assistant usually only knows what it was taught during its “training.” It’s like a brilliant student who only knows what’s in their textbooks.

Now, imagine this assistant needs to do something practical for a business, like check a customer’s order history in your sales system, or update a project status in your team’s tracking tool. The problem is, your AI assistant doesn’t automatically know how to “talk” to all these different business systems. It’s like our brilliant student needing to call different departments in a company, but not having their phone numbers or knowing the right way to ask for information.

This is where an AI MCP server comes in.

In non-technical terms, an AI MCP server (MCP stands for Model Context Protocol) is like a universal translator and connector for your AI assistant.

Think of it as:

  • A “smart switchboard”: Instead of your AI needing to learn a new way to communicate with every single business tool (like your accounting software, email system, or inventory database), the MCP server acts as a central hub. Your AI assistant just “talks” to the MCP server, and the MCP server knows how to connect to all your different business systems and translate the information back and forth.
  • A “library of instructions”: The MCP server contains the “recipes” or “instructions” for how your AI can interact with specific tools and data sources. So, if your AI needs to find a customer’s last purchase, the MCP server tells it exactly how to ask your sales system for that information, and then presents the answer back to the AI in a way it understands.
  • A “security guard”: It also helps manage what information the AI can access and what actions it can take, ensuring sensitive data stays secure and the AI doesn’t do anything it shouldn’t.

Why is this important for small businesses?

For small businesses, an AI MCP server is incredibly important because it allows them to:

  1. Unlock the full potential of AI without huge costs: Instead of hiring expensive developers to build custom connections between your AI and every piece of software you use, an MCP server provides a standardized, off-the-shelf way to do it. This saves a lot of time and money.
  2. Make AI truly useful and practical: Generic AI is helpful, but AI that understands and interacts with your specific business data (like customer details, product stock, or project deadlines) becomes a game-changer. An MCP server makes your AI assistant “aware” of your business’s unique context, allowing it to provide much more accurate, relevant, and actionable insights.
  3. Automate tasks that require multiple systems: Imagine your AI automatically updating your customer relationship management (CRM) system, sending an email confirmation, and updating your inventory, all from a single request. An MCP server enables this kind of multi-step automation across different software.
  4. Improve efficiency and save time: By connecting AI directly to your existing tools and data, employees spend less time manually searching for information, switching between applications, or performing repetitive data entry. This frees up staff to focus on more strategic and valuable tasks.
  5. Enhance customer service: An AI-powered chatbot connected via an MCP server can instantly access real-time customer data (purchase history, support tickets) to provide personalized and accurate responses, leading to happier customers.
  6. Stay competitive: Larger businesses often have the resources for complex AI integrations. An MCP server helps level the playing field, allowing small businesses to adopt advanced AI capabilities more easily and gain a competitive edge.
  7. Future-proof their AI investments: As new AI models and business tools emerge, an MCP server helps ensure that your existing AI setup can adapt and connect to them without major overhauls.

In essence, an AI MCP server transforms AI from a clever but isolated tool into a powerful, integrated assistant that can truly understand and interact with the unique workings of a small business, making operations smoother, smarter, and more efficient.

Need to Know podcast–Episode 349

Explore the future of AI integration, Microsoft Cloud updates, and security innovations tailored for the SMB market. In this episode, we dive into the transformative role of AI MCP servers, the latest Microsoft 365 and Teams updates, and practical security and compliance strategies. Whether you’re an IT pro, business leader, or tech enthusiast, this episode delivers actionable insights and resources to stay ahead in the Microsoft ecosystem.

Brought to you by www.ciaopspatron.com

you can listen directly to this episode at:

https://ciaops.podbean.com/e/episode-349-mcp-is-for-me/

Subscribe via iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

or Spotify:

https://open.spotify.com/show/7ejj00cOuw8977GnnE2lPb

Don’t forget to give the show a rating as well as send me any feedback or suggestions you may have for the show.

Resources

CIAOPS Need to Know podcast – CIAOPS – Need to Know podcasts | CIAOPS

X – https://www.twitter.com/directorcia

Join my Teams shared channel – Join my Teams Shared Channel – CIAOPS

CIAOPS Merch store – CIAOPS

Become a CIAOPS Patron – CIAOPS Patron

CIAOPS Blog – CIAOPS – Information about SharePoint, Microsoft 365, Azure, Mobility and Productivity from the Computer Information Agency

CIAOPS Brief – CIA Brief – CIAOPS

CIAOPS Labs – CIAOPS Labs – The Special Activities Division of the CIAOPS

Support CIAOPS – https://ko-fi.com/ciaops

Get your M365 questions answered via email

Show Notes

What’s new in Microsoft Entra – June 2025: Highlights include upcoming support for backing up account names in the Authenticator app using iCloud Keychain
Enhancing Defense Security with Entra ID Governance: Discusses how Entra ID Governance strengthens defense sector security
What’s New in Microsoft Teams | June 2025: Covers new Teams features and enhancements 3.
What’s new in Microsoft Intune: June 2025: Summarizes Intune updates including device management improvements
Microsoft Intune data-driven management | Device Query & Copilot: Introduces new Copilot-powered device query features

Data Breach Reporting with Microsoft Data Security Investigations: Guidance on regulatory breach reporting
Modern, unified data security in the AI era: New Microsoft Purview capabilities for AI-driven data protection
Safeguarding data with Microsoft 365 Copilot: Focuses on compliance and security in Copilot deployments
Protection Against Email Bombs: Microsoft Defender for Office 365 introduces new protections
Introducing the Microsoft 365 Copilot App Learning Series: Learning resources for Copilot adoption
Making the Most of Attack Simulation Training: Best practices for security training
Processing status pane for SharePoint Autofill: New UI enhancements for SharePoint
Introducing the New SharePoint Template Gallery: Streamlined template discovery and usage
Planning your move to Microsoft Defender portal: Transition guidance for Sentinel customers
Jasper Sleet: North Korean IT infiltration tactics: Threat intelligence update
Managing warehouse devices with Microsoft Intune: Real-world Intune use case

Integrating Microsoft Learn Docs with Copilot Studio using MCP

Integrating Microsoft Learn Docs with Copilot Studio using MCP

bp1_thumb[2]

Are you looking to empower your Copilot Studio agent with the vast knowledge of Microsoft’s official documentation? By leveraging the Model Context Protocol (MCP) server for Microsoft Learn Docs, you can enable your agent to directly access and reason over this invaluable resource. This blog post will guide you through the process step-by-step.


What is the Model Context Protocol (MCP)?

MCP is a powerful standard designed to allow AI agents to discover tools, stream data, and perform actions. The Microsoft Learn Docs MCP Server specifically exposes Microsoft’s official documentation (spanning Learn, Azure, Microsoft 365, and more) as a structured knowledge source that your Copilot Studio agent can query and utilize.


Prerequisites

  • Copilot Studio Environment: An active Copilot Studio environment with Generative Orchestration enabled (you may need to activate “early features”).
  • Environment Maker Rights: Sufficient permissions in your Copilot Studio environment to create and manage connectors.
  • Outbound HTTPS: Your environment must permit outbound HTTPS connections to learn.microsoft.com/api/mcp.
  • Text Editor: A text editor (e.g., VS Code, Notepad++) for creating a YAML file.


Configuration Steps

Step 1: Grab the Minimal YAML Schema

The Microsoft Learn Docs MCP Server requires a specific OpenAPI (Swagger) YAML file to define its API. Create a new file (e.g., ms-docs-mcp.yaml) and paste the following content into it:

swagger: '2.0'
info:
  title: Microsoft Docs MCP
  description: Streams Microsoft official documentation to AI agents via Model Context Protocol.
  version: 1.0.0
host: learn.microsoft.com
basePath: /api
schemes:
  - https
paths:
  /mcp:
    post:
      summary: Invoke Microsoft Docs MCP server
      x-ms-agentic-protocol: mcp-streamable-1.0
      operationId: InvokeDocsMcp
      consumes:
        - application/json
      produces:
        - application/json
      responses:
        '200':
          description: Success

Save this file with a .yaml extension.

Note: This YAML file is available for download here: ms-docs-mcp.yaml on GitHub

Step 2: Import as a Custom Connector in Power Apps

Copilot Studio leverages Custom Connectors, managed within Power Apps, to interface with external APIs like the MCP server.

  1. Go to Power Apps: Navigate to make.powerapps.com.
  2. Custom Connectors: In the left navigation pane, select More > Discover all > Custom connectors.
  3. New Custom Connector: Click on + New custom connector and choose Import an OpenAPI file.
  4. Upload YAML:

    • Give your connector a descriptive name (e.g., “Microsoft Learn MCP”).
    • Upload the .yaml file you prepared in Step 1.
    • Click Import.

  5. Configure Connector Details:

    • General tab: Confirm that the Host is learn.microsoft.com and Base URL is /api.
    • Security tab: For the Microsoft Learn Docs MCP server, select No authentication (as it is currently anonymously readable).
    • Definition tab: Verify that an action named InvokeDocsMcp is present. You can also add a description here if desired.

  6. Create Connector: Click Create connector.
  7. Test Connection (Optional but Recommended): After the connector is created, go to the Test tab. Click +New Connection. Ensure the connection status is “Connected.”

Step 3: Wire It Into an Agent in Copilot Studio

With your custom connector in place, the next step is to add it as a tool to your Copilot Studio agent.

  1. Go to Copilot Studio: Navigate to copilotstudio.microsoft.com. Ensure you are in the same environment where you created the custom connector.
  2. Open/Create Agent: Open your existing agent or create a new one.
  3. Add Tool:

    • In the left navigation, select Tools.
    • Click + Add a tool.
    • Select Model Context Protocol.
    • You should now see your newly created “Microsoft Learn MCP” custom connector in the list. Select it.
    • Confirm that the connection status is green.
    • Click Add to agent (or “Add and configure” if you wish to set specific details).

  4. Verify Tool: The MCP server should now appear in the Tools list for your agent. If you click on it, you should see the microsoft_docs_search tool (or similar, as Microsoft may add more tools in the future).

Step 4: Validate (Test Your Agent)

It’s crucial to test your setup to ensure everything is working as expected.

  1. Open Test Pane: In Copilot Studio, open the “Test your agent” pane.
  2. Enable Activity Map (Optional): Click the wavy map icon to visualize the activity flow.
  3. Ask a Question: Try posing questions directly related to Microsoft documentation. For instance:

    • “What MS certs should I look at for Power Platform?”
    • “How can I extend the Power Platform CoE Starter Kit?”
    • “What modern controls in Power Apps are GA and which are still in preview?”

The first time you execute a query, you might be prompted to connect to the custom connector you’ve just created. Click “Connect,” and then retry the query. Your agent should now leverage the Microsoft Learn MCP server to furnish accurate and relevant answers directly from the official documentation.


Important Considerations:

  • Authentication: Currently, the Microsoft Learn Docs MCP server operates without requiring authentication. However, this policy is subject to change, so always consult the latest Microsoft documentation for updates.
  • Generative Orchestration: This feature is fundamental for the agent to effectively utilize MCP. If you don’t see “Model Context Protocol” under your Tools, ensure generative orchestration is enabled for your environment.
  • Updates: As Microsoft updates its documentation, the MCP server should dynamically reflect these changes, ensuring your agent’s knowledge remains current.

By following these steps, you can successfully integrate the Microsoft Learn documentation server into your Copilot Studio agent, providing your users with a powerful and reliable source of official information.