mysql

This MCP server implements a MySQL data access layer for Cursor AI using the MCP protocol. It exposes endpoints that allow the AI to execute SQL queries, retrieve table schemas, and inspect or manipulate data via standardized MCP requests. You can access the MCP manifest at /manifest.json and interact with the API through endpoints such as /api/mysql/query for SQL execution and /api/mysql/schema for table structures. To integrate with Cursor, add the service URL http://<your-host>:3100/manifest.json in the MCP extension manager, activate the service, and begin issuing natural-language commands like querying a table, inspecting a schema, or running data operations. The server handles CORS and responds with a consistent API shape suitable for MCP tooling.

Prerequisites:

• Node.js 14.x or newer
• Git (optional for cloning)
• Access to a MySQL database

Install locally:

1. Clone the repository

git clone https://github.com/lichuanrong7/mysql-mcp-server.git
cd mysql-mcp-server

2. Install dependencies

npm install

3. Configure environment variables Create a .env file with database and server settings, for example:

# 服务器配置
PORT=3100

# 数据库配置
DB_HOST=your-database-host
DB_PORT=3306
DB_USER=your-db-username
DB_PASSWORD=your-db-password
DB_NAME=your-db-name

4. Run the server

# 开发模式
npm run dev

# 生产模式
npm start

可选：若使用 Docker，构建镜像并通过 Compose 启动：

docker build -t mysql-mcp-server .
docker-compose up -d

Tips and caveats:

• Ensure your MySQL user has appropriate privileges for the queries you plan to run.
• The server exposes /manifest.json and /openapi.yaml for MCP tooling; keep these accessible to Cursor.
• If the service cannot start due to port conflicts, verify that PORT 3100 (or configured port) is free.
• For production deployments, consider securing DB credentials (e.g., using a secrets manager) and enabling TLS as needed.
• Common issues: invalid DB credentials, network/firewall blocks to the database, or missing environment variables. Check logs under the project logs (e.g., logs/mysql-mcp-*.log) for details.