mcp-mysql-server

MySQL MCP Server

MySQL inspection, queries, and data changes are available to AI models through mcp-mysql-server. Its tools serve users working with database tables, records, server settings, and SQL execution plans through MCP clients.

Server facts

mcp-mysql-server

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.

Related MCP servers