mysql-mcp-server
If you are the rightful owner of mysql-mcp-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 Model Context Protocol (MCP) server that enables secure interaction with MySQL databases.
The MySQL MCP Server is designed to facilitate secure and structured interaction with MySQL databases. It allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface. This server ensures that database exploration and analysis are conducted safely, with features such as secure database access through environment variables and comprehensive logging. The server is easy to install and configure, with clear instructions for setting up environment variables and running the server either as a standalone application or within a Docker container. Security is a top priority, with recommendations for creating a dedicated MySQL user with minimal permissions, avoiding the use of root credentials, and implementing query whitelisting for production environments.
Features
- List available MySQL tables as resources
- Read table contents
- Execute SQL queries with proper error handling
- Secure database access through environment variables
- Comprehensive logging