Server facts
mcp-mysql-server
Project
- Author
- huangfeng19820712
- License
- MIT
- Category
- Databases
Tech
- Runtime / language
- node
- Transports
- stdio
- Remote available
- No
- Authentication
- Not specified
Activity
- GitHub stars
- 21
- Last commit
- Data as of
Tags
- Mysql
Overview
MySQL table discovery, record access, and SQL analysis sit alongside data modification in mcp-mysql-server. The connect_db tool accepts database credentials, while list_tables identifies available tables and describe_table retrieves their structure. Schema inspection belongs to describe_table rather than query, which handles SELECT statements. For changes to stored data, execute handles INSERT, UPDATE, and DELETE statements. Both query and execute accept optional prepared-statement parameters, allowing values to be supplied separately from the SQL text.
Operational inspection uses show_statement for SHOW requests, including status and variable information. The explain tool exposes SQL execution-plan details for performance analysis, including access type and examined rows. Together, these tools let AI models inspect a database, read or modify records, and examine how a query runs through an MCP interface. Connection configuration can use a MySQL connection string or environment variables. The Node-based project communicates over stdio and documents automatic connection cleanup, query validation, and error reporting for connection problems, invalid SQL, missing parameters, and database errors. It is distributed under the MIT license.
mcp-mysql-server setup notes
- mcp-mysql-server records stdio only; confirm a network transport upstream before planning remote access.