Plan MySQL/InnoDB schema design, indexing, and transaction handling.
npx skills add https://github.com/PageAI-Pro/ralph-loop --skill mysql-pageai-pro
Please help me install this Agent Skill. Skill: mysql Source: https://github.com/PageAI-Pro/ralph-loop/tree/main/.agent/skills/mysql Command: npx skills add https://github.com/PageAI-Pro/ralph-loop --skill mysql-pageai-pro
Improve MySQL/InnoDB schema design, indexing, and transaction handling to boost performance, reliability, and maintainability across production databases.
Run a quick assessment of your current MySQL schema and apply recommended indexing and isolation-level changes to reduce latency.
High-intent search queries and answers about installing and using this skill.
Optimize MySQL schema design by selecting appropriate primary keys, applying normalization strategies, and implementing targeted indexing to support scalable OLTP workloads. This ensures consistent performance and reliability across production databases handling high transaction volumes.
Tune slow MySQL queries by running EXPLAIN analyses to evaluate execution plans and identify full table scans or missing MySQL indexes. Adjust indexing strategies and rewrite queries based on EXPLAIN output to reduce latency and improve database performance.
Plan safe MySQL migrations by evaluating InnoDB isolation levels and locking strategies to minimize downtime and prevent locked queries. Apply best practices for schema evolution and connection management to maintain reliability during production database updates.
MySQL locked queries often result from improper InnoDB transaction isolation levels or restrictive locking strategies during high-concurrency operations. Diagnose the locked queries by monitoring transaction behavior and adjusting isolation levels to balance consistency and concurrency.
Yes, the MySQL optimization approach supports diagnosing production database performance by monitoring slow queries, evaluating indexing strategies, and analyzing InnoDB locking. It provides structured assessments to reduce latency and ensure safe schema evolution in live environments.
DexploarerAnalyze EXPLAIN plans and recommend indexes for PostgreSQL, MySQL, and MongoDB.
sakamoto-family-smileApply MySQL and MariaDB schema, query, indexing, and transaction patterns.
3balljugglerYuOptimize PostgreSQL query efficiency, schema design, and connection management in Supabase.
rnavarychCompare 12 NewSQL and distributed SQL databases for consistency and sharding.
