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

常见问题

What authentication methods are supported?

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

Is the `file` method secure?

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

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.

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

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

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

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

其他分类下的更多 MCP 服务器

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea