MySQL MCP Server

What is MySQL MCP Server?

A Model Context Protocol (MCP) server for interacting with MySQL databases directly within Cursor IDE. It allows users to execute SQL queries (read‑only by default), inspect database schemas, and optionally enable write operations through configuration.

How to use MySQL MCP Server?

Install dependencies with npm install, then create a .env file with your MySQL connection details and write‑permission flags. Add the server configuration to your project’s .cursor/mcp.json, specifying npx ts-node as the command and the required environment variables. The server can then be invoked from Cursor IDE.

Key features of MySQL MCP Server

• Execute SQL queries (read-only by default).
• Inspect database schemas.
• Configurable write permissions for INSERT, UPDATE, DELETE.

Use cases of MySQL MCP Server

• Query MySQL databases directly from Cursor IDE during development.
• Safely inspect table structures and relationships.
• Enable controlled write operations (e.g., INSERT) when explicitly allowed.
• Run ad‑hoc SELECT queries without leaving the editor.
• Manage database interactions without switching to a separate SQL client.

FAQ from MySQL MCP Server

Is the server read‑only by default?

Yes. Write operations (INSERT, UPDATE, DELETE) are disabled by default. They can be enabled by setting the corresponding environment variables to true.

How do I enable write permissions?

Set ALLOW_INSERT_OPERATION, ALLOW_UPDATE_OPERATION, and ALLOW_DELETE_OPERATION in your .env or MCP configuration to true. Each flag controls its respective operation independently.

What dependencies are required?

You need Node.js, the npm packages listed in package.json (installed via npm install), and ts-node to run the TypeScript entry point.

Where should the server be configured?

The server is configured in .cursor/mcp.json within your Cursor IDE project. The connection details and permission flags are passed as environment variables in the MCP server entry.

Does the server support authentication?

Connection authentication uses the MySQL credentials provided in the environment variables (MYSQL_USER, MYSQL_PASS). No additional authentication layer is described.