Advertise SubmitSign In

MySQL MCP Server

@gopikapeenikkal

Basic information

Category

Databases

License

MIT license

Transports

stdio

Author

gopikapeenikkal

About MySQL MCP Server

Custom MCP Server for MySQL

MySQL MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mysql-mcp-server-gopikapeenikkal": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "mcp_mysql_connect"
      ]
    }
  }
}

MySQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

1

What are the prerequisites for MySQL MCP Server?

Python 3.11 or above and a running MySQL database.

2

How do I install MySQL MCP Server?

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

3

What environment variables are required?

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

4

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.

5

What SQL operations does MySQL MCP Server support?

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

Comments

More Databases MCP servers

Redis

modelcontextprotocol

Model Context Protocol Servers

mcp-server-qdrant: A Qdrant MCP server

An official Qdrant Model Context Protocol (MCP) server implementation

Redis MCP Server

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

MotherDuck's DuckDB MCP Server

Local MCP server for DuckDB and MotherDuck

Sail MCP Server for Spark SQL

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.