Diagnose slow SQL queries by analyzing execution plans and recommending targeted fixes.
npx skills add https://github.com/JayRHa/AgentSkills --skill sql-optimizer-jayrha
Please help me install this Agent Skill. Skill: sql-optimizer Source: https://github.com/JayRHa/AgentSkills/tree/main/sql-optimizer Command: npx skills add https://github.com/JayRHa/AgentSkills --skill sql-optimizer-jayrha
Diagnoses and fixes slow SQL queries by reading execution plans, identifying dominant costs, and proposing concrete, minimal changes (indexing, query rewrites, or schema adjustments) to restore performance.
Provide a slow SQL query or plan, and I will generate an actionable optimization workflow.
High-intent search queries and answers about installing and using this skill.
To optimize slow SQL queries, analyze the EXPLAIN ANALYZE plan to locate bottlenecks like sequential scans and high-cost joins, then apply targeted indexing or query rewrites to achieve verifiable performance improvements.
The best way to fix high-cost joins and sorts in PostgreSQL is to evaluate the execution plan and apply covering indexes or query rewrites that minimize large sequential scans and reduce sorting overhead.
SQL query tuning works across MySQL, SQL Server, PostgreSQL, and SQLite workloads by reading execution plans and proposing deterministic indexing strategies and query rewrites tailored for each specific platform.
You need to refresh statistics for query plan analysis when the database optimizer generates inefficient execution paths due to stale data distributions, ensuring accurate cost estimates before applying indexing or query rewrites.
An execution plan shows a sequential scan on a large table when missing or ineffective indexes force the database to read all rows, requiring targeted indexing strategies or query rewrites to achieve a faster, explainable plan.
bobmatnycAnalyze PostgreSQL 15+ queries, indexes, and configuration using EXPLAIN ANALYZE.
dieu-donneeIdentify slow queries and validate index strategies with EXPLAIN ANALYZE across PostgreSQL and MySQL.
JesusFigueroa25Optimize PostgreSQL and MySQL database performance through schema, query, and indexing analysis.
microwindAnalyze SQL execution plans and provide index optimization suggestions for multiple databases.
