# mysql-mcp-server-sse — FastMCP MySQL Server (SSE)

> MySQL query server built on FastMCP with SSE streaming, SQL risk controls, injection protection, and Docker quick start; verified 101★, pushed 2025-06-19.

## Install

Merge the JSON below into your `.mcp.json`:

## Quick Use

```bash
docker pull mangooer/mysql-mcp-server-sse:latest
docker run -d --name mysql-mcp-server-sse -e HOST=0.0.0.0 -e PORT=3000 -e MYSQL_HOST=your_mysql_host -e MYSQL_PORT=3306 -e MYSQL_USER=your_mysql_user -e MYSQL_PASSWORD=your_mysql_password -e MYSQL_DATABASE=your_database -p 3000:3000 mangooer/mysql-mcp-server-sse:latest
# Default SSE endpoint (README):
curl -sS http://127.0.0.1:3000/sse | head
```

## Intro

MySQL query server built on FastMCP with SSE streaming, SQL risk controls, injection protection, and Docker quick start; verified 101★, pushed 2025-06-19.

**Best for:** Safer agent-to-MySQL access where you need streaming results plus SQL risk controls

**Works with:** MySQL + Docker for quick start, or Python source run; SSE endpoint shown in README

**Setup time:** 15-35 minutes

### Key facts (verified)

- GitHub: 101 stars · 32 forks · pushed 2025-06-19.
- License: MIT · owner avatar + repo URL verified via GitHub API.
- README-backed entrypoint: `docker pull mangooer/mysql-mcp-server-sse:latest`.

## Main

- Use Docker for the fastest start: README shows env vars for host/port and MySQL connection settings.

- Treat SQL risk controls as part of your agent policy: keep a readonly DB user and pair it with the server’s interception/limiting layers.

- Use the SSE endpoint when you need progressive results for long queries, but still keep query limits + timeouts to avoid runaway scans.

- Keep schema isolation explicit: README calls out database isolation security to prevent cross-database access.

### Source-backed notes

- README lists key features including SSE streaming, SQL risk control/injection protection, logging, and Docker support.
- README Quick Start provides Docker run example and a source run (`pip install -r requirements.txt` + `python -m src.server`).
- README states the default SSE endpoint: `http://127.0.0.1:3000/sse`.

### FAQ

- **Is Docker required?**: No — README also shows running from source with Python, but Docker is the quickest path.
- **Where is the SSE endpoint?**: README states the default endpoint is `http://127.0.0.1:3000/sse`.
- **How do I keep it safe for agents?**: Use a readonly DB user, keep SQL limits tight, and rely on the server’s risk controls/injection protection layers.

## Source & Thanks

> Source: https://github.com/mangooer/mysql-mcp-server-sse
> License: MIT
> GitHub stars: 101 · forks: 32

---

<!-- ZH -->

## Quick Use

```bash
docker pull mangooer/mysql-mcp-server-sse:latest
docker run -d --name mysql-mcp-server-sse -e HOST=0.0.0.0 -e PORT=3000 -e MYSQL_HOST=your_mysql_host -e MYSQL_PORT=3306 -e MYSQL_USER=your_mysql_user -e MYSQL_PASSWORD=your_mysql_password -e MYSQL_DATABASE=your_database -p 3000:3000 mangooer/mysql-mcp-server-sse:latest
# Default SSE endpoint (README):
curl -sS http://127.0.0.1:3000/sse | head
```

## Intro

mysql-mcp-server-sse 是基于 FastMCP 的 MySQL 查询服务器：支持 SSE 实时推送、多级 SQL 风险控制与注入防护，并提供 Docker 快速部署；已验证 101★，更新于 2025-06-19。

**Best for:** 希望在 agent 访问 MySQL 时做到“可流式返回 + SQL 风控/注入防护”的场景

**Works with:** MySQL + Docker 快速启动，或用 Python 源码运行；README 给出 SSE endpoint

**Setup time:** 15-35 minutes

### Key facts (verified)

- GitHub：101 stars · 32 forks；最近更新 2025-06-19。
- 许可证：MIT；作者头像与仓库链接均已通过 GitHub API 复核。
- README 中可对照的入口命令：`docker pull mangooer/mysql-mcp-server-sse:latest`。

## Main

- 最快方式是 Docker：README 给出 HOST/PORT 与 MySQL 连接信息的环境变量清单。

- 把风控当成策略层：仍然建议只读账号起步，再叠加服务端的 SQL 拦截/限制能力。

- 需要长查询的渐进结果时使用 SSE，但依然要加 query limit/timeout，避免 agent 触发全表扫描。

- 明确 schema 隔离：README 强调防止跨数据库访问并提供分级访问控制。

### Source-backed notes

- README 列出 SSE 实时推送、多级 SQL 风险控制/注入防护、日志与 Docker 快速部署等特性。
- README 的 Quick Start 同时给出 Docker 运行与源码运行方式（`pip install -r requirements.txt` + `python -m src.server`）。
- README 写明默认 SSE endpoint 为 `http://127.0.0.1:3000/sse`。

### FAQ

- **必须用 Docker 吗？**：不必须；README 也给出 Python 源码运行方式，但 Docker 最快。
- **SSE endpoint 在哪里？**：README 写明默认是 `http://127.0.0.1:3000/sse`。
- **如何更安全地给 agent 用？**：从只读账号开始，严格限制查询范围与超时，并结合服务端风控/注入防护层。

## Source & Thanks

> Source: https://github.com/mangooer/mysql-mcp-server-sse
> License: MIT
> GitHub stars: 101 · forks: 32


---
Source: https://tokrepo.com/en/workflows/mysql-mcp-server-sse-fastmcp-mysql-server-sse
Author: MCP Hub