MCP.so
Sign In

MySQLReader

@ChenRongpeng1998

Repository

About MySQLReader

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

Config

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

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

Tools

No tools detected

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

FAQ from MySQLReader

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.

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

Basic information

Category

Other

License

Apache-2.0

Transports

stdio

Author

ChenRongpeng1998

More Other MCP servers

MaxKB

1Panel-dev

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

22.0K

Inbox Zero AI

elie222

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

11.6K

IDA Pro MCP

mrexodia

AI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP.

9.9K

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

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K