MySQLReader

MySQLReader

0
databases

The MySQLReader is a Model Context Protocol service designed to query MySQL databases securely. It uses pymysql and supports various authentication methods, including encrypted storage with RSA encryption. The service is intended for integration with the Claude Desktop platform.

MySQLReader

  • A service for reading from MySQL databases, it only supports query operations for security reasons.
  • The database functions are implemented with the pymysql library.
  • Supports three authentication methods:
    • ev: Using environment variables.
    • file: Storing username and password in a text file.
    • efile: Encrypting credentials with RSA encryption.

Installation

  1. Install uv for Python management.
  2. Clone the repository.
  3. Sync the environment and activate the virtual environment.

Usage

  • Command line usage available with various authentication options.
  • Integration into Claude Desktop through configuration JSON.

Authentication Method Details

  1. Environment Variables (ev): Use environment variables for credentials.
  2. Explicit File (file): Store credentials in a text file (not secure).
  3. Encrypted File (efile): Encrypt credentials and use RSA keys for decryption.