Mysql Mcpserver Stdio

🚀 MySQL MCP Server Generator (Supports stdio + SSE)

This project is designed to batch generate MCP server scripts based on MySQL. Each generated script supports two transmission methods:

• stdio – Invoked via local subprocess / pipe
• SSE (HTTP) – Provides remote access through the /sse endpoint (compatible with MCP Inspector)

🚀 Quick Start

📦 Installation

python -m venv .venv
# Windows
.venv\Scripts\activate
# macOS / Linux / WSL
source .venv/bin/activate

pip install -r requirements.txt

💻 Usage Examples

1️⃣ Launch the Generator Interface

python app.py

Open http://127.0.0.1:5000 in your browser and complete the following steps in sequence:

1. Enter MySQL connection information (host, port, user, password, database).
2. Specify the output file name (must end with .py, e.g., my_server.py).
3. Click Generate. The script will automatically include a check_database tool for quick connectivity testing.

2️⃣ Add Custom Tools

Navigate to the “New Tool Function” page and fill in the following information for each SQL query:

Example formatting code:

for row in rows:
    content.append(f"Device Account: {row['username']}")
    content.append(f"IPv4: {row['user_ip4']}")

After saving, the tool function will be automatically inserted into the script.

3️⃣ Run the Generated Server Script

⚠️ Important Note Currently, FastMCP.run() listens on 0.0.0.0:8000 by default. If you need to customize the port, you can set an environment variable before starting, for example:

# Windows
set MCP_PORT=9110
# Linux / macOS / WSL
export MCP_PORT=9110
python my_server.py --http

4️⃣ Test with MCP Inspector

npx @modelcontextprotocol/inspector

• Select SSE for Transport.
• Enter http://127.0.0.1:8000/sse for the URL.

After a successful connection, you can see the automatically discovered tool list on the left and make calls.

📚 Documentation

Project Structure

├── app.py            # Flask GUI Generator
├── templates/        # Jinja2 + Bootstrap Pages
├── static/           # Front-end Static Resources
├── requirements.txt  # Dependency List
└── README.md         # Usage Instructions (This File)

Wish you a smooth development and rapid batch generation of MCP Servers!