MCP mysql

Overview

MCP mysql is a Model Context Protocol server for Cursor. It connects directly to MySQL/MariaDB.

Not a phpMyAdmin integration. phpMyAdmin does not expose an MCP API. This plugin talks to the database server itself — the same kind of backend phpMyAdmin can use — not to the phpMyAdmin web UI.

The repo ships as a local Cursor plugin (.cursor-plugin/plugin.json + mcp.json) and includes an agent skill at skills/mysql-best-practices/SKILL.md.

Related MCP server: Mysql-mcp

Features

Security

Starts in read-only by default.

Prefer a least-privilege MySQL user. Never commit real passwords to shared configs.

Requirements

• Node.js 20+

• MySQL or MariaDB reachable from this machine

• Database credentials

Quick start

Full guides: docs/INSTALL.md · docs/es/INSTALL.md

npm install
npm run build

Install as a local Cursor plugin (example path on Windows):

C:\Users\<YOUR_USER>\.cursor\plugins\local\mcp-mysql-server

Then enable MCP mysql in Cursor and set MYSQL_* + MCP_WRITE_MODE.

The plugin mcp.json uses ./dist/index.js (relative) to avoid Windows path bugs such as C:\c:\Users\....

Development

# watch / run from source
npm run dev

# production build
npm run build
npm start

MCP tools

Read

Write / schema

MCP resources

Limitations

• No free-form arbitrary SQL execution

• Identifiers limited to alphanumeric characters and _

• Filters support: =, !=, >, >=, <, <=, LIKE, IN

Support, privacy & security

Support is provided by the publisher via GitHub Issues (use the bug / feature templates). Cursor / Anysphere do not provide support for this third-party plugin.

Contributing

See docs/CONTRIBUTING.md for the issue process, development setup, and PR guidelines.

Documentation

All guides live under docs/ (English) and docs/es/ (Spanish).