Official description10 sourcesMCP servers8d ago
Zhwt/go-mcp-mysql
๐๏ธ ๐ - MySQL access with a configurable read-only mode and schema inspection
View on GitHub โDirect link ยท no redirect page
Config template (adjust for your client)
claude mcp add go-mcp-mysql -- npx -y go-mcp-mysql
A pasteable skeleton generated from the repository name. Check the project README for the exact package and arguments.
- Star count
- 66 โ ยท Zhwt/go-mcp-mysql ยท read from the GitHub search API ยท (checked 2026-10-16 20:00:20)
- Source
- collected from the punkpeye/awesome-mcp-servers list ยท type: MCP server
- Harvest history
- first seen 2026-10-09 ยท last seen 2026-10-16 ยท seen 32ร ยท listed by 10 sources
- Score
- score 1,003 ยท 66 โ ยท 10 sources ยท mcp
FAQ (answers come from our records)
How do I install it?
We did not find an install command for this repository (our install coverage is only about 4%). Check its README or releases page.
Who is it for?
We filed it under these tags: MCP ๆๅก. The tags come from the entry itself, not a taxonomy we imposed.
Who maintains it?
repository
Zhwt/go-mcp-mysql๏ผfirst catalogued 2026-10-09๏ผlast seen 2026-10-16ใThere is no official certification or quality rating here โ we record sources and dates only.Third-party quality signals
go-mcp-mysql
ไปฅไธๆๅฝ่ช่ฏฅไปๅบ็ README๏ผ็ๆฎต๏ผ ยท ๅจ GitHub ่ฏปๅฎๆด README โ
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
1. Get the latest release and put it in your $PATH or somewhere you can easily access.
2. Or if you have Go installed, you can build it from source:
Usage
Method A: Using Command Line Arguments
Method B: Using DSN With Custom Options
Please refer to MySQL DSN for more details.
Note: For those who put the binary outside of your $PATH, you need to replace go-mcp-mysql with the full path to the binary: e.g.: if you put the binary in the **Downloads** folder, you may use the following path:
Optional Flags
- Add a --read-only flag to enable read-only mode. In this mode, only tools beginning with list, read_ and desc_ are available. Make sure to refresh/restart the MCP server after adding this flag.
- By default, CRUD queries will be first executed with a EXPLAIN ? statement to check whether the generated query plan matches the expected pattern. Add a --with-explain-check flag to disable this behavior.
Tools
Schema Tools
1. list_database
- List all databases in the MySQL server.
- Parameters: None
- Returns: A list of matching database names.
2. list_table
- List all tables in the MySQL server.
- Parameters:
- name: If provided, list tables with the specified name, same as SQL SHOW TABLES LIKE '%name%'. Otherwise, list all tables.
- Returns: A list of matching table names.
3. create_table
- Create a new table in the MySQL server.
- Parameters:
- query: The SQL query to create the table.
- Returns: x rows affected.
4. alter_table
- Alter an existing table in the MySQL server. The LLM is informed not to drop an existing table or column.
- Parameters:
- query: The SQL query to alter the table.
- Returns: x rows affected.
5. desc_table
- Describe the structure of a table.
- Parameters:
- name: The name of the table to describe.
- Returns: The structure of the table.
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
1. Get the latest release and put it in your $PATH or somewhere you can easily access.
2. Or if you have Go installed, you can build it from source:
Usage
Method A: Using Command Line Arguments
Method B: Using DSN With Custom Options
Please refer to MySQL DSN for more details.
Note: For those who put the binary outside of your $PATH, you need to replace go-mcp-mysql with the full path to the binary: e.g.: if you put the binary in the **Downloads** folder, you may use the following path:
Optional Flags
- Add a --read-only flag to enable read-only mode. In this mode, only tools beginning with list, read_ and desc_ are available. Make sure to refresh/restart the MCP server after adding this flag.
- By default, CRUD queries will be first executed with a EXPLAIN ? statement to check whether the generated query plan matches the expected pattern. Add a --with-explain-check flag to disable this behavior.
Tools
Schema Tools
1. list_database
- List all databases in the MySQL server.
- Parameters: None
- Returns: A list of matching database names.
2. list_table
- List all tables in the MySQL server.
- Parameters:
- name: If provided, list tables with the specified name, same as SQL SHOW TABLES LIKE '%name%'. Otherwise, list all tables.
- Returns: A list of matching table names.
3. create_table
- Create a new table in the MySQL server.
- Parameters:
- query: The SQL query to create the table.
- Returns: x rows affected.
4. alter_table
- Alter an existing table in the MySQL server. The LLM is informed not to drop an existing table or column.
- Parameters:
- query: The SQL query to alter the table.
- Returns: x rows affected.
5. desc_table
- Describe the structure of a table.
- Parameters:
- name: The name of the table to describe.
- Returns: The structure of the table.
- Source
- awesome ยท https://github.com/Zhwt/go-mcp-mysql
- Browse by field
- MCP servers
- Traction
- 66 โ
- added
- yesterday
More in MCP servers
Filed under
Every tag opens the full list for that filter. Counts are the live catalogue figures.