2
0
# Install this skill:
npx skills add pluginagentmarketplace/custom-plugin-sql --skill "mysql"

Install specific skill from multi-skill repository

# Description

MySQL database administration and development

# SKILL.md


name: mysql
description: MySQL database administration and development
sasmp_version: "1.3.0"
bonded_agent: 02-postgresql-dba
bond_type: PRIMARY_BOND


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

# Supported AI Coding Agents

This skill is compatible with the SKILL.md standard and works with all major AI coding agents:

Learn more about the SKILL.md standard and how to use these skills with your preferred AI coding agent.