MySQL MCP Server

@shengshengshengbuxi

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

shengshengshengbuxi

关于 MySQL MCP Server

暂无概览

#mysql #mcp #server

MySQL MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MySQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

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.