Mysql

pluginagentmarketplace/custom-plugin-sql

This one takes you from MySQL basics through production administration, covering everything from storage engine selection to setting up replication and failover. You'll work through query optimization with EXPLAIN analysis, learn backup strategies with mysqldump, and get into high availability patterns with Group Replication and ProxySQL. The bonding with a PostgreSQL DBA skill is interesting since you'll often need to know both systems in practice. It's comprehensive enough that you could go from installing MySQL to running it in production, though you'll want some SQL and Linux fundamentals first. The focus on performance tuning and HA makes this more than just a beginner's guide.

skills.sh installs: 506
GitHub stars: 1
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add pluginagentmarketplace/custom-plugin-sql --skill mysql --agent claude-code

Installs into .claude/skills of the current project.

Files

MySQL Skill

Overview

Master MySQL database administration, optimization, and development for production environments.

Topics Covered

MySQL Basics

Installation and configuration
User management
Database creation
Storage engines (InnoDB, MyISAM)
Character sets

Query Development

SELECT statements
JOINs and subqueries
INSERT, UPDATE, DELETE
Stored procedures
Triggers and events

Performance

EXPLAIN analysis
Index optimization
Query cache (8.0+ changes)
Slow query log
Performance Schema

Administration

Backup with mysqldump
Binary log management
Replication setup
User privileges
Configuration tuning

High Availability

MySQL replication
Group replication
MySQL Router
ProxySQL
Failover strategies

Prerequisites

SQL fundamentals
Linux basics
Networking concepts

Learning Outcomes

Administer MySQL servers
Optimize queries
Set up replication
Manage backups

SKILL.md on GitHub

Details

Repository: github.com/pluginagentmarketplace/custom-plugin-sql
Categories: Backend & APIs, Databases
First seen: Jun 3, 2026