go-mcp-mysql

Overview

go-mcp-mysql is a well-structured Model Context Protocol server that enables AI models to interact with MySQL databases. Built in Go, it provides a zero-dependency solution for executing CRUD operations while maintaining security through read-only mode and optional query plan validation. The server implements proper MCP protocol patterns with clearly defined tools for database schema inspection and data manipulation.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• list_database

  List all databases in the MySQL server.

  Try:Show all databasesTry:List databases
• list_table

  List tables in the MySQL server, optionally filtered by name.

  Try:Show all tablesTry:List tables named 'users'
• create_table

  Create a new table in the MySQL server.

  Try:Create a table called 'customers' with columns id and name
• alter_table

  Alter an existing table structure without dropping tables or columns.

  Try:Add a new column to the 'products' table
• desc_table

  Describe the structure of a table.

  Try:Show the structure of the 'orders' table
• read_query

  Execute a read-only SQL query.

  Try:Select all from usersTry:Count the number of records
• write_query

  Execute a write SQL query.

  Try:Insert a new recordTry:Create a new entry
• update_query

  Execute an update SQL query.

  Try:Update user emailTry:Modify prices in the products table
• delete_query

  Execute a delete SQL query.

  Try:Remove old recordsTry:Delete a specific entry

Comparable tools

Installation

go install -v github.com/Zhwt/go-mcp-mysql@latest

{
  "mcpServers": {
    "mysql": {
      "command": "go-mcp-mysql",
      "args": [
        "--host", "localhost",
        "--user", "root",
        "--pass", "password",
        "--port", "3306",
        "--db", "mydb"
      ]
    }
  }
}

FAQ

Is this server safe for production use?

The README mentions it's a work in progress and may not be ready for production use yet. However, it includes security features like read-only mode and query plan checking.

Can I use custom MySQL connection parameters?

Yes, you can use either individual parameters (--host, --user, etc.) or a full DSN string with --dsn flag for more complex configurations.

Compare go-mcp-mysql with