MySQL查询服务器 / MySQL Query Server
About
MySQL query server based on the MCP sse.Multi-level SQL risk control & injection protection Docker support for quick deployment
Details
- Author
- mangooer
- GitHub stars
- 104
- Downloads
- 422
- Categories
- Database
Jump to
- High-performance async with FastMCP framework
- Connection pool with flexible parameter tuning
- SSE real-time push support
- Multi-level SQL risk control & injection protection
- Database isolation with three-level access control
- Automatic sensitive info masking
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MySQL查询服务器 / MySQL Query ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Deploy via Docker with environment variables for MySQL connection, or run from source using python -m src.server. The server listens on an SSE endpoint (/sse) by default. Configuration is done through environment variables or a .env file.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mysql\u67e5\u8be2\u670d\u52a1\u5668 / mysql query server": {
"mysql-mcp-server-sse": {
"command": "docker",
"args": [
"pull",
"mangooer/mysql-mcp-server-sse:latest"
]
}
}
}
}McpServers
{
"mysql-mcp-server-sse": {
"command": "docker",
"args": [
"pull",
"mangooer/mysql-mcp-server-sse:latest"
]
}
}MySQL查询服务器 / MySQL Query Server
---
1. 项目简介 / Project Introduction
本项目是基于MCP框架的MySQL查询服务器，支持通过SSE协议进行实时数据库操作，具备完善的安全、日志、配置和敏感信息保护机制，适用于开发、测试和生产环境下的安全MySQL数据访问。
This project is a MySQL query server based on the MCP framework, supporting real-time database operations via SSE protocol. It features comprehensive security, logging, configuration, and sensitive information protection mechanisms, suitable for secure MySQL data access in development, testing, and production environments.
---
2. 主要特性 / Key Features
- 基于FastMCP框架，异步高性能
- 支持高并发的数据库连接池，参数灵活可调
- 支持SSE实时推送
- 丰富的MySQL元数据与结构查询API
- 自动事务管理与回滚
- 多级SQL风险控制与注入防护
- 数据库隔离安全：防止跨数据库访问，支持三级访问控制
- 敏感信息自动隐藏与自定义
- 灵活的环境变量配置
- 完善的日志与错误处理
- Docker支持，快速部署
- Built on FastMCP framework, high-performance async
- Connection pool for high concurrency, with flexible parameter tuning
- SSE real-time push support
- Rich MySQL metadata & schema query APIs
- Automatic transaction management & rollback
- Multi-level SQL risk control & injection protection
- Database Isolation Security: Prevents cross-database access with 3-level access control
- Automatic and customizable sensitive info masking
- Flexible environment variable configuration
- Robust logging & error handling
- Docker support for quick deployment
---
3. 快速开始 / Quick Start
Docker 方式 / Docker Method
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
