MCP MySQL Server

Example Use Cases

• 1

  Connect to a remote MySQL database over an SSH tunnel from development tools like Cursor IDE.

• 2

  Run read-only or restricted SQL queries locally while enforcing operation permissions via configuration.

• 3

  A simple npm-startable MCP server to expose MySQL access to editor integrations or local automation workflows.

Description

This project creates an MCP-compatible server that opens an SSH tunnel to a remote host and forwards a MySQL connection for local clients (e.g., Cursor IDE). Configuration is done via an environment file (mcp-config.env) including SSH and MySQL settings and operation permissions (SELECT/INSERT/UPDATE/DELETE). It provides an npm script to start the tunnel and MCP server, making it easy to securely query remote databases from local tools. The server is useful when a secure SSH tunnel is required for remote MySQL access and when you want to limit allowed SQL operations.