mysql-mcp
If you are the rightful owner of mysql-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
MySQL Readonly MCP Server is a server based on the Model Context Protocol (MCP) that allows access to a MySQL database through a secure read-only query interface.
The MySQL Readonly MCP Server is designed to facilitate secure and efficient read-only access to MySQL databases. It leverages the Model Context Protocol to ensure that all interactions with the database are restricted to read-only operations, thereby enhancing security and preventing unauthorized data modifications. The server uses a connection pool to manage database connections efficiently, supports parameterized queries to prevent SQL injection, and automatically limits the number of query results to prevent excessive data retrieval. Additionally, it provides formatted query result outputs and includes built-in security checks to ensure compliance with read-only restrictions. This server is ideal for applications that require safe and controlled access to database information without the risk of data alteration.
Features
- Supports read-only query operations on MySQL databases
- Manages database connections using a connection pool
- Automatically limits the number of query results
- Supports parameterized queries
- Provides formatted query result outputs
