Mysql Database Server G7v

🚀 mcp-server-mysql

A Model Context Protocol (MCP) server for MySQL databases. This server allows Large Language Models (LLMs) to inspect database schemas and execute read-only queries.

🚀 Quick Start

This is a Model Context Protocol (MCP) server for MySQL databases, enabling Large Language Models (LLMs) to inspect database schemas and perform read-only queries.

✨ Features

• Read-only access to MySQL databases.
• Database schema inspection functionality.
• Secure query execution within READ ONLY transactions.
• Docker support.
• Available as an NPM package.

📦 Installation

Using Docker

# Build the Docker image
make docker

# Run with Docker
docker run -i --rm mcp/mysql mysql://host:port/dbname

Installation via Smithery

To automatically install the MySQL database server for Claude Desktop, use Smithery:

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

💻 Usage Examples

Usage with Claude Desktop

Add the following configuration to claude_desktop_config.json:

{
  "mcpServers": {
    "mysql": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/mysql",
        "mysql://host:port/dbname"
      ]
    }
  }
}

⚠️ Important Note

When using Docker on macOS, if the MySQL server is running on the host network, use host.docker.internal.

Connection URL Format

mysql://[user][:password]@host[:port]/database

Replace /database with your database name.

🔧 Technical Details

# Initial setup
make setup

# Build the project
make build

# Format the code
make format

# Run checks
make lint

📄 License

This project is released under the MIT License.

🔒 Security

This server enforces read-only access to protect your database. All queries are executed within READ ONLY transactions.

💡 Usage Tip

For enhanced security, we recommend creating a read-only user.

🤝 Contribution

Contributions are welcome! Feel free to submit a Pull Request.