Dev Tools & GitMCP Registrynpm11 toolsB · 77

MySQL Ops MCP

Name: MySQL Ops MCP
Author: GT-dinuo

io.github.GT-dinuo · Updated 3mo ago

MySQL MCP server: browse schema, query, CRUD. Delete/drop gated by user approval.

At a glance

MySQL Ops MCP is an MCP server in the Dev Tools & Git category. It runs locally over stdio via `npx -y mysql-ops-mcp`, and needs DB_PASSWORD. It exposes 11 tools, including list_databases, list_tables and describe_table. It scores B (77/100) on the MCP Skills Hub health score as of Oct 28, 2026.

Source 0

One-click install

VS Code VS Code Insiders Cursor

Opens your editor and pre-fills the config. Your editor will ask before adding it.

How to install MySQL Ops MCP in your AI client

Setup for Claude Code, Claude Desktop, Cursor, Codex, Windsurf, Cline and VS Code — copy-paste ready.

How to install MySQL Ops MCP in Claude CodeAnthropic's agentic CLI

Add the server

bash

claude mcp add mysql-ops-mcp -e 'DB_PASSWORD=<DB_PASSWORD>' -- npx -y mysql-ops-mcp

Fill in your credentials
Replace <DB_PASSWORD> with your real value. Keep secrets out of any config file you commit.
3
Verify it's connected
bash
```
claude mcp list
```
Sharing it with your team?
Add `--scope project` to write it to .mcp.json in the repository root, which you can commit (with the secrets left as environment variables).
Use it in a session
Ask Claude to use the tools this server exposes (e.g. list_databases, list_tables, describe_table). It discovers them automatically.

How to install MySQL Ops MCP in Claude DesktopDesktop app (MCP config)

Open your MCP config
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json · Windows: %APPDATA%\Claude\claude_desktop_config.json

Add this server

json

{
  "mcpServers": {
    "mysql-ops-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-ops-mcp"
      ],
      "env": {
        "DB_PASSWORD": "<DB_PASSWORD>"
      }
    }
  }
}

Fill in your credentials
Replace <DB_PASSWORD> with your real value. Keep secrets out of any config file you commit.
Restart Claude Desktop
The tools appear under the 🔌 menu once the app reloads.

How to install MySQL Ops MCP in CursorAI-first code editor

Create / edit .cursor/mcp.json in your project

json

{
  "mcpServers": {
    "mysql-ops-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-ops-mcp"
      ],
      "env": {
        "DB_PASSWORD": "<DB_PASSWORD>"
      }
    }
  }
}

Fill in your credentials
Replace <DB_PASSWORD> with your real value. Keep secrets out of any config file you commit.
Enable it
Cursor Settings → MCP → toggle the server on. Tools become available to the Composer/Agent.

How to install MySQL Ops MCP in Codex CLIOpenAI coding agent

Add to ~/.codex/config.toml

toml

[mcp_servers.mysql-ops-mcp]
command = "npx"
args = ["-y", "mysql-ops-mcp"]
env = { DB_PASSWORD = "<DB_PASSWORD>" }

Fill in your credentials
Replace <DB_PASSWORD> with your real value. Keep secrets out of any config file you commit.
Run Codex
Codex loads MCP servers from config.toml on startup and exposes their tools to the agent.

How to install MySQL Ops MCP in WindsurfCodeium's agentic IDE

Edit ~/.codeium/windsurf/mcp_config.json

json

{
  "mcpServers": {
    "mysql-ops-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-ops-mcp"
      ],
      "env": {
        "DB_PASSWORD": "<DB_PASSWORD>"
      }
    }
  }
}

Fill in your credentials
Replace <DB_PASSWORD> with your real value. Keep secrets out of any config file you commit.
Reload
Windsurf → Cascade → refresh MCP servers. Cascade can now call the tools.

How to install MySQL Ops MCP in ClineVS Code autonomous agent

Open Cline → MCP Servers → Configure
Adds to cline_mcp_settings.json.

Add the server

json

{
  "mcpServers": {
    "mysql-ops-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-ops-mcp"
      ],
      "env": {
        "DB_PASSWORD": "<DB_PASSWORD>"
      }
    }
  }
}

Fill in your credentials
Replace <DB_PASSWORD> with your real value. Keep secrets out of any config file you commit.

How to install MySQL Ops MCP in VS CodeCopilot / MCP support

Create .vscode/mcp.json

json

{
  "servers": {
    "mysql-ops-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mysql-ops-mcp"
      ],
      "env": {
        "DB_PASSWORD": "<DB_PASSWORD>"
      }
    }
  }
}

Fill in your credentials
Replace <DB_PASSWORD> with your real value. Keep secrets out of any config file you commit.
Start it
VS Code shows a ▶ Start action above the server entry. Agent mode (Copilot Chat) can then use the tools.

What does MySQL Ops MCP need from you?

API key — MySQL password

DB_HOSToptionalEnvironment variable
MySQL host, default localhost
DB_PORToptionalEnvironment variable
MySQL port, default 3306
DB_USERoptionalEnvironment variable
MySQL user, default root
DB_PASSWORDoptionalsecretEnvironment variable
MySQL password
DB_DATABASEoptionalEnvironment variable
Default database; can also be passed per tool call

Pass secrets through your shell environment rather than committing them into a config file.

What tools does MySQL Ops MCP expose? (11)

Taken from the project's README — the server itself was not queried, so check its docs for the exact schemas.

list_databasesList all databases
list_tablesList tables in a database
describe_tableShow table columns and types
get_table_infoFull table details: columns, indexes, DDL, stats
queryRun a SELECT query
create_tableCreate a table (CREATE TABLE only)
insertInsert rows (INSERT only)
updateUpdate rows (UPDATE only)
delete_dataDelete rows — requires user approval
drop_tableDrop a table — requires user approval
execute_sqlRun any custom SQL statement

What the code can do

Read from the published package source — never executed. Parsed 3 of 3 source files.

This server can read and write files and read your environment variables.

How it was published

No provenance attestation — there is nothing linking this published artifact to a specific source commit.
1 npm maintainer — a single point of compromise · last published by dinuo.

Maintainer of this package and think something here is wrong? Tell us and we'll correct it.

Before you install

Signals gathered from the source repo and package registry — not a safety verdict.

What it can reach

Runs code on your machine — Executes as a local process with your user's permissions, including filesystem access.
Downloads at launch — The package is fetched from its registry each run unless you pin a version.

Last commit 3 months ago — Actively maintained.
0 GitHub stars — Very little community usage so far.

Client compatibility

Claude Code: NativeClaude Desktop: NativeCursor: NativeCodex CLI: NativeWindsurf: NativeCline: NativeVS Code: Native

Health score

B · 77

Maintenance, adoption, transparency and packaging — not a safety audit. How this is calculated

Maintenance30%89%
Last commit 105 days ago.
Adoption20%0%
0 stars.
Transparency20%100%
4/4: ✓ public source repo, ✓ declared license, ✓ documentation, ✓ discoverable tool list.
Provenance15%100%
Package and registry entry point at the same repository.
Packaging15%100%
Publishes a pinned version (1.0.0).

Documentation

Full README

MySQL Ops MCP

English | 简体中文

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.

Features

🗄️ Schema browsing: list databases, list tables, describe table structure, full table info (indexes, DDL, stats)
🔍 Queries: run SELECT queries against any database
✏️ CRUD: create tables, insert, update — with SQL-statement validation per tool
🔐 Approval-gated destructive ops: delete_data and drop_table always require explicit user confirmation in the client
🔌 Zero install: runs via npx, configured entirely through environment variables

Installation

Requires 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):

bash

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.

Configuration

In each project where you want to use this tool, create (or append to) .mcp.json:

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"].

Alternatives to MySQL Ops MCP

Maintain MySQL Ops MCP? Add a badge to your README

Shows its health grade, and links readers to install steps for every client.

markdown

[![MySQL Ops MCP on MCP Skills Hub](https://mcp-skills-hub.vercel.app/badge/io-github-gt-dinuo-mysql-ops-mcp)](https://mcp-skills-hub.vercel.app/mcps/io-github-gt-dinuo-mysql-ops-mcp)

Catalog data refreshed Oct 28, 2026. Something wrong? Report it.