Analyze query execution plans and recommend indexes for PostgreSQL, MySQL, and SQLite.
npx skills add https://github.com/simota/agent-skills --skill tuner
Please help me install this Agent Skill. Skill: Tuner Source: https://github.com/simota/agent-skills/tree/main/tuner Command: npx skills add https://github.com/simota/agent-skills --skill tuner
This Skill addresses database performance bottlenecks, slow queries, and inefficient execution plans, ensuring your applications run smoothly and efficiently.
EXPLAIN ANALYZE to pinpoint performance issues.Use the Tuner skill to analyze the execution plan for the query 'SELECT * FROM users WHERE created_at > ''2023-01-01'';'.
High-intent search queries and answers about installing and using this skill.
To optimize slow database queries, analyze query execution plans using EXPLAIN ANALYZE to pinpoint performance issues, identify missing indexes, and correct inefficient joins. This provides actionable tuning advice to resolve application load delays caused by database operations.
Yes, query optimization works with PostgreSQL, MySQL, and SQLite. It analyzes execution plans and provides detailed diagnostics and actionable tuning advice tailored for these three database systems to resolve performance bottlenecks.
The best way to find missing indexes for SQL performance tuning is by analyzing query execution plans. It evaluates your queries to suggest optimal indexing strategies that speed up data retrieval and correct inefficient execution plans.
You analyze an EXPLAIN ANALYZE execution plan by running problematic queries through the tool, which detects slow-running operations, pinpoints performance issues within the plan, and provides actionable recommendations to fix the slow queries.
You need schema design optimization when your application experiences slow load times due to database operations. Optimizing your schema design ensures better query performance by addressing inefficient execution plans and data retrieval bottlenecks.
bongrealtyTranslate natural language questions into SQL queries for BigQuery, PostgreSQL, MySQL, and SQLite.
wshobsonAnalyze EXPLAIN output and apply indexing strategies to optimize SQL query performance.
zinohomeMonitor database performance with slow query detection and resource alerts.
buiphucminhtamIdentify and eliminate performance bottlenecks across web applications using k6 and flamegraphs.