mysql-mcp

mysql-mcp

2
databases

The MySQL Readonly MCP Server is designed to provide a secure read-only interface to access MySQL databases via MCP. It features a connection pool, query limits, parameterization for security, and formatted outputs. It is suitable for environments needing strict read-only data access control.

MySQL Readonly MCP Server

  • Provides read-only query access to MySQL databases via a secure interface.
  • Key features include connection pool management, query result limits, parameterized queries, and formatted output.
  • Includes built-in security measures to prevent non-read-only operations.

System Requirements

  • Python 3.10+
  • MySQL 5.7+
  • aiomysql

Security Features

  • Allows read-only operations only
  • Prevents multi-statement executions
  • Automatically limits query result count
  • Uses parameterized queries to prevent SQL injection

Note

  • Ensure database users have read-only permissions
  • A resource description file is required to define allowed queries
  • Default query result limit is 20 lines, adjustable via environment variable

Contribution

Contributions via issues and pull requests are welcome.