MySQL Ops MCP Server

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

Local serverstdio

What is the MySQL Ops MCP Server?

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

What you get

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.

  • 🗄️ 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

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the MySQL Ops MCP Server

{
  "mcpServers": {
    "mysql-ops": {
      "command": "npx",
      "args": ["-y", "npm"],
      "env": {
        "DB_HOST": "your-value",
        "DB_PORT": "your-value",
        "DB_USER": "your-value",
        "DB_PASSWORD": "your-value",
        "DB_DATABASE": "your-value"
      }
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Configuration

VariableDescriptionRequired
DB_HOSTEndpoint or connection string the server talks to.Optional
DB_PORTConfiguration value read at startup.Optional
DB_USERConfiguration value read at startup.Optional
DB_PASSWORDConfiguration value read at startup.Optional
DB_DATABASEConfiguration value read at startup.Optional

Frequently asked questions

MySQL MCP server: browse schema, query, CRUD. Delete/drop gated by user approval. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.