Back to MCP Servers
🧩

MCP server for one MySQL database: schema, read-only queries and guarded writes.

To add MySQL MCP to Claude, run the install command below or copy the ready-made config for Claude Code, Claude Desktop, Cursor and VS Code further down. Restart your client after adding it and its tools show up in your next conversation. It needs 12 environment variables, listed below.

DatabaseDevToolsData

Install

npx -y mcp-mysql-client@1.1.0

Environment variables

MYSQL_HOSTSet in your MCP config
MYSQL_PORTSet in your MCP config
MYSQL_USERSet in your MCP config
MYSQL_PASSSet in your MCP config
MYSQL_DBSet in your MCP config
MYSQL_SSLSet in your MCP config
MYSQL_SSL_CASet in your MCP config
ALLOW_INSERT_OPERATIONSet in your MCP config
ALLOW_UPDATE_OPERATIONSet in your MCP config
ALLOW_DELETE_OPERATIONSet in your MCP config
MYSQL_MAX_ROWSSet in your MCP config
MYSQL_TIMEOUT_MSSet in your MCP config

Install with your client

Terminal
claude mcp add mysql --env MYSQL_HOST=<YOUR_MYSQL_HOST> --env MYSQL_PORT=<YOUR_MYSQL_PORT> --env MYSQL_USER=<YOUR_MYSQL_USER> --env MYSQL_PASS=<YOUR_MYSQL_PASS> --env MYSQL_DB=<YOUR_MYSQL_DB> --env MYSQL_SSL=<YOUR_MYSQL_SSL> --env MYSQL_SSL_CA=<YOUR_MYSQL_SSL_CA> --env ALLOW_INSERT_OPERATION=<YOUR_ALLOW_INSERT_OPERATION> --env ALLOW_UPDATE_OPERATION=<YOUR_ALLOW_UPDATE_OPERATION> --env ALLOW_DELETE_OPERATION=<YOUR_ALLOW_DELETE_OPERATION> --env MYSQL_MAX_ROWS=<YOUR_MYSQL_MAX_ROWS> --env MYSQL_TIMEOUT_MS=<YOUR_MYSQL_TIMEOUT_MS> -- npx -y mcp-mysql-client@1.1.0

Run this in a terminal to add the server to Claude Code.

What this does

MySQL MCP exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation.

Requirements

This server needs the following environment variables to be set before it can run:

MYSQL_HOST
MYSQL_PORT
MYSQL_USER
MYSQL_PASS
MYSQL_DB
MYSQL_SSL
MYSQL_SSL_CA
ALLOW_INSERT_OPERATION
ALLOW_UPDATE_OPERATION
ALLOW_DELETE_OPERATION
MYSQL_MAX_ROWS
MYSQL_TIMEOUT_MS

Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).

Frequently asked questions

How do I install MySQL MCP?

Run the Claude Code command in the install section to add MySQL MCP to Claude Code, or copy the ready-made config for your client from the install section on this page. Restart your client afterwards and the tools appear in your next conversation.

Which clients work with MySQL MCP?

This page carries setup and config for Claude Code, Claude Desktop, Cursor and VS Code. Any other MCP client that accepts a standard server config can connect to MySQL MCP as well.

Does MySQL MCP need an API key?

Yes. Before it can run, set these environment variables: MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB, MYSQL_SSL, MYSQL_SSL_CA, ALLOW_INSERT_OPERATION, ALLOW_UPDATE_OPERATION, ALLOW_DELETE_OPERATION, MYSQL_MAX_ROWS, MYSQL_TIMEOUT_MS. They go in the env block of your MCP config.

Imported from the Official MCP Registry. The details above come from the registry entry; the maker can claim this listing to correct them, add docs, and see its traffic.

Is this your MCP server?

Claim this listing to see its traffic, fix details yourself, and skip the review queue on future updates.

Listed on clauderules.net

Add this badge to your README

Show visitors this server is listed in the ClaudeRules directory. The badge links straight to this listing.

Markdown
[![Listed on clauderules.net](https://clauderules.net/api/badge/io-github-gistrec-mcp-mysql-client)](https://clauderules.net/mcp/io-github-gistrec-mcp-mysql-client)
HTML
<a href="https://clauderules.net/mcp/io-github-gistrec-mcp-mysql-client" target="_blank" rel="noopener noreferrer"><img src="https://clauderules.net/api/badge/io-github-gistrec-mcp-mysql-client" alt="Listed on clauderules.net" /></a>