MCP MySQL Server

What is MCP MySQL Server?

MCP MySQL Server is an MCP server that enables MySQL database access through an SSH tunnel. Designed for use with Cursor IDE, it allows MCP‑compatible clients to run SQL queries on remote databases while controlling operation permissions.

How to use MCP MySQL Server?

Clone the repository, copy mcp-config.env.example to mcp-config.env, set the MySQL and SSH variables inside that file, then run npm install and npm run start-mcp. For Cursor IDE, add the server configuration to mcp.json using the stdio transport type.

Key features of MCP MySQL Server

• Connects to MySQL databases through an SSH tunnel.
• Granular control over INSERT, UPDATE, DELETE, and SELECT operations.
• Environment‑based configuration for credentials and connection mapping.
• Ready‑to‑use integration with Cursor IDE.

Use cases of MCP MySQL Server

• Query a remote MySQL database from an MCP‑compatible client securely.
• Manage sensitive data by restricting write operations to only SELECT.
• Access databases behind a firewall using an SSH jump host.

FAQ from MCP MySQL Server

What are the prerequisites?

Node.js 14 or later, SSH access to the remote server, a MySQL client, and Cursor IDE.

Are write operations enabled by default?

No. By default only SELECT is permitted. You must set ALLOW_INSERT_OPERATION, ALLOW_UPDATE_OPERATION, or ALLOW_DELETE_OPERATION to true in mcp-config.env to enable those operations.

Do I need an SSH tunnel for a local database?

No. If your MySQL server runs locally, you can leave the SSH configuration empty and connect directly using the MySQL variables.

How is the server configured?

Edit the mcp-config.env file with your MySQL host, port, user, password, database, and optionally the SSH tunnel mapping. Do not share this file.

What transport protocol does MCP MySQL Server use?

It uses the stdio transport type.