Overview
What is MySQL MCP Server?
MySQL MCP Server is a server based on the Model Context Protocol (MCP) that allows executing SQL queries on a MySQL database via the MCP protocol. It is designed for developers who want to integrate MySQL database operations into MCP‑compatible applications such as Claude Desktop.
How to use MySQL MCP Server?
Install dependencies with npm install, compile TypeScript with npm run build, set MySQL connection environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE), and run npm start. Alternatively, configure it as an MCP server in Claude Desktop by editing the claude_desktop_config.json file with the path to the compiled server.js and the required environment variables.
Key features of MySQL MCP Server
- Execute arbitrary SQL queries via MCP protocol
- Check MySQL database connection status
- Built‑in SQL query example prompt
- Simple environment variable configuration for MySQL
- Easy integration with Claude Desktop
Use cases of MySQL MCP Server
- Query a MySQL database directly from Claude Desktop using natural language
- Automate SQL reporting by calling the server from MCP workflows
- Validate database connectivity before running queries
- Use SQL example prompts to quickly write common queries
FAQ from MySQL MCP Server
What does the MySQL MCP Server do?
It allows you to execute SQL queries on a MySQL database through the Model Context Protocol (MCP), making it usable by MCP clients like Claude Desktop.
How do I configure the MySQL connection?
Set environment variables MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE before starting the server. Defaults are localhost, 3306, root, empty password, and empty database.
What tools are provided?
The server exposes two tools: execute_sql (to run SQL queries) and check_connection (to test database connectivity).
How do I integrate it with Claude Desktop?
Add a configuration entry to the Claude Desktop config file (claude_desktop_config.json) specifying the path to the compiled server.js and the MySQL connection environment variables as shown in the README.
