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.
MySQL query server based on the MCP sse.Multi-level SQL risk control & injection protection Docker support for quick deployment
Estrelas
106
Ferramentas
—
Disponibilidade
—
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
All MySQL-related API tools are registered automatically:
No need to manually maintain registration code in the main entry. To add or remove a tool, simply implement a register_xxx_tool(s) function in the src/tools/ directory.
The system scans and registers tools automatically at startup, greatly improving maintainability and extensibility.
连接池自动回收与资源管理 / Connection Pool Auto-Recycling & Resource Management
连接池采用事件循环隔离与自动回收机制:
每个事件循环独立池,支持高并发与多环境。
定期(默认每5分钟)自动回收无效或失效的连接池,防止资源泄漏。
事件循环关闭时自动关闭对应连接池,确保资源彻底释放。
支持多数据库/多租户场景扩展。
所有资源管理操作均有详细日志,便于追踪和排查。
The connection pool uses event loop isolation and auto-recycling:
Each event loop has its own pool, supporting high concurrency and multi-environment deployment.
Unused or invalid pools are automatically recycled every 5 minutes (by default), preventing resource leaks.
When an event loop is closed, its pool is automatically closed to ensure complete resource release.
Ready for multi-database/multi-tenant scenarios.
All resource management operations are logged in detail for easy tracking and troubleshooting.
Q: How to enable database isolation?
A: Set ENABLE_DATABASE_ISOLATION=true and DATABASE_ACCESS_LEVEL=strict, or use ENV_TYPE=production for auto-enable.
Q: Cannot query system tables after enabling database isolation?
A: strict mode blocks system table access. Use restricted mode or verify if system table access is actually needed.
Q: limit参数报错?
A: limit必须为非负整数。
Q: limit parameter error?
A: limit must be a non-negative integer.
10. 贡献指南 / Contribution Guide
欢迎通过Issue和Pull Request参与改进。
Contributions via Issue and Pull Request are welcome.
11. 许可证 / License
MIT License
本软件按"原样"提供,不提供任何形式的明示或暗示的保证,包括但不限于对适销性、特定用途的适用性和非侵权性的保证。在任何情况下,作者或版权持有人均不对任何索赔、损害或其他责任负责,无论是在合同诉讼、侵权行为还是其他方面,产生于、源于或与本软件有关,或与本软件的使用或其他交易有关。
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
M
Mysql MCP Server Sse
mangooer·106 estrelas·
MySQL query server based on the MCP sse.Multi-level SQL risk control & injection protection Docker support for quick deployment
Ainda não há lista de ferramentas. Servidores remotos recebem uma após a primeira verificação de saúde.
Perguntas frequentes
Perguntas
Como instalo Mysql MCP Server Sse?
Copie nesta página a configuração stdio para Cursor, Claude Desktop, Claude Code ou VS Code. Ela usa a instalação do publicador, não um proxy do PlugMCP.
Mysql MCP Server Sse precisa de uma chave de API?
Este registro não lista nenhuma variável de ambiente obrigatória.
Qual transporte Mysql MCP Server Sse usa?
Mysql MCP Server Sse roda localmente via stdio.
Quando Mysql MCP Server Sse foi verificado pela última vez?
Última verificação: 2026-10-27. MySQL query server based on the MCP sse.Multi-level SQL risk control & injection protection Docker support for quick deployment