mcp-server-mysql

A Model Context Protocol server that provides access to MySQL databases. This server enables LLMs to inspect database schemas and execute SQL queries.

• Requirements
• Installation
• Smithery
• Clone to Local Repository
• Remote mode
• Components
• Configuration
• Environment Variables
• Multi-DB Mode
• Schema-Specific Permissions
• Testing
• Troubleshooting
• Contributing
• License

• Node.js v20 or higher
• MySQL 5.7 or higher (MySQL 8.0+ recommended)
• MySQL user with appropriate permissions for the operations you need
• For write operations: MySQL user with INSERT, UPDATE, and/or DELETE privileges

There are several ways to install and configure the MCP server but the most common would be checking this website https://smithery.ai/server/@praise25/mcp-server-mysql

For Cursor IDE, you can install this MCP server with the following command in your project:

1. Visit https://smithery.ai/server/@praise25/mcp-server-mysql
2. Follow the instruction for Cursor

MCP Get provides a centralized registry of MCP servers and simplifies the installation process.

If you already have this MCP server configured in Claude Desktop, you can import it automatically:

claude mcp add-from-claude-desktop

This will show an interactive dialog where you can select your mcp_server_mysql server to import with all existing configuration.

Using NPM/PNPM Global Installation:

First, install the package globally:

# Using npm
npm install -g @prais