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.

Cannot query system tables after enabling database isolation?

The strict mode blocks access to system tables. Switch to restricted mode (which allows system databases) if you need that access.

「データベース」の他のコンテンツ

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412