go-mcp-mysql
Overview
Zero burden, ready-to-use Model Context Protocol (MCP) server for interacting with MySQL and automation. No Node.js or Python environment needed. This server provides tools to do CRUD operations on MySQL databases and tables, and a read-only mode to prevent surprise write operations. You can also make the MCP server check the query plan by using a EXPLAIN statement before executing the query by adding a --with-explain-check flag.
Please note that this is a work in progress and may not yet be ready for production use.
Installation
Get the latest release and put it in your
$PATHor somewhere you can easily access.Or if you have Go installed, you can build it from source:
go install -v github.com/Zhwt/go-mcp-mysql@latestUsage
Method A: Using Command Line Arguments
{
"mcpServers": {
"mysql": {
"command": "go-mcp-mysql",
"args": [
"--host", "localhost",
"--user", "root",
"--pass", "password",
"--port", "3306",
"--db", "mydb"
]
}
}
}
