MySQL MCP Server

by affannahmed

2.7k downloads Not rated yet MIT license

GitHub Website

About

![Tests](https://github.com/designcomputer/mysql_mcp_server/actions/workflows/test.yml/badge.svg) [![smithery badge](https://smithery.ai/badge/mysql-mcp-server)](https://smithery.ai/server/mysql-mcp-server) # MySQL MCP Server A Model Context Protocol (MCP) implementation that enables secure interaction with MySQL…

Details

License: MIT license

Explore

- List available MySQL tables as resources
- Read table contents
- Execute SQL queries with proper error handling
- Secure database access through environment variables
- Comprehensive logging

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name MySQL MCP Server

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

From the repository

Set the following environment variables:

MYSQL_HOST=localhost     # Database host

MYSQL_PORT=3306         # Optional: Database port (defaults to 3306 if not specified)

MYSQL_USER=your_username

MYSQL_PASSWORD=your_password

MYSQL_DATABASE=your_database

pip install mysql-mcp-server

To install MySQL MCP Server for Claude Desktop automatically via Smithery:

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

pip install -r requirements.txt

python -m venv venv
source venv/bin/activate # or venv\Scripts\activate on Windows

pip install -r requirements-dev.txt

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "mysql mcp server": {
            "MCP-Server-with-Claude-Ai": {
                "command": "npx",
                "args": [
                    "-y",
                    "@smithery/cli",
                    "install",
                    "mysql-mcp-server",
                    "--client",
                    "claude"
                ]
            }
        }
    }
}

McpServers

{
    "MCP-Server-with-Claude-Ai": {
        "command": "npx",
        "args": [
            "-y",
            "@smithery/cli",
            "install",
            "mysql-mcp-server",
            "--client",
            "claude"
        ]
    }
}

A Model Context Protocol (MCP) implementation that enables secure interaction with MySQL databases. This server component facilitates communication between AI applications (hosts/clients) and MySQL databases, making database exploration and analysis safer and more structured through a controlled interface.

> Note: MySQL MCP Server is not designed to be used as a standalone server, but rather as a communication protocol implementation between AI applications and MySQL databases.

Features

- List available MySQL tables as resources - Read table contents - Execute SQL queries with proper error handling - Secure database access through environment variables - Comprehensive logging

Installation

Manual Installation

pip install mysql-mcp-server

Installing via Smithery

To install MySQL MCP Server for Claude Desktop automatically via Smithery:

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

Configuration

Set the following environment variables:

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

Usage

With Claude Desktop

Add this 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"
      }
    }
  }
}

Debugging with MCP Inspector

While MySQL MCP Server isn't intended to be run standalone or directly from the command line with Python, you can use the MCP Inspector to debug it.

The MCP Inspector provides a convenient way to test and debug your MCP implementation:

```bash

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Explore

Setting up with Highlight

From the repository

Claude Desktop / Cursor

McpServers

Features

Installation

Manual Installation

Installing via Smithery

Configuration

Usage

With Claude Desktop

Debugging with MCP Inspector

More like this

Context 7

1Panel

🔎 GPT Researcher

Serena