mysql

MySQL database administration, optimization, and development for production environments. Covers core administration tasks including installation, user management, backup with mysqldump, binary log management, and configuration tuning Query development support for SELECT, JOINs, subqueries, stored procedures, triggers, and events Performance optimization through EXPLAIN analysis, index tuning, slow query log review, and Performance Schema inspection High availability setup including MySQL replication, group replication, MySQL Router, ProxySQL, and failover strategies Requires SQL fundamentals, Linux basics, and networking knowledge

INSTALLATION
npx skills add https://github.com/pluginagentmarketplace/custom-plugin-sql --skill mysql
Run in your project or agent environment. Adjust flags if your CLI version differs.

SKILL.md

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
BrowserAct

Let your agent run on any real-world website

Bypass CAPTCHA & anti-bot for free. Start local, scale to cloud.

Explore BrowserAct Skills →

Stop writing automation&scrapers

Install the CLI. Run your first Skill in 30 seconds. Scale when you're ready.

Start free
free · no credit card