mcpField
M
mysql

mysql

github.com/pluginagentmarketplaceData & databases1506 installsUpdated 43w ago
Repository

About mysql

A MySQL learning skill for developers and administrators, covering database operations, query work, performance tuning, and high availability.

Key features

  1. 01Server setup and user management
  2. 02SQL queries, procedures, and triggers
  3. 03EXPLAIN and index optimization
  4. 04Backups, logs, and replication
  5. 05High-availability configuration

Use cases

  1. 01Administering MySQL servers
  2. 02Improving query performance
  3. 03Configuring replication and failover

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/pluginagentmarketplace/custom-plugin-sql --skill mysql

After installing, type/mysqlin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

assets/
config.yaml
schema.json
references/
GUIDE.md
PATTERNS.md
scripts/
validate.py

Details

From the project README

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

Comments

Markdown supported