Dev Tools & GitMCP RegistrypypiB · 71

MySQL AIops MCP server

Name: MySQL AIops
Author: AIops-tools

io.github.AIops-tools · Updated 14d ago

Governed MySQL/MariaDB DBA ops: slow-query, lock-wait, replication & fragmentation RCA; 35 tools.

At a glance

MySQL AIops is an MCP server in the Dev Tools & Git category. It runs locally over stdio via `uvx mysql-aiops`, and declares no required credentials. It scores B (71/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 AIops in your AI client

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

How to install MySQL AIops in Claude CodeAnthropic's agentic CLI

Add the server

bash

claude mcp add mysql-aiops -- uvx mysql-aiops

2
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. It discovers them automatically.

How to install MySQL AIops 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-aiops": {
      "command": "uvx",
      "args": [
        "mysql-aiops"
      ]
    }
  }
}

Restart Claude Desktop
The tools appear under the 🔌 menu once the app reloads.

How to install MySQL AIops in CursorAI-first code editor

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

json

{
  "mcpServers": {
    "mysql-aiops": {
      "command": "uvx",
      "args": [
        "mysql-aiops"
      ]
    }
  }
}

Enable it
Cursor Settings → MCP → toggle the server on. Tools become available to the Composer/Agent.

How to install MySQL AIops in Codex CLIOpenAI coding agent

Add to ~/.codex/config.toml

toml

[mcp_servers.mysql-aiops]
command = "uvx"
args = ["mysql-aiops"]

Run Codex
Codex loads MCP servers from config.toml on startup and exposes their tools to the agent.

How to install MySQL AIops in WindsurfCodeium's agentic IDE

Edit ~/.codeium/windsurf/mcp_config.json

json

{
  "mcpServers": {
    "mysql-aiops": {
      "command": "uvx",
      "args": [
        "mysql-aiops"
      ]
    }
  }
}

Reload
Windsurf → Cascade → refresh MCP servers. Cascade can now call the tools.

How to install MySQL AIops in ClineVS Code autonomous agent

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

Add the server

json

{
  "mcpServers": {
    "mysql-aiops": {
      "command": "uvx",
      "args": [
        "mysql-aiops"
      ]
    }
  }
}

How to install MySQL AIops in VS CodeCopilot / MCP support

Create .vscode/mcp.json

json

{
  "servers": {
    "mysql-aiops": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mysql-aiops"
      ]
    }
  }
}

Start it
VS Code shows a ▶ Start action above the server entry. Agent mode (Copilot Chat) can then use the tools.

What tools does MySQL AIops expose?

This server runs as a local package. We only query remote servers for their tool list — asking this one would mean executing it, so its tools are listed in the documentation below.

What the code can do

Source analysis currently covers npm packages only. This server ships as a Python package, which needs a different parser.

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 14 days 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 · 71

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

Maintenance30%100%
Last commit 14 days ago.
Adoption20%0%
0 stars.
Transparency20%75%
3/4: ✓ public source repo, ✓ declared license, ✓ documentation, ✗ discoverable tool list.
Provenance15%75%
Links to its own repository; package linkage unverified.
Packaging15%100%
Publishes a pinned version (0.12.0).

Documentation

Full README

MySQL AIops

Disclaimer: Community-maintained open-source project. Not affiliated with, endorsed by, or sponsored by Oracle Corporation or the MariaDB Foundation. "MySQL" is a trademark of Oracle Corporation; "MariaDB" is a trademark of MariaDB plc; all product/trademark names belong to their respective owners. MIT licensed.

Governed AI-ops for MySQL 8.x and MariaDB 10.6+ DBA operations — connecting to a server with PyMySQL and reading information_schema / performance_schema — with a built-in governance harness: unified audit log, token/runaway budget guard, undo-token recording, and descriptive risk-tier labels. The server flavor (mysql vs mariadb) is detected from version() and flavor-dependent statements branch automatically (SHOW REPLICA STATUS vs SHOW SLAVE STATUS).

What it does

Four flagship signature analyses, plus the guarded reads and writes around them:

Slow-query RCA — take the worst events_statements_summary_by_digest

entry (plus an optional EXPLAIN FORMAT=JSON plan) and map its numbers — no-index share (SUM_NO_INDEX_USED), lock-time share, rows-examined/sent ratio, tmp-disk spill, call count, plan access types — to a cited cause and a concrete action. Every finding carries its measured number, not a black-box verdict.

InnoDB lock-wait & deadlock chain RCA — build the wait-for tree from

performance_schema.data_lock_waits (MariaDB: information_schema.innodb_lock_waits), name the root blocker (blocks others, waits on none), and parse the last deadlock out of SHOW ENGINE INNODB STATUS.

Replication lag RCA — map the replica's IO/SQL thread state,

Seconds_Behind_Source and error fields to a cited cause + action (stopped IO thread, failed applier statement, lagging applier, intentional SQL_Delay).

Table fragmentation analysis — rank tables by reclaimable data_free

from information_schema.tables into cited OPTIMIZE TABLE candidates.

What works

Excerpt — the full document is on GitHub.

Alternatives to MySQL AIops

Maintain MySQL AIops? Add a badge to your README

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

markdown

[![MySQL AIops on MCP Skills Hub](https://mcp-skills-hub.vercel.app/badge/io-github-aiops-tools-mysql-aiops)](https://mcp-skills-hub.vercel.app/mcps/io-github-aiops-tools-mysql-aiops)

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