go -mysql

go-mcp-mysql is a single, zero-dependency executable that exposes a MySQL MCP (Model Context Protocol) server. It supports both command-line parameter configuration and DSN-based configuration, allowing you to manage databases, tables, and perform read/write CRUD operations through a set of built-in tools. The server can run in read-only mode to prevent modifications, and you can enable an optional EXPLAIN check to analyze query plans before executing CRUD operations. Tools are organized into database/schema management (e.g., list_database, list_table, create_table, alter_table, desc_table, use_database) and data operations (read_query, write_query, update_query, delete_query). Each tool takes specific arguments (for example, read_query accepts a SELECT statement, create_table accepts a CREATE TABLE statement), and responses reflect the results or affected rows. To run using the command-line configuration shown, ensure the binary is accessible in your PATH and start the server with the specified host, user, password, port, and database, or adjust these parameters to your environment. You can also switch to a DSN string using the --dsn option to connect to your MySQL instance.

Prerequisites:

• A MySQL server you want to manage
• Optional: a pre-built binary for your OS from the releases page, or a Go 1.21+ environment to build from source

Installation steps (Option 1: download binary):

1. Download the appropriate binary from the Releases page: https://github.com/pengcunfu/go-mcp-mysql/releases
2. Place the binary in a directory on your PATH, e.g. /usr/local/bin
3. Run the server, for example: go-mcp-mysql --host localhost --user root --pass password --port 3306 --db mydb

Installation steps (Option 2: build from source):

1. Ensure Go 1.21+ is installed
2. Build and install the binary: go install -v github.com/pengcunfu/go-mcp-mysql@latest
3. Ensure $GOPATH/bin or your Go binaries directory is in your PATH
4. Run the server as above

Configuration options can be provided either via command-line arguments or via a DSN string as described in the README. If you prefer the DSN approach, use --dsn with a DSN formatted string instead of individual --host/--db/etc values.

Tips and notes:

• You can enable read-only mode with --read-only to restrict operations to listing and reading data, preventing modifications.
• If you change configuration flags, you typically need to restart the MCP server for changes to take effect.
• The toolset includes both database/schema management and data operation commands; use list_database/list_table to explore your schema, then use read_query/write_query/update_query/delete_query for CRUD operations.
• For DSN usage, refer to the official MySQL DSN format and ensure parseTime and loc parameters are appropriate for your needs.
• If the binary is not in your PATH, you can provide the absolute path to the binary in the command configuration.
• Security: avoid exposing credentials in logs or publicly accessible configurations.