how to use this in n8n

[dave-wind]

My Step

1. install

npm install -g @benborla29/mcp-server-mysql

2. install n8n-nodes-mcp

3. config mcp

command: npx
arguments: -y @benborla29/mcp-server-mysql
env: MYSQL_HOST=127.0.0.1 MYSQL_PORT=3306 MYSQL_USER=root MYSQL_PASS=root MYSQL_DB=demostore ALLOW_INSERT_OPERATION=true ALLOW_UPDATE_OPERATION=true ALLOW_DELETE_OPERATION=false

4.error

It feels like the environment variables are not written at all， please help me，I've been troubled by this for 5 days.

[benborla]

I'm haven't tried using this on N8n, but this might be helpful, if you can navigate and check if you have node and npx installed, then this configuration should work:

    "mysql": {
      "command": "node",
      "args": [
        "/Users/atlasborla/Projects/node/mcp-server-mysql/dist/index.js"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "root",
        "MYSQL_DB": "",
        "ALLOW_DDL_OPERATION": "true",
        "SCHEMA_DDL_PERMISSIONS": "development:true,test:true,production:true",
        "ALLOW_INSERT_OPERATION": "true",
        "ALLOW_UPDATE_OPERATION": "true",
        "ALLOW_DELETE_OPERATION": "true",
           "PATH": "/Users/atlasborla/Library/Application Support/Herd/config/nvm/versions/node/v22.9.0/bin:/usr/bin:/bin",
           "NODE_PATH": "/Users/atlasborla/Library/Application Support/Herd/config/nvm/versions/node/v22.9.0/lib/node_modules"
      }
    } 

That is just my sample configuration, replace it with your configuration.