Mysql MCP Server A92

🚀 MySQL MCP Server

A MySQL server based on the Model Context Protocol (MCP) that allows executing SQL queries via the MCP protocol.

🚀 Quick Start

This MySQL MCP Server enables users to execute SQL queries through the MCP protocol. Below are the detailed steps to get started.

✨ Features

• Execute SQL queries via the MCP protocol.
• Check the database connection status.
• Provide built - in SQL query example hints.

📦 Installation

# Clone the repository
git clone https://github.com/shengshengshengbuxi/mysql_mcp_server.git
cd mysql_mcp_server

# Install dependencies
npm install

# Compile TypeScript code
npm run build

📚 Documentation

Configuration

The server is configured using the following environment variables:

Running the Server

# Set MySQL connection parameters
$env:MYSQL_HOST = "localhost"
$env:MYSQL_PORT = "3306"
$env:MYSQL_USER = "root"
$env:MYSQL_PASSWORD = "your_password"
$env:MYSQL_DATABASE = "your_database"

# Start the server
npm start

Integration with Claude

To use this server in Claude Desktop, edit the Claude Desktop configuration file:

Windows:

%USERPROFILE%\AppData\Roaming\Claude\claude_desktop_config.json

Add the following configuration:

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": [
        "/path/to/mysql_mcp_server/dist/server.js",
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "your password",
        "MYSQL_DATABASE": "your database"
      }
    }
  }
}

💻 Usage Examples

Tools

• execute_sql: Execute SQL queries.
• check_connection: Check the database connection status.

Hints

• sql_example: Provide SQL query examples.

📄 License

This project is licensed under the MIT license.