Summary
A database an agent can be handed without also handing it a way to change anything.
There is no insert, update or schema-change call in the tool set — query is described as a SELECT, and the rest is inventory and structure. Values travel in params next to the sql string rather than inside it. connect_db makes the target switchable at run time, so one server can be pointed at a different host or database mid-session instead of being restarted with new environment variables.
What it is
A MySQL server whose tool set stops at reading: connect, list, describe and SELECT.
What you get
- SELECT execution where the statement and its values are separate arguments, so values are bound rather than pasted into the SQL string.
- The table list for the connected database.
- The column structure of any single table.
- A connection opened at call time from host, user, password, database and port, for the case where the environment does not already carry them.
Requirements
A reachable MySQL database, with MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE and MYSQL_PORT in the environment; connect_db takes the same values as arguments when they are not set.
Setup effort
One command plus a key — npx @malove86/mcp-mysql-server, then supply credentials