MySQL MCP Server (HTTP/SSE Edition)

A Model Context Protocol (MCP) server implementation for MySQL databases, featuring a stateless HTTP/SSE architecture.

This project is a modified version based on the original work by designcomputer/mysql_mcp_server.

Key Improvements

• Stateless HTTP/SSE Support: Switched from stdio-based communication to an HTTP/SSE model using FastMCP, making it suitable for cloud deployment and remote access.

• Enhanced Configuration: Added support for .env files using python-dotenv.

• Improved Diagnostics: Detailed error messages when database environment variables are missing or incorrect.

• Flexible Deployment: Can be run as a standalone server or managed by AI IDEs like Trae or Claude Desktop.

Related MCP server: MCP MySQL Server

Features

• Tools: Execute custom SQL queries, list tables.

• Resources: Access table data directly via mysql://{table}/data URIs.

• Security: Database credentials managed via environment variables.

Installation

1. Clone this repository:

   git clone <your-repository-url>
   cd mysql_mcp_server_http

2. Install dependencies:

   pip install mcp mysql-connector-python python-dotenv uvicorn

3. Create a .env file in the project root:

   MYSQL_HOST=localhost
   MYSQL_PORT=3306
   MYSQL_USER=root
   MYSQL_PASSWORD=your_password
   MYSQL_DATABASE=your_database

Usage

Manual Start (Standalone)

Run the server using the module command:

python -m mysql_mcp_server_http.server

The server will start on http://0.0.0.0:8000/mcp.

Integrating with AI IDEs (e.g., Trae)

Add the following JSON configuration to your mcpServers settings:

{
  "mcpServers": {
    "mysql_http": {
      "url": "http://127.0.0.1:8000/mcp"
    }
  }
}

Acknowledgements

This project is inspired by and modified from mysql_mcp_server by @designcomputer.

License

MIT License. See LICENSE for details.