広告掲載
MCP.so
ログイン

MySQL查询服务器 / MySQL Query Server MCP Server

@mangooer

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

mangooer

MySQL查询服务器 / MySQL Query Server MCP Server について

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

MySQL查询服务器 / MySQL Query Server MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

MySQL查询服务器 / MySQL Query Server MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは 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

よくある質問

1

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.

2

How to customize sensitive fields?

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

3

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.

4

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.

コメント

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

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

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
広告掲載