mysqldb-mcp-server MCP server

by MCP-Mirror

266 downloads

Not rated

GitHub

About

mysqldb-mcp-server is a MySQL database MCP server that provides tools to connect to MySQL databases and execute SQL queries via the Model Context Protocol. It is designed for developers who want to interact with MySQL databases through AI assistants that support MCP.

Details

Author: MCP-Mirror
Downloads: 266
Categories: Other, Database

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 mysqldb-mcp-server 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": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

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": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

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": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

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": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

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": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

From the repository

Install the package using pip or uv, then configure environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, MYSQL_READONLY). Add the server configuration to Claude Desktop’s claude_desktop_config.json. Use the connect_database tool to connect to a specific database and execute_query to run SQL queries.

Claude Desktop / Cursor

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

{
    "mcpServers": {
        "mysqldb-mcp-server mcp server": {
            "burakdirin_mysqldb-mcp-server": {
                "command": "uv",
                "args": [
                    "pip",
                    "install",
                    "mysqldb-mcp-server"
                ]
            }
        }
    }
}

McpServers

{
    "burakdirin_mysqldb-mcp-server": {
        "command": "uv",
        "args": [
            "pip",
            "install",
            "mysqldb-mcp-server"
        ]
    }
}

mysqldb-mcp-server MCP server

A MySQL database MCP server project.

Installation

You can install the package using uv:

uv pip install mysqldb-mcp-server

Or using pip:

pip install mysqldb-mcp-server

Components

Tools

The server provides two tools:
- connect_database: Connects to a specific MySQL database
- database parameter: Name of the database to connect to (string)
- Returns a confirmation message when connection is successful

- execute_query: Executes MySQL queries
- query parameter: SQL query/queries to execute (string)
- Returns query results in JSON format
- Multiple queries can be sent separated by semicolons

Configuration

The server uses the following environment variables:

- MYSQL_HOST: MySQL server address (default: "localhost")
- MYSQL_USER: MySQL username (default: "root")
- MYSQL_PASSWORD: MySQL password (default: "")
- MYSQL_DATABASE: Initial database (optional)
- MYSQL_READONLY: Read-only mode (set to 1/true to enable, default: false)

Quickstart

Installation

Claude Desktop

MacOS: ~/Library/Application\ Support/Claude/claude_desktop_config.json

Windows: %APPDATA%/Claude/claude_desktop_config.json

<details>
<summary>Development/Unpublished Server Configuration</summary>

{
  "mcpServers": {
    "mysqldb-mcp-server": {
      "command": "uv",
      "args": [
        "--directory",
        "/Users/burakdirin/Projects/mysqldb-mcp-server",
        "run",
        "mysqldb-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "password",
        "MYSQL_DATABASE": "[optional]",
        "MYSQL_READONLY": "true"
      }
    }
  }
}

</details>

<details>
<summary>Published Server Configuration</summary>

{
  "mcpServers": {
    "mysqldb-mcp-server": {
      "command": "uvx",
      "args": [
        "mysqldb-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "password",
        "MYSQL_DATABASE": "[optional]",
        "MYSQL_READONLY": "true"
      }
    }
  }
}

</details>

Installing via Smithery

To install MySQL Database Integration Server for Claude Desktop automatically via Smithery:

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

Development

Building and Publishing

To prepare the package for distribution:

1. Sync dependencies and update lockfile:

uv sync

2. Build package distributions:

uv build

This will create source and wheel distributions in the dist/ directory.

3. Publish to PyPI:

uv publish

Note: You'll need to set PyPI credentials via environment variables or command flags:
- Token: --token or UV_PUBLISH_TOKEN
- Or username/password: --username/UV_PUBLISH_USERNAME and --password/UV_PUBLISH_PASSWORD

Debugging

Since MCP servers run over stdio, debugging can be challenging. For the best debugging
experience, we strongly recommend using the MCP Inspector.

You can launch the MCP Inspector via npm with this command:

npx @modelcontextprotocol/inspector uv --directory /Users/burakdirin/Projects/mysqldb-mcp-server run mysqldb-mcp-server

Upon launching, the Inspector will display a URL that you can access in your browser to begin debugging.

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

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

McpServers

mysqldb-mcp-server MCP server

Installation

Components

Tools

Configuration

Quickstart

Installation

Claude Desktop

Installing via Smithery

Development

Building and Publishing

Debugging

Install

More like this

Sequential Thinking

Redis

Filesystem

EverArt

Google Drive

Sqlite