mcp-server-mysql

Name: mcp-server-mysql
Availability: InStock
Author: Ben Borla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

GitHub

GitHub Stars

768

User Rating

Not Rated

Favorites

Views

201

Forks

110

Issues

Installation

Difficulty

Intermediate

Estimated Time

10-20 minutes

Installation

Prerequisites

Please specify required software and versions:

Node.js: 18.0.0 or higher

MySQL: 5.7 or higher (8.0 recommended)

MySQL User: User with appropriate permissions

Installation Steps

1. Global Installation

bash
npm install -g @benborla29/mcp-server-mysql

2. Add to Claude Code

bash
claude mcp add mcp_server_mysql \
  -e MYSQL_HOST="127.0.0.1" \
  -e MYSQL_PORT="3306" \
  -e MYSQL_USER="root" \
  -e MYSQL_PASS="your_password" \
  -e MYSQL_DB="your_database" \
  -e ALLOW_INSERT_OPERATION="false" \
  -e ALLOW_UPDATE_OPERATION="false" \
  -e ALLOW_DELETE_OPERATION="false" \
  -- npx @benborla29/mcp-server-mysql