skills.rest
mhbdev
mhbdevCOMMUNITY
Explore all skills by this author →
GitHub

database-optimizer

Analyze slow queries and execution plans for PostgreSQL and MySQL.

Updated Aug 23, 2026
Search Tags:#indexing#SQL#database#optimization#performance tuning#query analysis
One-click install
npx skills add https://github.com/mhbdev/git-pal --skill database-optimizer-mhbdev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/mhbdev/git-pal/tree/main/.agents/skills/database-optimizer
Command: npx skills add https://github.com/mhbdev/git-pal --skill database-optimizer-mhbdev

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses issues related to slow database queries, inefficient execution plans, and overall suboptimal database performance.

Core Features & Use Cases

  • Query Analysis: Investigates slow queries and analyzes their execution plans.
  • Optimization Strategies: Provides recommendations for index design, query rewrites, and configuration tuning.
  • Use Case: When a critical application experiences slow response times due to database load, this Skill can diagnose the bottleneck and suggest specific SQL changes or index additions to resolve it.

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 SQL queries in PostgreSQL and MySQL?▼

You can analyze slow queries by investigating their execution plans using EXPLAIN ANALYZE. This Skill reviews the execution plans and system metrics to diagnose bottlenecks and suggest specific SQL changes or index additions.

What is the best way to improve database performance under heavy application load?▼

Yes, this Skill supports query analysis for both PostgreSQL and MySQL. It investigates slow queries and provides optimization strategies tailored to the specific database platform you are using.

How do I use EXPLAIN ANALYZE to fix inefficient database execution plans?▼

This Skill addresses slow database queries, inefficient execution plans, and suboptimal database performance. It diagnoses bottlenecks causing slow application response times and suggests specific index designs or SQL changes to resolve them.

What database indexing strategies help with query optimization and scalability?▼

This Skill can optimize queries like 'SELECT * FROM users WHERE email LIKE "%@example.com";' by analyzing the execution plan and recommending specific index additions or query rewrites to improve the response time.

Related Skills

Explore More Software Engineering Skills→
EstomEstom

database-optimizer

Analyze slow PostgreSQL and MySQL queries and optimize execution plans.

Community
Advanced
Mentor-WizardMentor-Wizard
10

database-optimizer

Analyze slow queries and execution plans for PostgreSQL and MySQL.

Official
Advanced
Chengxufeng1994Chengxufeng1994

sql-optimization

Analyze SQL execution plans and optimize queries across MySQL, PostgreSQL, SQL Server, and Oracle.

Community
Advanced
tankpkgtankpkg
1

@tank/relational-db-mastery

Optimize PostgreSQL and MySQL query performance with indexing and tuning strategies.

Official
Advanced