Agent skill
mysql
MySQL database administration and development
Install this agent skill to your Project
npx add-skill https://github.com/pluginagentmarketplace/custom-plugin-sql/tree/main/skills/mysql
SKILL.md
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
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
pluginagentmarketplace/custom-plugin-sql
migrations
Database schema migrations and version control
pluginagentmarketplace/custom-plugin-sql
sql-fundamentals
Master SQL fundamentals including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations. Learn data types, WHERE clauses, ORDER BY, GROUP BY, and basic joins.
pluginagentmarketplace/custom-plugin-sql
redis
Redis data structures and commands including strings, lists, hashes, sets, sorted sets, streams, and transactions for high-performance caching and real-time applications.
pluginagentmarketplace/custom-plugin-sql
data-warehouse
Data warehouse design mastery with star schema, dimensional modeling, fact/dimension tables, slowly changing dimensions, and enterprise best practices. Complete schema examples included.
pluginagentmarketplace/custom-plugin-sql
transactions
Database transactions, ACID properties, and concurrency control
pluginagentmarketplace/custom-plugin-sql
mongodb
MongoDB fundamentals including document model, CRUD operations, querying, indexing, and aggregation framework for NoSQL database applications.
Didn't find tool you were looking for?