mysql

MySQL database administration and development

Safety Notice

This listing is imported from skills.sh public index metadata. Review upstream SKILL.md and repository scripts before running.

Copy this and send it to your AI assistant to learn

Install skill "mysql" with this command: npx skills add pluginagentmarketplace/custom-plugin-sql/pluginagentmarketplace-custom-plugin-sql-mysql

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

Source Transparency

This detail page is rendered from real SKILL.md content. Trust labels are metadata-based hints, not a safety guarantee.

Open in GitHub Open in ClawHub

Related Skills

Related by shared tags or category signals.

Security

security

No summary provided by upstream source.

Repository SourceNeeds Review

-51

pluginagentmarketplace

Automation

redis

No summary provided by upstream source.

Repository SourceNeeds Review

-47

pluginagentmarketplace

Research

data-analysis-sql

No summary provided by upstream source.

Repository SourceNeeds Review

-37

pluginagentmarketplace