mysql_mcp_server

MySQL MCP Server connects AI applications to a MySQL database through MCP. The README lists its features: tables are exposed as resources, table contents can be read, SQL queries run with error handling, access is configured through environment variables, and operations are logged. It is meant to be launched by an MCP client such as Claude Desktop rather than run as a standalone program.

Setup is `pip install mysql-mcp-server` or an install through Smithery for Claude Desktop. You then set `MYSQL_HOST`, `MYSQL_PORT` (default 3306), `MYSQL_USER`, `MYSQL_PASSWORD` and `MYSQL_DATABASE`, and add a server entry to `claude_desktop_config.json`, for example with `uvx --from mysql-mcp-server mysql_mcp_server`. For debugging the README suggests the MCP Inspector instead of running the module directly, and the repo includes tests run with `pytest`.

The README is direct about risk. It says to create a dedicated MySQL user with minimal permissions, never use root or admin accounts, restrict access to necessary operations, enable logging, and consider query whitelisting in production, and it links a SECURITY.md with a restricted-user setup. The licence is MIT and the last push was 2026-08-02. This review is based on the README and repository data; we have not run it ourselves.