pluginagentmarketplace/custom-plugin-sql6 files

Mysql

MySQL database administration and development

Specification
Skill ID
pluginagentmarketplace/custom-plugin-sql/mysql
Publisher
pluginagentmarketplace
Repository
custom-plugin-sql
Installs
0
Files
6
Synced
Sep 23, 2026
How to use it

Open any RiverX project, open the Skills panel in the chat, and search for this identifier. The files are fetched from the source repository at install time.

pluginagentmarketplace/custom-plugin-sql/mysqlInstalls these files
  • SKILL.md
  • assets/config.yaml
  • assets/schema.json
  • references/GUIDE.md
  • references/PATTERNS.md
  • scripts/validate.py

What this skill tells the agent

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

Use this skill in a project

Open any RiverX project, search the Skills panel for pluginagentmarketplace/custom-plugin-sql/mysql, and install it in one click.

Use this skill