MCP Server Mysql

🚀 MySQL MCP Server

A secure server for MySQL database interaction based on the Model Context Protocol (MCP). This server allows AI assistants to list tables, read data, and execute SQL queries, enabling secure exploration and analysis of the database through a controlled interface.

🚀 Quick Start

The MySQL MCP Server is a secure solution for interacting with MySQL databases, enabling AI assistants to perform various database operations through a controlled interface.

✨ Features

• List available MySQL tables as resources.
• Read table contents.
• Execute SQL queries with error handling.
• Secure database access via environment variables.
• Comprehensive logging.

📦 Installation

pip install mysql-mcp-server

📚 Documentation

Configuration

Set the following environment variables:

MYSQL_HOST=localhost     # Database host
MYSQL_PORT=3306         # Optional: Database port (default is 3306 if not specified)
MYSQL_USER=your_username
MYSQL_PASSWORD=your_password
MYSQL_DATABASE=your_database

Usage

Usage with Claude Desktop

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "mysql": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/mysql_mcp_server",
        "run",
        "mysql_mcp_server"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

Running as an Independent Server

• Set your database parameters.
• Run the main application.

🔧 Technical Details

Security Considerations

• Never commit environment variables or credentials.
• Use a MySQL user with restricted permissions.
• Consider implementing a query whitelist in a production environment.
• Monitor and log all database operations.

Best Security Practices

This MCP server requires database access to run. To ensure security:

1. Create a dedicated MySQL user with minimal permissions.
2. Avoid using root credentials or administrative accounts.
3. Restrict database access to only necessary operations.
4. Enable logging for auditing.
5. Conduct regular security reviews of database access.

See the MySQL Security Configuration Guide for detailed instructions:

• Create a restricted MySQL user.
• Set appropriate permissions.
• Monitor database access.
• Follow best security practices.

⚠️ Important Note

Always follow the principle of least privilege when configuring database access.

📄 License

This project is under the MIT License - see the LICENSE file for details.

💻 Contribution Guide

1. Fork the repository.
2. Create a feature branch (git checkout -b feature/amazing-feature).
3. Commit your changes (git commit -m 'Add some amazing feature').
4. Push to the branch (git push origin feature/amazing-feature).
5. Open a Pull Request.