Mysql MCP Server Modification

🚀 MySQL MCP Server

This MCP server provides read-only access to MySQL databases.

🚀 Quick Start

The MySQL MCP server enables users to perform various read - only operations on MySQL databases.

✨ Features

• List available databases.
• List tables in a database.
• Describe table structures (including field remarks).
• Execute read - only SQL queries.

📦 Installation

1. Install from NPM

# Install globally
npm install -g @valuprosys/mysql-mcp-server

# Or install locally in your project
npm install @valuprosys/mysql-mcp-server

2. Configure Environment Variables

The server requires the following environment variables:

• MYSQL_HOST: Database server address.
• MYSQL_PORT: Database port (Default: 3306).
• MYSQL_USER: Database username.
• MYSQL_PASSWORD: Database password.
• MYSQL_DATABASE: Default database name (Optional).

3. Add to MCP Configuration

Add the following configuration to your MCP configuration file:

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": ["@valuprosys/mysql-mcp-server"],
      "env": {
        "MYSQL_HOST": "your-mysql-host",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your-mysql-user",
        "MYSQL_PASSWORD": "your-mysql-password",
        "MYSQL_DATABASE": "your-default-database"
      },
      "disabled": false,
      "autoApprove": [
        "list_databases",
        "list_tables",
        "describe_table",
        "execute_query"
      ]
    }
  }
}

📚 Documentation

list_databases

List all accessible databases on the MySQL server. Parameters: None

list_tables

List all tables in the specified database. Parameters:

• database (Optional): Database name (Use the default database if not specified).

describe_table

Show the detailed structure of the specified table. Parameters:

• database (Optional): Database name (Use the default database if not specified).
• table (Required): Table name.

execute_query

Execute a read - only SQL query. Parameters:

• query (Required): SQL query statement (Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed).
• database (Optional): Database name (Use the default database if not specified).