MySQL MCP Server

Name: MySQL MCP Server
Author: wuwen1030

@wuwen1030

About MySQL MCP Server

A MySQL implementation of the Model Context Protocol (MCP) server. This server allows AI models to interact with MySQL databases through a standardized interface.

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": [
        "/ABSOLUTE/PATH/TO/PARENT/FOLDER/mysql-mcp-server/dist/index.js"
      ],
      "env": {
        "MYSQL_HOST": "",
        "MYSQL_PORT": "",
        "MYSQL_USER": "",
        "MYSQL_PASSWORD": "",
        "MYSQL_DATABASE": ""
      }
    }
  }
}

Tools

No tools detected

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?

A MySQL implementation of the Model Context Protocol (MCP) server that allows AI models to interact with MySQL databases through a standardized read-only interface.

How to use MySQL MCP Server?

Install with npm install and build with npm run build, then configure the server in your Claude Desktop app's claude_desktop_config.json by providing the absolute path to the built index.js and setting environment variables for MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE.

Key features of MySQL MCP Server

List available database tables
Get table schemas
Execute read-only SQL queries
Safe transaction handling with automatic rollback

Use cases of MySQL MCP Server

Explore a MySQL database schema through an AI assistant
Run read-only queries to retrieve data without risk of modification
Enable AI models to answer questions backed by live database content

FAQ from MySQL MCP Server

What dependencies or runtime does MySQL MCP Server require?

Node.js is required. After cloning, run npm install and npm run build to compile the server.

How is authentication handled?

Authentication is configured via environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) passed to the server process.

Are write operations supported?

No. The server intentionally only supports read-only SQL queries and uses safe transaction handling with automatic rollback.

Where does the data live?

Data remains in the user's own MySQL database. The server does not store or persist any data externally.

What transport does the server use?

The server communicates over stdio, as configured in the Claude Desktop app's claude_desktop_config.json using the command and args fields.

Comments

More Databases MCP servers

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K