Verified:GitHub

MySQLOps

Automate MySQL diagnostics, performance tuning, and replication health checks.

Updated Aug 23, 2026

Search Tags:#performance #database #backup #sql #diagnostics #replication #mysql

One-click install

npx skills add https://github.com/cavanli/aiops --skill mysqlops

Or copy as Structured Prompt for Agent▼

Please help me install this Agent Skill.
Skill: MySQLOps
Source: https://github.com/cavanli/aiops/tree/main/skills/mysql-ops
Command: npx skills add https://github.com/cavanli/aiops --skill mysqlops

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

MySQL environments frequently struggle with performance bottlenecks, replication health issues, and recovery planning. This skill provides automated diagnostic workflows and best-practice procedures to identify and resolve these problems quickly.

Core Features & Use Cases

Performance tuning: Analyze slow queries, adjust configurations, and optimize indexes to improve throughput.
Replication health checks: Inspect master/slave status, lag, and failover readiness to maintain data consistency.
Backup validation & recovery: Validate backups and guide restoration steps in disaster scenarios.
MCP integration: Expose tools for Model Context Protocol to empower AI-assisted operations.

Quick Start

Run a quick diagnostic against your MySQL instance to surface common performance and replication issues.

Frequently Asked Questions about MySQLOps

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I diagnose MySQL performance bottlenecks and slow queries?▼

To diagnose MySQL performance bottlenecks, analyze slow queries, adjust database configurations, and optimize indexes to improve overall throughput.

What's the best way to check MySQL replication health and failover readiness?▼

Checking MySQL replication health involves inspecting master/slave status, monitoring replication lag, and verifying failover readiness to maintain data consistency.

Does this MySQL diagnostics skill work across Linux, macOS, and Windows?▼

Yes, this MySQL diagnostics skill operates across Linux, macOS, and Windows environments, automating operational diagnostics and structured outputs for diverse systems.

Can I integrate MySQL operational diagnostics into automation pipelines?▼

Yes, you can integrate MySQL operational diagnostics into automation pipelines using MCP tool integration and structured outputs designed for dashboards.