About MCP Server demo
A demo MCP server written in Python for developers to test in VS Code with GitHub Copilot Agent mode. It demonstrates Copilot calling tools to analyze CSV and Parquet files.
Key features
- 01Python MCP server example
- 02Run and test in VS Code
- 03Use with GitHub Copilot Agent mode
- 04Demonstrate CSV and Parquet analysis
Use cases
- 01Test an MCP server in VS Code
- 02Ask Copilot to summarize a CSV file
- 03Ask Copilot to count Parquet rows
MCP support
It is a demo server for MCP clients. The README shows how to run it in VS Code and have Copilot Agent mode call its tools.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMEMCP Server demo
This is a demo of an MCP server and it's intended to be tested in vscode.
Based on Building a Basic MCP Server with Python by Alex Merced
Development
Start a new Devbox shell that has your packages and tools installed:
devbox shell
Testing it in vscode
Requirements
- VSCode Version =>1.99.0
Instructions
- Open the environment in the devcontainer (vscode command palette >
Dev Containers: Reopen in Container) - Run
task mix-server:run - Open the command palette and select
MCP: List Servers - Choose
mix_server - Start it
- Set Copilot to
Agent modeby choosing "Agent" in the dropdown option next to the prompt textbox. - Ask Github copilot something like "Summarize the CSV file named sample.csv." or "How many rows are in sample.parquet?" Copilot will detect the appropriate tool, call the MCP server, and respond with the results—powered by the Python code.
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.