# mysql-aiops

> mysql-aiops — aiops-tools-mysql-aiops. Use this tool when you need to optimize and troubleshoot MySQL and MariaDB database performance, solving problems like slow queries, lock waits, and replication issues. It provides detailed root cause analysis (RCA) and audit logging, with features like budget guards and dry-run simulations to prevent errors. Ideal for database administrators (DBAs) seeking to streamline operations and ensure data integrity.

Canonical page: https://skillsregistry.net/skills/aiops-tools-mysql-aiops  
JSON: https://api.skillsregistry.net/v1/skills/aiops-tools-mysql-aiops

## Description

Governed MySQL + MariaDB DBA operations — slow-query, lock-wait/deadlock, replication, and fragmentation RCA, with unbypassable audit logging (MCP + CLI), budget/runaway guards, dry-run, and undo/rollback.

## Trust

- **Trust score (0–1):** 0.67
- **Verification tier:** scanned
- **Last scanned:** 2026-08-29

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-08-29

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/a0195acd37)
- **Repository:** <https://github.com/AIops-tools/MySQL-AIops>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "aiops-tools-mysql-aiops"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/aiops-tools-mysql-aiops` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/aiops-tools-mysql-aiops/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt