Diagnose slow queries and execution plans for PostgreSQL and MySQL.
npx skills add https://github.com/rawhit-r/ai-files --skill database-optimizer-rawhit-r
Please help me install this Agent Skill. Skill: database-optimizer Source: https://github.com/rawhit-r/ai-files/tree/main/.gemini/database-optimizer Command: npx skills add https://github.com/rawhit-r/ai-files --skill database-optimizer-rawhit-r
Investigating and optimizing database performance across PostgreSQL and MySQL, to reduce slow queries, improve execution plans, and design effective indexing and configuration changes.
Run a performance diagnostic on your database to identify slow queries, generate an EXPLAIN ANALYZE plan, implement a safe optimization, and verify impact.
High-intent search queries and answers about installing and using this skill.
To diagnose slow queries, generate an EXPLAIN ANALYZE execution plan to identify bottlenecks. Reviewing execution plans reveals missing indexes and inefficient query structures, enabling targeted query rewrites and index design improvements.
Designing indexes for microservice databases requires analyzing execution plans across services to identify query bottlenecks. Apply index strategies and schema improvements incrementally, validating performance gains through measured metrics.
You can optimize database configuration across services by diagnosing execution plans and system metrics. Focus on applying incremental configuration tuning and query rewrites across PostgreSQL and MySQL environments, validating changes with measured outcomes.
Unexpected execution plan performance issues often stem from inaccurate statistics or missing indexes. Diagnose the slow query using EXPLAIN ANALYZE to find inefficient queries and misconfigurations, then apply validated index design changes.
Accurate statistics are required to optimize database performance effectively. Diagnosing slow queries and execution plans relies on accurate statistics to identify true bottlenecks and propose effective index strategies and query rewrites.
Validate database configuration tuning and query rewrites by applying optimizations incrementally and confirming performance gains with measured metrics. Diagnose slow queries before and after changes to ensure measured outcomes improve execution plans.
bobmatnycAnalyze PostgreSQL 15+ queries, indexes, and configuration using EXPLAIN ANALYZE.
JeffallanDiagnose slow queries and optimize indexes for PostgreSQL and MySQL.
DexploarerAnalyze EXPLAIN plans and recommend indexes for PostgreSQL, MySQL, and MongoDB.
microwindAnalyze SQL execution plans and provide index optimization suggestions for multiple databases.
