MySQL查询服务器 / MySQL Query Server

Name: MySQL查询服务器 / MySQL Query Server
Author: mangooer

@mangooer

关于 MySQL查询服务器 / MySQL Query Server

MySQL query server based on the MCP sse.Multi-level SQL risk control & injection protection Docker support for quick deployment

基本信息

分类

数据库

许可证

MIT

运行时

python

传输方式

stdio

发布者

mangooer

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mysql-mcp-server-sse": {
      "command": "docker",
      "args": [
        "pull",
        "mangooer/mysql-mcp-server-sse:latest"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MySQL查询服务器 / MySQL Query Server?

A MySQL query server built on the MCP framework, supporting real-time database operations via SSE protocol. It provides comprehensive security, logging, configuration, and sensitive information protection for secure MySQL data access in development, testing, and production environments.

How to use MySQL查询服务器 / MySQL Query Server?

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.

Key features of MySQL查询服务器 / MySQL Query Server

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

Use cases of MySQL查询服务器 / MySQL Query Server

Secure MySQL data access in production environments
Database schema exploration and metadata querying
Development and testing with automated SQL risk control
Multi-tenant database isolation for secure multi-database access

FAQ from MySQL查询服务器 / MySQL Query Server

Why does DELETE not work?

DELETE without a WHERE clause is classified as CRITICAL risk. You must allow CRITICAL level in the ALLOWED_RISK_LEVELS environment variable.

How to customize sensitive fields?

Set the SENSITIVE_INFO_FIELDS environment variable with a comma-separated list, e.g., SENSITIVE_INFO_FIELDS=password,token.

How to enable database isolation?

Set ENABLE_DATABASE_ISOLATION=true and DATABASE_ACCESS_LEVEL=strict, or use ENV_TYPE=production which automatically enables database isolation with restricted mode.