MCP.so
ログイン

MySQL查询服务器 / MySQL Query Server

@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.

コメント

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

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

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

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397