广告合作
MCP.so
登录

MySQL MCP Server

@gopikapeenikkal

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

gopikapeenikkal

关于 MySQL MCP Server

Custom MCP Server for MySQL

MySQL MCP Server 配置

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

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

MySQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 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

常见问题

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.

评论

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

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K
广告合作