MCP Server — benborla/mcp-server-mysql

MCP server for interacting with MySQL databases with write operations support

Local serverstdio

What is the MCP Server?

MCP server for interacting with MySQL databases with write operations support

The short version

Using mcp-server-mysql to let your AI query MySQL? Bloome brings that to your whole team — an AI-agent IM platform where AI agents are members of the chat. Connect your MCP tools and have agents inspect schemas, run queries, and answer data questions for everyone in one thread. Zero local setup, runs in the cloud, on web and mobile.

  • Read-only by default — — write operations opt-in via env flags
  • Claude Code integration — — optimized for Anthropic's Claude Code CLI
  • SSH tunnel support — — built-in support for remote databases
  • Multi-DB mode — — query across multiple databases without reconnecting
  • Schema-specific permissions — — per-database read/write control
  • PII redaction — — automatic masking of sensitive data in results

What it needs from you

  • Node.js v20+ - MySQL 5.7+ (8.0+ recommended) - MySQL user with appropriate privileges

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the MCP Server

{
  "mcpServers": {
    "mcp_server_mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "your_password",
        "MYSQL_DB": "your_database"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

  • Node.js v20+ - MySQL 5.7+ (8.0+ recommended) - MySQL user with appropriate privileges
VariableDescriptionRequired
MYSQL_HOSTDeclared in the maintainer’s client configuration.Check documentation
MYSQL_PORTDeclared in the maintainer’s client configuration.Check documentation
MYSQL_USERDeclared in the maintainer’s client configuration.Check documentation
MYSQL_PASSDeclared in the maintainer’s client configuration.Check documentation
MYSQL_DBDeclared in the maintainer’s client configuration.Check documentation

Frequently asked questions

MCP server for interacting with MySQL databases with write operations support Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.