Enemyrr MCP Mysql Server

🚀 @enemyrr/mcp-mysql-server

A Model Context Protocol server that provides MySQL database operations. This server enables AI models to interact with MySQL databases through a standardized interface.

🚀 Quick Start

📦 Installation and Setup in Cursor IDE

Install via Smithery

To automatically install the MySQL database server for Claude Desktop via Smithery:

npx -y @smithery/cli install @enemyrr/mcp-mysql-server --client claude

Manual Installation

1. Clone and build the project:

git clone https://github.com/enemyrr/mcp-mysql-server.git
cd mcp-mysql-server
npm install
npm run build

2. Add the server in Cursor IDE settings:
   • Open the command palette (Cmd/Ctrl + Shift + P).
   • Search for “MCP: Add Server”.
   • Fill in the fields:
     • Name: mysql
     • Type: command
     • Command: node /absolute/path/to/mcp-mysql-server/build/index.js

⚠️ Important Note

Replace /absolute/path/to/ with the actual path where you cloned and built the project.

🛠️ Database Configuration

You can configure the database connection in three ways:

1. Using Database URL in .env (Recommended):

DATABASE_URL=mysql://user:password@host:3306/database

2. Using individual parameters in .env:

DB_HOST=localhost
DB_USER=your_user
DB_PASSWORD=your_password
DB_DATABASE=your_database

3. Connect directly through the tool:

use_mcp_tool({
  server_name: "mysql",
  tool_name: "connect_db",
  arguments: {
    url: "mysql://user:password@host:3306/database"
    // or
    workspace: "/path/to/your/project" // Will use the project's .env
    // or
    host: "localhost",
    user: "your_user",
    password: "your_password",
    database: "your_database"
  }
});

💻 Usage Examples

Basic Usage

Here are some available tools and their usage examples:

1. connect_db

Connect to a MySQL database using a URL, workspace path, or direct credentials.

2. query

Execute a SELECT query with optional prepared statement parameters.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "query",
  arguments: {
    sql: "SELECT * FROM users WHERE id = ?",
    params: [1]
  }
});

3. execute

Execute an INSERT, UPDATE, or DELETE query with optional prepared statement parameters.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "execute",
  arguments: {
    sql: "INSERT INTO users (name, email) VALUES (?, ?)",
    params: ["Alice", "alice@example.com"]
  }
});

4. browse_table

Browse the contents of a database table.

use_mcp_tool({
  server_name: "mysql",
  tool_name: "browse_table",
  arguments: {
    table: "users"
  }
});

✨ Features

• Supports configuration via URL or individual environment variables.
• Uses prepared statements to prevent SQL injection.
• Supports transaction management.
• Provides detailed error handling and logging.

🔒 Security

• Uses prepared statements to prevent SQL injection.
• Handles passwords securely through environment variables.
• Validates queries before execution.
• Automatically closes connections.

❌ Error Handling

The server provides detailed error messages for the following situations:

• Connection failure
• Invalid queries or parameters
• Missing configuration
• Database errors
• Schema validation errors

🤝 Contribution

Contributions are welcome! Please feel free to submit a Pull Request to https://github.com/enemyrr/mcp-mysql-server

📄 License

MIT