広告掲載
MCP.so
ログイン

MySQLReader MCP Server

@ChenRongpeng1998

リポジトリ

基本情報

カテゴリ

その他

ライセンス

Apache-2.0

トランスポート

stdio

作者

ChenRongpeng1998

MySQLReader MCP Server について

This is a MCP server about read data from mysql databsase .

MySQLReader MCP Server の設定

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

{
  "mcpServers": {
    "MySQLReader": {
      "command": "uv",
      "args": [
        "sync",
        "#",
        "同步环境"
      ]
    }
  }
}

MySQLReader MCP Server のツール

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

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

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MySQLReader?

MySQLReader is an MCP server that enables read‑only access to MySQL databases. It uses the pymysql library and supports three authentication methods: environment variables, plaintext files, and RSA‑encrypted files. This server is designed for security‑conscious environments where only SELECT queries are permitted.

How to use MySQLReader?

Install uv, clone the repository, run uv sync, and activate the virtual environment. The main script is mysql_reader.py, which requires host and db arguments. Authentication can be configured with --authentication-method (ev, file, or efile) and additional flags like --evname-user, --file-path, or --private_key_file_name. For Claude Desktop, add a mysql_reader entry to claude_desktop_config.json with appropriate arguments.

Key features of MySQLReader

  • Read‑only MySQL queries (no INSERT, UPDATE, DELETE)
  • Three credential storage methods: env, file, encrypted file
  • RSA‑encrypted credential file support (efile)
  • Works with Claude Desktop via MCP configuration
  • Built on pymysql for database connectivity

Use cases of MySQLReader

  • Safely query a MySQL database without exposing credentials in plaintext
  • Integrate MySQL read access with Claude Desktop for data‑driven conversations
  • Use encrypted credential storage for compliance‑sensitive environments
  • Provide a restricted database interface for AI agents

よくある質問

1

What authentication methods are supported?

Three methods: `ev` (environment variables), `file` (plaintext file), and `efile` (RSA‑encrypted file). The default is `ev`.

2

Is the `file` method secure?

No. The README explicitly warns that storing credentials in a plaintext file is insecure and not recommended.

3

How do I generate encrypted credentials for the `efile` method?

Use the provided `RSA_key_generator.py` script. It can generate a new RSA key pair or use an existing public key to encrypt the username and password into a `.enc` file.

4

What are the required arguments for `mysql_reader.py`?

Host and database name are required. Authentication‑method and related flags are optional (with defaults).

5

Can I modify data (INSERT/UPDATE/DELETE) through this server?

No. The server is intentionally limited to read‑only queries for security reasons.

コメント

「その他」の他のコンテンツ

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

ICSS

chokcoco

不止于 CSS

20.7K

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

広告掲載