Audit MySQL schemas, indexes, queries, and replication settings for performance bottlenecks.
npx skills add https://github.com/tomrford/dotfiles --skill mysql-tomrford
Please help me install this Agent Skill. Skill: mysql Source: https://github.com/tomrford/dotfiles/tree/main/.agents/skills/mysql Command: npx skills add https://github.com/tomrford/dotfiles --skill mysql-tomrford
Plan and review MySQL/InnoDB schema, indexing, query tuning, transactions, and operations. Use when creating or modifying MySQL tables, indexes, or queries; diagnosing slow/locking behavior; planning migrations; or troubleshooting replication and connection issues. Load when using a MySQL database.
Audit a MySQL instance for schema design, indexing, and query performance and implement a safe optimization plan.
High-intent search queries and answers about installing and using this skill.
Identify MySQL performance bottlenecks by auditing schemas, indexes, queries, and replication settings. This process detects design issues and slow or locking behavior to provide structured optimization recommendations across development, staging, and production environments.
Plan safe-rollback MySQL schema migrations by evaluating performance and applying minimal changes with validation. This approach provides step-by-step guidance for creating tables, modifying indexes, and ensuring production-safe rollouts during transitions.
Optimize MySQL indexing and queries by following workflow-oriented guidance for schema design and tuning. This evaluates performance systematically to apply minimal changes and validate results for improved InnoDB transactional behavior.
Yes, you can troubleshoot MySQL replication and connection issues across development and production environments. It diagnoses slow or locking behavior and provides structured recommendations supported by best-practice references.
MySQL slow locking behavior during transactions often stems from schema design and indexing issues. Auditing InnoDB transactional behavior, indexing strategy, and query tuning identifies these bottlenecks and provides structured optimization recommendations.
tankpkgOptimize PostgreSQL and MySQL query performance with indexing and tuning strategies.
BagelHoleManage MySQL-compatible databases on PlanetScale with branching workflows.
zinohomeMonitor database performance with slow query detection and resource alerts.
samChang72Analyze and optimize SQL database queries with EXPLAIN ANALYZE and indexing strategies.
