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

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.