MCP MySQL Server

What it does

This MCP server connects AI agents to MySQL databases, allowing them to interact with relational data using natural language. It enables an AI to analyze database schemas, execute queries, and manage data without manual SQL writing.

Tools

• execute_sql: Run SQL queries (SELECT, INSERT, UPDATE, DELETE) to manipulate or retrieve data.
• get_tables_info: Retrieve comprehensive information about all tables and their field structures.
• get_connection_status: Check the current status of the database connection.

Installation

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "node",
      "args": ["/path/to/mysql-mcp-server/src/index.js"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "3306",
        "DB_USER": "root",
        "DB_PASSWORD": "yourpassword",
        "DB_NAME": "yourdatabase"
      }
    }
  }
}

Supported hosts

• Claude Desktop
• Cursor