# 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](https://github.com/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.

## 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:
   ```bash
   git clone <your-repository-url>
   cd mysql_mcp_server_http
   ```

2. Install dependencies:
   ```bash
   pip install mcp mysql-connector-python python-dotenv uvicorn
   ```

3. Create a `.env` file in the project root:
   ```env
   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:
```bash
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:

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

## Acknowledgements
This project is inspired by and modified from [mysql_mcp_server](https://github.com/designcomputer/mysql_mcp_server) by @designcomputer.

## License
MIT License. See [LICENSE](LICENSE) for details.