mcp -mysql

This MCP server exposes a MySQL database access layer over SSH tunnels with Claude Code integration. It is designed to let Claude Code analyze your database schema, inspect tables, and safely run SQL queries against a configured MySQL instance. By default, write operations are disabled for safety; enable specific write permissions via the environment variables if you trust the model and need to modify data. The server supports per-database access control when MYSQL_DB is set, and includes SSH tunnel support for remote databases. To use it, configure Claude Code to start the MCP server (as shown in the README) and point Claude Code to the hosted MCP server entry, including the required environment variables for your database connection.

Prerequisites:

• Node.js v20 or newer
• npm or pnpm
• Git
• A running MySQL 5.7+ instance (MySQL 8.0+ recommended)

1. Clone the repository:

git clone https://github.com/chenlinyang/mcp-server-mysql.git
cd mcp-server-mysql

2. Install dependencies:

npm install
# or
pnpm install

3. Build the project (if applicable):

npm run build
# or
pnpm run build

4. Run locally to test (optional):

node dist/index.js

5. Configure Claude Code to use the MCP server (example):

• Global or per-project configuration as shown in the README. Example snippet:

{
  "mcpServers": {
    "mcp_server_mysql": {
      "command": "node",
      "args": [
        "/full/path/to/mcp-server-mysql/dist/index.js"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "your_password",
        "MYSQL_DB": "your_database",
        "MULTI_DB_WRITE_MODE": "false",
        "ALLOW_INSERT_OPERATION": "false",
        "ALLOW_UPDATE_OPERATION": "false",
        "ALLOW_DELETE_OPERATION": "false",
        "ALLOW_DDL_OPERATION": "false"
      }
    }
  }
}

Notes and tips:

• For security, keep write operations disabled by default and only enable INSERT/UPDATE/DELETE when you explicitly require them and understand the risks.
• If using a remote database, configure SSH tunneling as described in the repository's setup guide.
• The MYSQL_DB setting enables strict per-database access, preventing cross-database queries.
• Review and adapt the environment variable names to your deployment environment, especially any SSL, pool size, or timeout settings.
• Ensure Claude Code is updated to the same MCP server interface version to avoid compatibility issues.