MySQL MCP Server

@shengshengshengbuxi

Repository

Basic information

About MySQL MCP Server

No overview available yet

#mysql #mcp #server

MySQL MCP Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

MySQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

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

Frequently asked questions

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.