MySQL MCP Server

Name: MySQL MCP Server
Author: shengshengshengbuxi

@shengshengshengbuxi

代码仓库

关于 MySQL MCP Server

暂无概览

#mysql #mcp #server

基本信息

分类

数据库

运行时

node

传输方式

stdio

发布者

shengshengshengbuxi

配置

暂无标准配置

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

代码仓库

工具

未检测到工具

工具是从 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

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.