MCP Server With Claude Ai

🚀 MySQL MCP Server

A MySQL database secure interaction system implementing the Model Context Protocol (MCP). This server component enables communication between AI applications (hosts/clients) and MySQL databases, making database exploration and analysis more secure and structured through controlled interfaces.

⚠️ Important Note

The MySQL MCP Server is not designed to run as a standalone server but as a component implementing the communication protocol between AI applications and MySQL databases.

✨ Features

• List available MySQL tables as resources.
• Read table contents.
• Execute SQL queries and handle errors.
• Ensure database access security through environment variables.
• Provide comprehensive logging.

📦 Installation

Manual Installation

pip install mysql-mcp-server

Installation via Smithery

To automatically install the MySQL MCP Server for Claude Desktop, use Smithery:

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

📚 Configuration

Set the following environment variables:

MYSQL_HOST=localhost     # Database host address
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 Examples

Usage with Claude Desktop

Add the following to your claude_desktop_config.json file:

{
  "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"
      }
    }
  }
}

Debugging with the MCP Check Tool

Although the MySQL MCP Server is not designed to be run directly from the command line, you can use the MCP check tool for debugging:

# Install dependencies
pip install -r requirements.txt
# Debug using the MCP check tool (do not run directly with Python)

The MySQL MCP Server is designed to be integrated with AI applications (such as Claude Desktop) and should not be run as a standalone Python program.

🔧 Development

# Clone the repository
git clone https://github.com/yourusername/mysql_mcp_server.git
cd mysql_mcp_server
# Create a virtual environment
python -m venv venv
source venv/bin/activate  # or `venv\Scripts\activate` on Windows
# Install development dependencies
pip install -r requirements-dev.txt
# Run tests
pytest

🛡️ Security Considerations

• Do not commit environment variables or credentials.
• Use a database user with minimal privileges.
• Consider implementing a query whitelist in a production environment.
• Monitor and log all database operations.

🌟 Security Best Practices

This MCP implementation requires database access to run. For security reasons:

1. Create a dedicated MySQL user and grant minimal privileges.
2. Avoid using the root or administrative accounts.
3. Limit database access to only necessary operations.
4. Enable logging for auditing.
5. Conduct regular security reviews to check database access.

Refer to the MySQL Security Configuration Guide for detailed instructions:

• Create a restricted MySQL user.
• Set appropriate privileges.
• Monitor database connections.
• Implement other security measures.