🌴 Employee Vacations MCP Server Sample (Streamable HTTP version) - C#

Welcome to the **Employee Vacations MCP Server Sample (Streamable HTTP version)*. In this sample, you will learn how to deploy the MCP Server and then add it to Microsoft Copilot Studio. This sample simulates the scenario of using MCP to connect an internal LOB system to an agent created in Copilot Studio. In this case, the sample mimics an internal application to manage employee vacations.

This MCP Server has multiple tools available:

• getAllEmployeesAsync | Get the list of all the available employees and their vacation days
• getVacationDaysLeftAsync | Get the number of vacation days left for as specific employee
• chargeVacationDaysAsync | Charge vacation days for a specific employee

This is the C# version. For the TypeScript version, please check the employeevacations-http-typescript folder.

⚙️ Prerequisites

• Visual Studio Code (link)
• The .NET SDK (link)
• The Azurite extension for Visual Studio Code (link)
• GitHub account

🚀 Minimal path to awesome

1. Clone this repository by running git clone https://github.com/microsoft/copilot-studio-mcp/ in your terminal

2. Open Visual Studio Code on the subfolder samples/employeevacations-http-csharp

3. Launch the Azurite emulator for the Table service by running the command Azurite: Start Table Service in the command palette (press ctrl + shift + P or cmd + shift + P on Mac)

4. Open the terminal and navigate to the same folder

5. Run dotnet run build to start the server

6. Select PORTS at the top of the Visual Studio Code Terminal

   

7. Select the green Forward a Port button

   

8. Enter 5248 as the port number (this should be the same as the port number you see when you ran the command in step 5). You might be prompted to sign in to GitHub, if so please do this, since this is required to use the port forwarding feature.

9. Right click on the row you just added and select Port visibility > Public to make the server publicly available

10. Ctrl + click on the Forwarded address, which should be something like: https://something-3000.something.devtunnels.ms

11. Select Copy on the following pop-up to copy the URL

    

12. Open to the browser of your choice and paste the URL in the address bar and hit enter

If all went well, you will see the following error message:

{"error":{"code":-32000,"message":"Not Acceptable: Client must accept text/event-stream"},"id":"","jsonrpc":"2.0"}

Don't worry - this error message is nothing to be worried about!

👨‍💻 Use the Employee Vacations MCP Server in Visual Studio Code / GitHub Copilot

To use the Employee Vacations MCP Server, you need to use the URL of your server (can be either your devtunnel URL or your deployed Azure Container App) with the /mcp part at the end and add it as an MCP Server in Visual Studio Code.

1. Press either ctrl + shift + P (Windows/Linux) or cmd + shift + P (Mac) and type MCP

2. Select MCP: Add Server...

3. Select HTTP (HTTP or Server-Sent Events)

4. Paste the URL of your server in the input box

5. Press Enter

6. Enter a name for the server, for instance JokesMCP

7. Select User Settings to save the MCP Server settings in your user settings

8. Open GitHub Copilot

9. Switch from Ask to Agent

10. Make sure the EmployeeVacationMCP server actions are enabled

11. Ask the following question:

    Give me the list of employees and their vacation days

This should give you a response like this:

Now you have added the EmployeesVacationMCP server to Visual Studio Code!