mysql-server MCP Server

@xianzong85

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

xianzong85

关于 mysql-server MCP Server

暂无概览

#mysql #mcp #database #typescript

mysql-server MCP Server 配置

暂无标准配置

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

代码仓库

mysql-server MCP Server 工具

Execute SQL queries

概览

What is mysql-server MCP Server?

The mysql-server MCP Server is a TypeScript-based Model Context Protocol server that provides tools for querying MySQL databases. It connects to a MySQL server using environment variables and is intended for use with MCP-compatible hosts like Claude Desktop.

How to use mysql-server MCP Server?

Install dependencies with npm install, then build the server with npm run build. Configure the environment variables MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE in your MCP host configuration (e.g., Claude Desktop’s claude_desktop_config.json). Invoke the query tool with a SQL query string to execute queries and receive results.

Key features of mysql-server MCP Server

Executes SQL queries via the query tool
Accepts any SQL query string as input
Returns query results as output
Connects to MySQL using environment variables
Built with TypeScript for reliability
Supports debugging via the MCP Inspector

Use cases of mysql-server MCP Server

Accessing and querying a MySQL database from an AI assistant
Running read-only SQL queries to retrieve data for context
Executing write queries to modify database records
Integrating MySQL data into MCP‑enabled applications
Developing and testing database interactions with Claude Desktop

常见问题

How do I install and build the server?

Run `npm install` to install dependencies, then `npm run build` to compile the TypeScript project. For development with auto-rebuild, use `npm run watch`.

How do I configure the MySQL connection?

Set the environment variables MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE in your MCP server configuration file (e.g., Claude Desktop’s `claude_desktop_config.json`).

What does the `query` tool do?

The `query` tool takes a SQL query string as a required parameter and returns the results of executing that query against the configured MySQL database.

How can I debug the mysql-server MCP Server?

Use the MCP Inspector by running `npm run inspector`. The Inspector provides a URL with debugging tools for the server, which communicates over stdio.

What runtime environment is required?

The server is a TypeScript project and requires Node.js to install dependencies and run the compiled JavaScript.

数据库分类下的更多 MCP 服务器

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.