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 GitHubOpen in ClawHub

Related Skills

Related by shared tags or category signals.

Coding

MySQL Administration

Manage MySQL databases via mysql CLI or Python mysql-connector, supporting queries, schema changes, backups, performance analysis, and user permissions.

Registry SourceRecently Updated
3781Profile unavailable
Coding

DBCheck 轻量级开源数据库巡检工具

执行 MySQL、PostgreSQL、Oracle、SQL Server、DM8 数据库健康巡检，内置 100+ 条增强风险分析规则 + 本地 Ollama AI 大模型诊断建议，一键生成专业 Word 巡检报告。适用于 DBA 和运维人员快速掌握数据库运行状况、排查风险。项目地址：https://github...

Registry SourceRecently Updated
2750Profile unavailable
Coding

game-design-theory

No summary provided by upstream source.

Repository SourceNeeds Review
1.1K-pluginagentmarketplace
Coding

pandas data analysis

No summary provided by upstream source.

Repository SourceNeeds Review
640-pluginagentmarketplace