skills.rest
Mentor-Wizard
Mentor-WizardOFFICIAL
Explore all skills by this author →
GitHub

database-optimizer

Analyze slow queries and execution plans for PostgreSQL and MySQL.

10|3|Updated Mar 14, 2025
Search Tags:#database#postgresql#optimization#sql#performance tuning#mysql#query analysis
One-click install
npx skills add https://github.com/Mentor-Wizard/mentor-wizard-webapp --skill database-optimizer-mentor-wizard
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/Mentor-Wizard/mentor-wizard-webapp/tree/main/.claude/skills/database-optimizer
Command: npx skills add https://github.com/Mentor-Wizard/mentor-wizard-webapp --skill database-optimizer-mentor-wizard

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses issues related to slow database queries, inefficient data retrieval, and overall suboptimal database performance, leading to faster application response times and improved user experience.

Core Features & Use Cases

  • Query Analysis: Analyzes slow queries and their execution plans to identify bottlenecks.
  • Index Optimization: Designs and suggests optimal indexing strategies to speed up data access.
  • Configuration Tuning: Recommends and applies performance tuning for database parameters.
  • Use Case: A web application is experiencing slow load times due to complex database queries. This Skill can analyze the queries, suggest appropriate indexes, and tune database configurations to significantly improve performance.

Quick Start

Use the database-optimizer skill to analyze and optimize the slow query 'SELECT * FROM users WHERE email LIKE "%@example.com";'.

Frequently Asked Questions about database-optimizer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow PostgreSQL and MySQL queries?▼

Database query optimization works by analyzing slow queries and execution plans to pinpoint bottlenecks, enabling targeted improvements through index design, query rewrites, and configuration tuning to resolve performance issues.

How do I analyze a database execution plan to improve query performance?▼

Analyzing a database execution plan involves examining system metrics and query execution paths to detect inefficiencies, which informs recommendations for partitioning strategies and index design to improve execution times.

What is the best way to design indexes for slow database queries?▼

The best way to design indexes for slow database queries is to analyze execution plans and query patterns, allowing you to structure optimal indexing strategies that speed up data access and resolve bottlenecks.

Can I tune PostgreSQL and MySQL configuration parameters to resolve database bottlenecks?▼

Yes, you can tune PostgreSQL and MySQL configuration parameters by analyzing system metrics to recommend and apply performance tuning adjustments, resolving bottlenecks and improving overall database execution times.

When should I use database partitioning strategies for performance tuning?▼

You should use database partitioning strategies during performance tuning when analyzing execution plans reveals significant data retrieval bottlenecks that cannot be resolved through query rewrites or index design alone.

Related Skills

Explore More Software Engineering Skills→
JeffallanJeffallan
10.9k

database-optimizer

Diagnose slow queries and optimize indexes for PostgreSQL and MySQL.

Community
Advanced
Michae2xlMichae2xl

kotlin-exposed-patterns

Simplify Kotlin database access with Exposed ORM DSL queries and DAO patterns.

Community
Advanced
shalevaminshalevamin

database-optimizer

Analyze execution plans and optimize PostgreSQL and MySQL database performance.

Community
Advanced
MovchanetsMovchanets

database-optimizer

Diagnose slow queries and inefficient indexes across multiple database systems.

Community
Advanced