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.

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.

Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题； Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"

CursorThe AI Code Editor

DeepChatYour AI Partner on Desktop

EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

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

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

Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

ChatWiseThe second fastest AI chatbot™