MCP Server for MySQL - Claude Code Edition

> 🚀 This is a modified version optimized for Claude Code with SSH tunnel support
> Original Author: @benborla29
> Original Repository: https://github.com/benborla/mcp-server-mysql
> License: MIT

MCP Server for MySQL based on NodeJS


Key Features of This Fork

✅ Claude Code Integration - Optimized for use with Anthropic's Claude Code CLI

✅ SSH Tunnel Support - Built-in support for SSH tunnels to remote databases

✅ Auto-start/stop Hooks - Automatic tunnel management with Claude start/stop

✅ DDL Operations - Added MYSQL_DISABLE_READ_ONLY_TRANSACTIONS for CREATE TABLE support

✅ Multi-Project Setup - Easy configuration for multiple projects with different databases

Quick Start for Claude Code Users

Read the Setup Guide: See PROJECT_SETUP_GUIDE.md for detailed instructions

Configure SSH Tunnels: Set up automatic SSH tunnels for remote databases

Use with Claude: Integrated MCP server works seamlessly with Claude Code

A Model Context Protocol server that provides access to MySQL databases through SSH tunnels. This server enables Claude and other LLMs to inspect database schemas and execute SQL queries securely.

Table of Contents

Requirements

Installation

- Smithery
- Clone to Local Repository
- Remote mode

Components

Configuration

Environment Variables

Multi-DB Mode

Schema-Specific Permissions

Testing

Troubleshooting

Contributing

License

Requirements

Node.js v20 or higher

MySQL 5.7 or higher (MySQL 8.0+ recommended)

MySQL user with appropriate permissions for the operations you need

For write operations: MySQL user with INSERT, UPDATE, and/or DELETE privileges

Installation

Using Smithery

There are several ways to install and configure the MCP server but the most common would be checking this website https://smithery.ai/server/@benborla29/mcp-server-mysql

Cursor

For Cursor IDE, you can install this MCP server with the following command in your project:

Visit https://smithery.ai/server/@benborla29/mcp-server-mysql

Follow the instruction for Cursor

MCP Get provides a centralized registry of MCP servers and simplifies the installation process.

Codex CLI

Codex CLI installation is similar to Claude Cod

... [truncated — view full README on GitHub]