mysql
MySQL database administration and development
By pluginagentmarketplace · 506 installs
npx skills add pluginagentmarketplace/custom-plugin-sql --skill mysql
Source repository · Upstream listing
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