mcp-mysql-server
If you are the rightful owner of mcp-mysql-server 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.
A lightweight Model Context Protocol (MCP) server that enables secure interaction with MySQL databases.
The Simple MCP MySQL Server is designed to facilitate secure and efficient interaction with MySQL databases through a controlled interface. It allows AI assistants, such as Claude, to perform operations like listing tables, retrieving schema information, and executing read-only SQL queries. The server emphasizes security by using environment variables for database access and supports easy configuration and deployment. It is particularly useful for applications that require a lightweight and secure method to interact with MySQL databases without exposing sensitive operations or data.
Features
- List all MySQL tables in the database
- Retrieve detailed schema information for all tables
- Execute read-only SQL queries with proper error handling
- Secure database access through environment variables
- Simple configuration and deployment
Tools
query_data
Execute read-only SQL queries and return results