Install Database Mysql in LM Studio

What you need first

• LM Studio, installed.
• Node.js, which gives the npx command the server starts with.
• Your own values for YOUR_MYSQL_HOST,YOUR_MYSQL_USER,YOUR_MYSQL_DATABASE.

Steps

1. In LM Studio, open the Program tab and choose Install › Edit mcp.json.
2. Add this block. If the file already has mcpServers, add only the entry inside it.

{
  "mcpServers": {
    "database-mcp-mysql": {
      "command": "npx",
      "args": ["-y", "@database-mcp/[email protected]"],
      "env": { "MYSQL_HOST": "YOUR_MYSQL_HOST", "MYSQL_USER": "YOUR_MYSQL_USER", "MYSQL_DATABASE": "YOUR_MYSQL_DATABASE" }
    }
  }
}

3. Replace YOUR_MYSQL_HOST,YOUR_MYSQL_USER,YOUR_MYSQL_DATABASE with your own values.
4. Save the file and restart LM Studio.

Check it worked

Ask LM Studio: List the tools of database-mcp-mysql.

If it does not start

spawn npx ENOENT

Node.js is not on the PATH that LM Studio sees. Install it, or write the full path of npx in the config.

The server starts, but its tools fail

A YOUR_… placeholder is still in the config, or its value is wrong.

Nothing changes after a restart

The file is not valid JSON any more. Look for a missing comma where the block was added.