go -mysql

This MCP server provides a set of tools to interact with a MySQL server through a Model Context Protocol interface. It supports CRUD operations on databases and tables, as well as read-only mode to prevent unintended writes. You can optionally enable an explain check so that the server runs an EXPLAIN on each write operation to validate the generated query plan before executing it. Use the available schema tools to inspect and modify database schemas, and data tools to read or modify data in a controlled way. The server is designed to be lightweight and self-contained, requiring no Node.js or Python environment since it’s implemented in Go.

Prerequisites:

• Go or a pre-built binary is available in your environment.
• Access to the MySQL server you want to manage.

Installation steps:

1. Release binary approach:

# Download the latest release and place it in a directory in your PATH
# Example path adjustment may be required for your OS
# After downloading, ensure the binary is executable and accessible via your shell

2. Build from source (requires Go):

# Install the latest version from GitHub
go install -v github.com/Zhwt/go-mcp-mysql@latest

3. Verify installation:

# Ensure the binary is available in PATH
which go-mcp-mysql
# Or check version/help
go-mcp-mysql --help

4. Run with your desired configuration (example shown in the README):

# Using the example configuration from the README
# You can run the server directly or wire it into your MCP orchestration.

Notes and tips:

• The server supports a read-only mode via the --read-only flag. In read-only mode, only list, read_, and desc_ tools are available.
• By default, CRUD queries are executed with an EXPLAIN check for safety. Use --with-explain-check to disable this behavior.
• If you place the binary outside of your PATH, specify the full path to the executable in the command field, as shown in the README's example for a local path.
• You can choose between using command-line arguments or a DSN string to configure the connection to MySQL (see the DSN example in the README).
• Ensure network access and proper permissions for the user account to perform the desired operations on the MySQL server.