MySQL MCP Server

Name: MySQL MCP Server
Author: gopikapeenikkal

@gopikapeenikkal

代码仓库

关于 MySQL MCP Server

Custom MCP Server for MySQL

基本信息

分类

数据库

许可证

MIT license

运行时

python

传输方式

stdio

发布者

gopikapeenikkal

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.

数据库分类下的更多 MCP 服务器

MCP Server for MySQL based on NodeJS

benborla

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.

1.9K