mysql-mcp-server

mysql-mcp-server

0
databases

The MySQL MCP Server is designed for interacting with MySQL databases within the Cursor IDE environment. It allows for executing SQL queries and inspecting database schemas with configurable permissions.

MySQL MCP Server

A Model Context Protocol (MCP) server for interacting with MySQL databases in Cursor IDE.

Features

  • Execute SQL queries (read-only by default).
  • Inspect database schemas.
  • Configurable write permissions.

Installation

npm install

Configuration

Create .env with:
MYSQL_HOST=localhost
MYSQL_PORT=3306
MYSQL_USER=your_username
MYSQL_PASS=your_password
MYSQL_DB=your_database
ALLOW_INSERT_OPERATION=false
ALLOW_UPDATE_OPERATION=false
ALLOW_DELETE_OPERATION=false

Usage in Cursor

Add to .cursor/mcp.json
{
  "mcpServers": {
    "mysqlMcpServer": {
      "command": "npx",
      "args": ["ts-node", "path/to/src/index.ts"],
      "env": {
        "MYSQL_HOST": "<host>",
        "MYSQL_PORT": "<port>",
        "MYSQL_USER": "<user>",
        "MYSQL_PASS": "<pass>",
        "MYSQL_DB": "db",
        "ALLOW_INSERT_OPERATION": "false",
        "ALLOW_UPDATE_OPERATION": "false",
        "ALLOW_DELETE_OPERATION": "false"
      }
    }
  }
}

License

MIT