Xianzong85 Mysql Server MCP Server

🚀 MySQL Server MCP Proxy

A TypeScript-based MCP proxy server for accessing MySQL databases. It demonstrates core MCP concepts, including tools for executing SQL queries and connecting to a MySQL database via environment variables.

🚀 Quick Start

This is a TypeScript-based MCP proxy server designed for accessing MySQL databases. It showcases key MCP concepts, such as tools for executing SQL queries and connecting to a MySQL database using environment variables.

✨ Features

Tools

• query - Execute SQL queries
  • Accepts a SQL query as a string parameter
  • Returns the query results

📚 Documentation

Configuration

Set the following environment variables in your MCP proxy server configuration:

• MYSQL_HOST: MySQL server host address
• MYSQL_USER: MySQL username
• MYSQL_PASSWORD: MySQL password
• MYSQL_DATABASE: MySQL database name

Development

Install dependencies:

npm install

Build the server:

npm run build

Development with automatic rebuild:

npm run watch

Installation

To use with Claude Desktop, add the server configuration:

• On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• On Windows: %APPDATA%/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mysql": {
      "command": "/path/to/mysql-server/build/index.js",
      "env": {
        "MYSQL_HOST": "your-mysql-host",
        "MYSQL_USER": "your-mysql-user",
        "MYSQL_PASSWORD": "your-mysql-password",
        "MYSQL_DATABASE": "your-mysql-database"
      }
    }
  }
}

Debugging

Debugging can be challenging since the MCP proxy communicates via standard input and output. We recommend using the MCP Inspector, which is available as a package script:

npm run inspector

The inspector will provide a URL in your browser to access the debugging tools.