MySQL MCP Server

What it does

Provides a high-performance bridge between AI agents and MySQL databases. It features a unique dual-layer permission system (Permissions + Categories) that ensures AI agents can only perform authorized operations, making it suitable for production environments.

Tools

• run_select_query: Execute read-only SELECT queries for data analysis.
• execute_write_query: Perform DML operations like INSERT and UPDATE.
• read_table_schema: Inspect table structures and columns.
• list_tables: Explore available tables within the database.
• execute_ddl: Manage schema changes including CREATE, ALTER, and DROP table.
• analyze_query: Get optimization hints and explain plans for SQL queries.

Installation

Add this to your AI agent configuration:

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@berthojoris/mcp-mysql-server",
        "mysql://user:pass@localhost:3306/mydb",
        "list,read,utility"
      ]
    }
  }
}

Supported hosts

• Claude Desktop
• Cursor
• Windsurf
• Codex
• Zed