MySQL Ops MCP
English | 简体中文
Power your agent
คำสั่งของผู้เผยแพร่เอง ไม่ใช่เอนด์พอยต์ของ PlugMCP
Host a copy with our keys and logs.
npx -y [email protected]Claude Code ไม่มีลิงก์ติดตั้งสำหรับคำสั่งแบบโลคัล ให้คัดลอกคำสั่งด้านล่างแล้วรันในเทอร์มินัล
DB_HOST=<value> DB_PORT=<value> DB_USER=<value> DB_PASSWORD=<secret> DB_DATABASE=<value> claude mcp add io.github.gt-dinuo-mysql-ops-mcp -- npx -y mysql-ops-mcp@1.0.0รันในเทอร์มินัล
{ "mcpServers": { "io.github.gt-dinuo-mysql-ops-mcp": { "command": "npx", "args": [ "-y", "[email protected]" ], "env": { "DB_HOST": "<value>", "DB_PORT": "<value>", "DB_USER": "<value>", "DB_PASSWORD": "<secret>", "DB_DATABASE": "<value>" } } }}claude_desktop_config.json
URL แบบรีโมตหรือคำสั่งบนเครื่องของคุณ? การติดตั้งสองแบบต่างกันอย่างไร
รันบน PlugMCP
A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.
เปิดจากผู้เผยแพร่
English | 简体中文
MySQL MCP server: browse schema, query, CRUD. Delete/drop gated by user approval.
A MySQL database MCP Server. Let AI tools like Claude Code / Cursor / Codex talk to your MySQL databases in natural language — browse databases and tables, inspect schemas, run queries, and perform CRUD operations, with destructive operations (DELETE / DROP) gated behind explicit user approval.
SELECT queries against any databasedelete_data and drop_table always require explicit user confirmation in the clientnpx, configured entirely through environment variablesRequires Node.js 18+. No clone or build needed — npx fetches and runs the published npm package on first use (see the config below).
To build from source instead (e.g. for development):
git clone https://github.com/GT-dinuo/mysql-ops-mcp.git
cd mysql-ops-mcp
npm install
npm run build
Build output goes to dist/; the entry point is dist/index.js.
In each project where you want to use this tool, create (or append to) .mcp.json:
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": ["-y", "mysql-ops-mcp"],
"env": {
"DB_HOST": "localhost",
"DB_PORT": "3306",
"DB_USER": "root",
"DB_PASSWORD": "your_password",
"DB_DATABASE": "your_database"
}
}
}
}
If you built from source, point the command at the local build instead: "command": "node", "args": ["/absolute/path/to/mysql-ops-mcp/dist/index.js"].
Once configured, just ask in natural language in your AI tool:
List all databases
Show the structure of the users table
Query the 10 most recent orders
Get full info for the users table — indexes and DDL included
Insert a test record into the users table
Delete the test record you just inserted ← the client will ask for your approval first
Destructive operations (delete_data, drop_table) are always confirmed by the MCP client before execution — nothing irreversible happens silently.
delete_data and drop_table are gated by the MCP client's tool-call confirmation — approve or reject each one.query rejects anything but SELECT).root in production — create a MySQL user scoped to the databases the AI may touch..env / .mcp.json with real passwords must stay out of version control (.gitignore already covers .env).After configuring .env (copy from env.example), you can verify connectivity before wiring up the client:
cp env.example .env # fill in real credentials
npm run test-connection
npm run dev # watch mode, recompiles on change
npm run build # build to dist/
npm start # run the built Server
MIT © 2026 mysql-ops-mcp
MySQL MCP server: browse schema, query, CRUD. Delete/drop gated by user approval.
{ "mcpServers": { "io.github.gt-dinuo-mysql-ops-mcp": { "command": "npx", "args": [ "-y", "[email protected]" ], "env": { "DB_HOST": "<value>", "DB_PORT": "<value>", "DB_USER": "<value>", "DB_PASSWORD": "<secret>", "DB_DATABASE": "<value>" } } }}เครื่องมือ
ยังไม่มีรายการเครื่องมือ เซิร์ฟเวอร์แบบรีโมตจะได้รายการหลังการตรวจสอบสถานะครั้งแรก
FAQ
คัดลอกคอนฟิก stdio สำหรับ Cursor, Claude Desktop, Claude Code หรือ VS Code ได้ในหน้านี้ คอนฟิกนี้ใช้การติดตั้งของผู้เผยแพร่ ไม่ใช่พร็อกซีของ PlugMCP
ผู้เผยแพร่ระบุตัวแปรสภาพแวดล้อมเหล่านี้: DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, DB_DATABASE
MySQL Ops MCP ทำงานแบบโลคัลผ่าน stdio
ตรวจสอบล่าสุดเมื่อ 2026-11-09 MySQL MCP server: browse schema, query, CRUD. Delete/drop gated by user approval.