MySQL MCP Server

What is MySQL MCP Server?

A Model Context Protocol (MCP) server that connects to a MySQL database and exposes a tool for AI models to execute SQL queries via natural language, without direct database access.

How to use MySQL MCP Server?

Install with pip install mcp_mysql_connect or uv pip install mcp_mysql_connect. Set environment variables DB_HOST, DB_USER, DB_PASSWORD, and DB_NAME. Then configure in Cursor's mcp.json, use the Python client, or run manually with python -m mcp_mysql_connect.

Key features of MySQL MCP Server

• Provides a single read_query tool for executing SELECT queries
• Allows natural language querying through AI models like Claude
• Integrates with Cursor via mcp.json configuration
• Supports manual execution and Python client usage
• Requires Python 3.11+ and a MySQL database

Use cases of MySQL MCP Server

• Ask an AI model to list users registered in the last week
• Retrieve top 5 selling products via plain English
• Count orders per customer without writing SQL manually
• Explore database content through conversational chat interfaces

FAQ from MySQL MCP Server

What are the prerequisites for MySQL MCP Server?

Python 3.11 or above and a running MySQL database.

How do I install MySQL MCP Server?

Install via pip: pip install mcp_mysql_connect, or with UV: uv pip install mcp_mysql_connect.

What environment variables are required?

The server needs DB_HOST, DB_USER, DB_PASSWORD, and DB_NAME.

How can I use MySQL MCP Server with Cursor?

Add a "mysql-mcp-server" entry to ~/.cursor/mcp.json using either uvx or uv commands, including the four database environment variables.

What SQL operations does MySQL MCP Server support?

Currently only read_query for SELECT queries; write operations are not mentioned.