skills.rest
shalevamin
shalevaminCOMMUNITY
Explore all skills by this author →
GitHub

database-optimizer

Analyze execution plans and optimize PostgreSQL and MySQL database performance.

Updated Mar 7, 2026
Search Tags:#database#postgresql#optimization#sql#performance tuning#mysql
One-click install
npx skills add https://github.com/shalevamin/The-_Ultimate_agents --skill database-optimizer-shalevamin
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/shalevamin/The-_Ultimate_agents/tree/main/.claude/skills/database-optimizer
Command: npx skills add https://github.com/shalevamin/The-_Ultimate_agents --skill database-optimizer-shalevamin

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses performance bottlenecks in PostgreSQL and MySQL databases, ensuring applications run faster and more efficiently by optimizing queries and configurations.

Core Features & Use Cases

  • Query Analysis: Identifies and rewrites slow or inefficient SQL queries.
  • Index Optimization: Designs and implements optimal indexing strategies.
  • Configuration Tuning: Adjusts database parameters for better performance.
  • Use Case: A web application is experiencing slow load times due to database queries. This Skill can analyze the execution plans, identify missing indexes or poorly written queries, and provide specific SQL to improve performance.

Quick Start

Use the database-optimizer skill to analyze and optimize the slow query identified in the logs.

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?▼

Database configuration tuning adjusts internal database parameters to maximize throughput and resolve suboptimal settings. This Skill evaluates your PostgreSQL or MySQL configuration parameters and implements adjustments to ensure the database engine runs efficiently under your specific workload.

What causes index inefficiencies and how do I fix them?▼

Index inefficiencies occur when missing or poorly designed indexes force full table scans during data retrieval. This Skill identifies these gaps by analyzing execution plans and implements optimal indexing strategies to accelerate query performance across your PostgreSQL and MySQL databases.

Do I need to understand database internals to use query rewrites for performance tuning?▼

Yes, this Skill supports both PostgreSQL and MySQL environments. It analyzes execution plans and addresses index inefficiencies across both database platforms, allowing you to apply consistent performance tuning methodologies regardless of which system your web application uses.

What is the best way to identify database bottlenecks causing slow web application load times?▼

The best way to identify database bottlenecks is by analyzing execution plans extracted from your database logs. This Skill processes those logs to find missing indexes or poorly written queries, providing specific SQL solutions to resolve the slow load times.

Related Skills

Explore More Software Engineering Skills→
icartshicartsh
4

sql-expert

Write optimized SQL queries and schemas across PostgreSQL, MySQL, SQLite, and SQL Server.

Community
Advanced
HieubkavHieubkav

database-performance

Analyze database indexes and query execution plans to recommend optimizations.

Community
Advanced
AratKruglikAratKruglik
150

postgresql-optimization

Optimize PostgreSQL queries, indexes, and configuration parameters.

Community
Advanced
alexander-danilenkoalexander-danilenko
14

database-optimizer

Analyze PostgreSQL and MySQL execution plans to optimize slow queries.

Community
Advanced