Agent skill
mysql
MySQL database administration and development
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/mysql-4a7d4a08
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.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?