mcp server
MySQL MCP Server (benborla)
Community Node server for MySQL that is read-only by default, with opt-in insert, update and delete flags.
Set up
Runs on your computer. Pick your agent and operating system.
Before you start
- Node.js 20 or newer
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@benborla29/mcp-server-mysql"
],
"env": {
"MYSQL_HOST": "<your MYSQL_HOST>",
"MYSQL_USER": "<your MYSQL_USER>",
"MYSQL_PASS": "<your MYSQL_PASS>"
}
}
}
}same format Cursor, GitHub Copilot CLI, Junie, JetBrains AI Assistant, Augment (Auggie CLI), Factory Droid, Kiro, Devin CLI +12
Values in angle brackets are placeholders. Restart Claude Desktop after editing its config.Claude Desktop docs
Tools provided
As listed by the project. Your agent asks before calling them, depending on its settings.
mysql_queryRun SQL; read-only unless write flags are onmysql://tablesResource listing tables and columns
README
synced Oct 13, 2026MySQL MCP Server (benborla)
Community Node server for MySQL that is read-only by default, with opt-in insert, update and delete flags.
Install
npx -y @benborla29/mcp-server-mysql
Configuration
| Variable | Required | Description |
|---|---|---|
MYSQL_HOST | Yes | MySQL host, e.g. 127.0.0.1 |
MYSQL_PORT | No | MySQL port, e.g. 3306 |
MYSQL_USER | Yes | Database user |
MYSQL_PASS | Yes | Database password |
MYSQL_DB | No | Default database |
ALLOW_INSERT_OPERATION | No | Set true to allow inserts (off by default) |
Tools
mysql_query— Run SQL; read-only unless write flags are onmysql://tables— Resource listing tables and columns
About this listing
Details were gathered from the project's public pages on 2026-10-13 and have not been reviewed by a person yet. Read the project's own documentation before giving it access to anything sensitive.
Sources: