README.md

---
license: apache-2.0
title: MCP test
sdk: gradio
emoji: 🚀
colorFrom: blue
colorTo: green
short_description: This project demonstrates a simple Model Context Protocol (M
---
# MCP Demo Project

This project demonstrates a simple Model Context Protocol (MCP) server integration using Gradio and Python. It includes a sample database and basic server logic for experimentation and learning purposes.

## Project Structure

```
mcp_demo/
├── app.py              # Main application entry point
├── requirements.txt    # Python dependencies
├── server.py           # MCP server implementation
├── data/
│   └── northwind.db    # Sample SQLite database
└── __pycache__/        # Python bytecode cache
```

## Features
- MCP server endpoint (compatible with Gradio MCP client)
- Example SQLite database (Northwind)
- Simple API for experimentation

## Setup Instructions

1. **Clone the repository** (if not already):
   ```sh
   git clone <repo-url>
   cd mcp_demo
   ```

2. **Install dependencies:**
   ```sh
   pip install -r requirements.txt
   ```

3. **Run the server:**
   ```sh
   python server.py
   ```
   or
   ```sh
   python app.py
   ```

4. **Access the MCP server:**
   - The server will be available at `http://127.0.0.1:7860/gradio_api/mcp/sse` (or as configured in `.vscode/mcp.json`).

## Configuration
- The `.vscode/mcp.json` file contains the MCP server URL configuration for local or remote use.

## Requirements
- Python 3.8+
- pip

## License
This project is for educational and demonstration purposes.