Analyze MySQL execution plans and rewrite slow queries for better performance.
npx skills add https://github.com/HTRTan/paperclip-skills --skill mysql-optimizer
Please help me install this Agent Skill. Skill: mysql-optimizer Source: https://github.com/HTRTan/paperclip-skills/tree/main/skills/mysql-optimizer Command: npx skills add https://github.com/HTRTan/paperclip-skills --skill mysql-optimizer
Analyzes and optimizes MySQL queries to improve performance by diagnosing slow queries, interpreting execution plans, and proposing index design and query rewrites.
Provide a slow-running SQL query and its EXPLAIN plan to receive actionable optimization steps.
High-intent search queries and answers about installing and using this skill.
To optimize slow MySQL queries, analyze EXPLAIN execution plans to identify bottlenecks like full table scans. Apply targeted indexing strategies and rewrite complex SQL structures to reduce latency and improve throughput.
Index tuning for large MySQL tables involves designing indexes that improve selectivity and eliminate table scans. Analyze query structures to create composite or covering indexes that directly support your complex joins and filters.
Rewrite SQL queries to avoid anti-patterns by replacing correlated subqueries with joins and simplifying complex logic. Apply safe SQL rewrite templates to improve performance on large datasets without altering query results.
Diagnose MySQL performance using the performance schema when routine SQL reviews detect latency or throughput drops. Localize slow queries by interpreting execution plans and identifying resource-intensive operations within the database.
Yes, you can use SQL rewrite templates during routine MySQL performance reviews to validate safe query structures. Apply best practices to ensure complex joins and large table queries maintain optimal latency and throughput.
aisa-groupAnalyze EXPLAIN output and recommend indexes and query rewrites for PostgreSQL and MySQL.
FilipcsupkaOptimize AgentDB vector database performance with quantization, HNSW indexing, and caching.
voidrotAnalyze and optimize PostgreSQL queries using EXPLAIN ANALYZE and indexing strategies.
snoodleboot-ioDiagnose slow SQL queries with EXPLAIN ANALYZE and apply indexing optimizations.
