MySQL

Created By

pengcunfua month ago

零负担、开箱即用的模型上下文协议（MCP）服务器，用于与 MySQL 交互和自动化操作。无需 Node.js 或 Python 环境。该服务器提供对 MySQL 数据库和表进行 CRUD 操作的工具，以及只读模式以防止意外的写入操作。您还可以通过添加 --with-explain-check 标志让 MCP 服务器在执行查询前使用 EXPLAIN 语句检查查询计划。

# mysql

# database

Overview Content Tools Comments

Overview

what is MySQL?

MySQL is a lightweight, out-of-the-box Model Context Protocol (MCP) server designed for interacting with MySQL databases and automating operations without the need for a Node.js or Python environment.

how to use MySQL?

To use MySQL, run the MCP server with the appropriate command line arguments to connect to your MySQL database. You can perform various operations such as listing databases, creating tables, and executing SQL queries.

key features of MySQL?

CRUD operations on MySQL databases and tables.
Read-only mode to prevent accidental writes.
EXPLAIN statement for query plan checks before execution.

use cases of MySQL?

Automating database management tasks.
Performing batch operations on MySQL databases.
Integrating with applications that require database interactions.

FAQ from MySQL?

Do I need to install Node.js or Python to use MySQL?

No, MySQL is designed to work without requiring Node.js or Python.

Can I perform write operations on the database?

Yes, you can execute write queries, but you can also run it in read-only mode to prevent accidental writes.

How do I connect to my MySQL database?

Use the command line with the specified parameters such as host, user, password, port, and database name.

Server Config

{
  "mcpServers": {
    "mysql": {
      "command": "C:\\Users\\<username>\\Downloads\\go-mcp-mysql.exe",
      "args": [
        "--host",
        "localhost",
        "--user",
        "root",
        "--pass",
        "password",
        "--port",
        "3306",
        "--db",
        "mydb"
      ]
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.

Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

Amap Maps高德地图官方 MCP Server

WindsurfThe new purpose-built IDE to harness magic

Tavily Mcp

CursorThe AI Code Editor

ChatWiseThe second fastest AI chatbot™

TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.

Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code