Menu

Not in the top 1,000 by GitHub stars

AIops-tools/MySQL-AIops

Governed AI-ops for MySQL/MariaDB DBA operations: slow-query RCA, InnoDB lock-wait & deadlock analys

Claude CodeDataOperations

History

Review weekly changes to SKILL.md before updating. Dates mark the weeks in which we observed each version; checks apply to the recorded commits.

View weekly changes

skills/mysql-aiops/SKILL.md

Week of Oct 26, 2026 · Line counts unavailable

Before Not checked yet → After Network or broad shell

First observation → 07f0977a970d

No earlier version was observed for comparison.

Compare on GitHub

View on GitHubAdd to my skills

Verified commit 07f0977a970d6886864250367747818e9d7239a2

git clone --filter=blob:none --no-checkout https://github.com/AIops-tools/MySQL-AIops.git .hotskills/aiops-tools-mysql-aiops && git -C .hotskills/aiops-tools-mysql-aiops checkout --detach 07f0977a970d6886864250367747818e9d7239a2 # Copy each selected skill directory from .hotskills/aiops-tools-mysql-aiops into .claude/skills/<skill-name>/
0GitHub stars
0stars in 7 days
1skill in this repository
8commits in 30 days

Heat

1.5
  • Star growth, last 7 daysNot available
  • Star growth, last 24 hoursNot available
  • Rank movement, last 7 daysNot available
  • Commits, last 30 daysNot available
  • Accounts asking about it through MCP, last 7 daysNot available
  • Hot votes this weekNot available

Heat never changes the order by stars, and sponsorship never touches it. How heat works

Stars over time

Oct 25, 2026Oct 25, 20260

30-day change not yet available: not enough history.

Individual skills in this repository

How it works

mysql-aiops

When your agent uses it

Use this skill whenever the user needs to operate or troubleshoot a MySQL 8.x or MariaDB 10.6+ server as a DBA — a one-shot server health overview (version + flavor, connection headroom, replica role); server reads (global variables, status counters, databases, storage engines); activity (sessions/processlist, long-running queries, open InnoDB transactions, lock waits); query stats (performance_schema statement-digest top-N, EXPLAIN FORMAT=JSON); index health (unused indexes, redundant/duplicate indexes, cardinality); table health (sizes, data_free fragmentation, engine/row-format status); replication (replica IO/SQL thread state and lag, binlog/GTID status); four flagship analyses — slow-query RCA (worst digest + EXPLAIN → cited cause/action incl. full-scan and lock-time-dominant classification), InnoDB lock-wait & deadlock chain RCA (wait-for tree, root blocker, last deadlock parsed from SHOW ENGINE INNODB STATUS), replication lag RCA (thread state/error fields → cause+action), and table fragmentation analysis (data_free → OPTIMIZE candidates); and guarded writes (kill a session or query, OPTIMIZE/ANALYZE TABLE, create/drop an index, SET GLOBAL a variable, reset digest stats). Always use this skill for "mysql health check", "why is this query slow", "top queries by time", "EXPLAIN this", "table fragmentation", "which indexes are unused", "redundant index", "who is blocking whom", "deadlock", "kill the session holding the lock", "replication lag", "replica stopped", "seconds behind master/source", "OPTIMIZE this table", "create/drop an index", or "SET GLOBAL max_connections" when the context is a MySQL or MariaDB database. Do NOT use for PostgreSQL — use postgres-aiops. Do NOT use when the target is OT / industrial equipment (use industrial-aiops), a hypervisor, a storage appliance, a backup product, or a container/cluster orchestrator (negative routing hints only). Common MySQL/MariaDB DBA operations with a built-in governance harness (audit, policy, token budget, undo, risk-tiers). Behaviour is validated by a mock-based test suite; see docs/VERIFICATION.md for the live-verification checklist.

What it loads into context

Frontmatter

1,336 tokens

Always available to the agent

SKILL.md

4,633 tokens

When the skill is activated

Reference documents

5,438 tokens

Loaded on request

Token counts are estimates. Scripts run separately; they are not counted as reference context.

The playbook

  1. What This Skill Does
  2. Quick Install
  3. When to Use This Skill
  4. Related Skills — Skill Routing
  5. Common Workflows
  6. Governance & Safety
  7. References

Files

  • ../../.claude-plugin/plugin.jsonasset611 bytes
  • SKILL.mdcore19,210 bytes
  • SKILL.mdcore19,210 bytes
  • SKILL.mdcore19,210 bytes
  • SKILL.mdcore19,210 bytes
  • references/agent-guardrails.mddoc7,492 bytes
  • references/capabilities.mddoc6,158 bytes
  • references/cli-reference.mddoc3,976 bytes
  • references/setup-guide.mddoc4,324 bytes
Read SKILL.md

# MySQL AIops

> **Audit availability:** Real writes require a durable audit intent. Reads and previews can continue if audit storage fails; check the warning and audit health before relying on their audit trail.

> **Disclaimer**: Community-maintained open-source project, **not affiliated with, endorsed by, or sponsored by Oracle Corporation or the MariaDB Foundation.** "MySQL" and "MariaDB" trademarks belong to their owners. Source at [github.com/AIops-tools/MySQL-AIops](https://github.com/AIops-tools/MySQL-AIops) under the MIT license.

Governed MySQL / MariaDB DBA operations — **35 MCP tools**, every one wrapped with the bundled `@governed_tool` harness: a local unified audit log under `~/.mysql-aiops/`, token/runaway budget guard, undo-token recording, and descriptive risk-tier labels. The account password is stored **encrypted** (`~/.mysql-aiops/secrets.enc`, Fernet + scrypt) — never plaintext on disk.

> **Standalone**: the governance harness is bundled in the package (`mysql_aiops.governance`) — mysql-aiops has no external skill-family dependency. Behaviour is covered by a mock-based test suite; `docs/VERIFICATION.md` is the checklist for a live run against a real MySQL / MariaDB server.

## What This Skill Does

| Domain | Tools | Count | Read or Write |
|--------|-------|:-----:|:-------------:|
View the complete source on GitHub

Skills included

  • mysql-aiops

Repository facts

License
MIT
Created
Jul 17, 2026
Last pushed
Oct 30, 2026
Forks
0
Open issues
0
Project activity
Active

Before you install

Network or broad shell

Automated signals, not a guarantee

Checked Nov 6, 2026

Not fully analyzed: some files were too long, unreadable or missing. This never lowers the level.

Show 3 notes
  • skills/mysql-aiops/SKILL.md:1 Analysis incomplete: Referenced executable target unavailable; not analyzed
  • skills/mysql-aiops/SKILL.md:1 Analysis incomplete: Referenced executable target unavailable; not analyzed
  • skills/mysql-aiops/SKILL.md:1 Analysis incomplete: Referenced executable target unavailable; not analyzed
Show all 21 signals by file

.claude-plugin/plugin.json

  • Network accessline 1
    {   "$schema": "https://anthropic.com/claude-code/plugin.schema.json",
  • Network accessline 2
    "$schema": "https://anthropic.com/claude-code/plugin.schema.json",
  • Network accessline 8
    "name": "Wei Zhou",     "email": "zhouwei008@gmail.com",     "url": "https://github.com/AIops-tools"
  • Network accessline 9
    "email": "zhouwei008@gmail.com",     "url": "https://github.com/AIops-tools"   },
  • Network accessline 10
    "url": "https://github.com/AIops-tools"
  • Network accessline 11
    },   "homepage": "https://github.com/AIops-tools/MySQL-AIops",   "repository": "https://github.com/AIops-tools/MySQL-AIops",
  • Network accessline 12
    "homepage": "https://github.com/AIops-tools/MySQL-AIops",
  • Network accessline 13
    "repository": "https://github.com/AIops-tools/MySQL-AIops",

skills/mysql-aiops/SKILL.md

  • Broad permissionsline 1
    Bash
  • Network accessline 5
    summary: "Governed MySQL/MariaDB DBA ops: slow-query, lock-wait, replication & fragmentation RCA; 35 tools." license: MIT homepage: https://github.com/AIops-tools/MySQL-AIops
  • Network accessline 6
    license: MIT homepage: https://github.com/AIops-tools/MySQL-AIops tags: [aiops, mcp, governance, mysql]
  • Network accessline 7
    homepage: https://github.com/AIops-tools/MySQL-AIops
  • Network accessline 18
    allowed-tools:   - Bash metadata: {"openclaw":{"requires":{"anyBins":["mysql-aiops","uvx"]},"optional":{"env":["MYSQL_AIOPS_CONFIG","MYSQL_AIOPS_MASTER_PASSWORD"]},"homepage":"https://github.com/AIops-tools/MySQL-AIops","emoji":"🐬","os":["m
  • Network accessline 19
    - Bash metadata: {"openclaw":{"requires":{"anyBins":["mysql-aiops","uvx"]},"optional":{"env":["MYSQL_AIOPS_CONFIG","MYSQL_AIOPS_MASTER_PASSWORD"]},"homepage":"https://github.com/AIops-tools/MySQL-AIops","emoji":"🐬","os":["macos","linux"]}}
  • Network accessline 20
    metadata: {"openclaw":{"requires":{"anyBins":["mysql-aiops","uvx"]},"optional":{"env":["MYSQL_AIOPS_CONFIG","MYSQL_AIOPS_MASTER_PASSWORD"]},"homepage":"https://github.com/AIops-tools/MySQL-AIops","emoji":"🐬","os":["macos","linux"]}}
  • Network accessline 37
    > **Disclaimer**: Community-maintained open-source project, **not affiliated with, endorsed by, or sponsored by Oracle Corporation or the MariaDB Foundation.** "MySQL" and "MariaDB" trademarks belong to their owners. Source at [github.com/A

skills/mysql-aiops/references/agent-guardrails.md

  • Network accessline 116
    Feedback on running this with a specific local model is genuinely useful — open an issue at [github.com/AIops-tools/MySQL-AIops](https://github.com/AIops-tools/MySQL-AIops/issues)
  • Network accessline 117
    open an issue at [github.com/AIops-tools/MySQL-AIops](https://github.com/AIops-tools/MySQL-AIops/issues) with the model, runtime, and what went wrong.
  • Network accessline 118
    [github.com/AIops-tools/MySQL-AIops](https://github.com/AIops-tools/MySQL-AIops/issues)

skills/mysql-aiops/references/cli-reference.md

  • Dangerous shell operationline 21
    mysql-aiops secret rm <target>
  • Access to secretsline 22
    [Credential-related source omitted]

How the signals fit together

Facts from a static read of the files at the pinned commit. They describe what the code does, not why.

Some files could not be read; the facts below still hold.

Signal confidence: 13 facts

Works with

Agent compatibility, from the files in this repository
AgentStatusEvidenceInstall to
Claude CodeNativeManifest .claude-plugin/plugin.json.claude/skills/<skill-name>/
CodexCompatibleStandard SKILL.md skills/mysql-aiops/SKILL.md.agents/skills/<skill-name>/
CursorCompatibleStandard SKILL.md skills/mysql-aiops/SKILL.md.cursor/skills/<skill-name>/
Gemini CLICompatibleStandard SKILL.md skills/mysql-aiops/SKILL.md.gemini/skills/<skill-name>/
GitHub CopilotCompatibleStandard SKILL.md skills/mysql-aiops/SKILL.md.github/skills/<skill-name>/
OpenCodeCompatibleStandard SKILL.md skills/mysql-aiops/SKILL.md.opencode/skills/<skill-name>/
  • Native The repository ships a manifest, folder or frontmatter field for this agent.
  • Compatible A standard SKILL.md that this agent can read.
  • Unknown No evidence either way.

Derived automatically from paths, manifests and frontmatter. Not tested on each agent.

You might also use

AIops-tools/Postgres-AIops

Governed AI-ops for PostgreSQL — slow-query/bloat/lock RCA, indexes, vacuum, replication, with audit/budget/undo/risk-tiers (preview)

0GitHub stars

AIops-tools/Proxmox-AIops

Standalone governed Proxmox VE ops — 23 MCP tools with built-in audit/budget/undo/risk-tier harness

4GitHub stars

AIops-tools/Container-Host-AIops

Governed AI-ops for Docker + Portainer container hosts — restart-loop/resource/bloat RCA, guarded writes, with audit/budget/undo (preview)

1GitHub stars

AIops-tools/TrueNAS-AIops

1GitHub stars

AIops-tools/Ceph-AIops

Governed Ceph mgr Dashboard ops: HEALTH_WARN RCA, OSD/PG/pool/RBD/CephFS/RGW, 35 MCP tools (preview)

0GitHub stars

AIops-tools/K8s-AIops

Standalone governed Kubernetes ops — 15 MCP tools with built-in audit/budget/undo/risk-tier harness

0GitHub stars