MySQLReader MCP Server

@ChenRongpeng1998

Basic information

About MySQLReader MCP Server

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

MySQLReader MCP Server config

Add this server to your MCP-compatible client using the configuration below.

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

MySQLReader MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

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.

Comments

More Other MCP servers

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

FastMCP v2 🚀

jlowin

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

26.0K

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

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.