skills.rest
AratKruglik
AratKruglikCOMMUNITY
Explore all skills by this author →
GitHub

database-optimizer

Analyze slow SQL queries and execution plans for PostgreSQL and MySQL.

150|51|Updated Mar 14, 2026
Search Tags:#indexing#database#postgresql#optimization#sql#performance tuning#mysql
One-click install
npx skills add https://github.com/AratKruglik/claude-laravel --skill database-optimizer-aratkruglik
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/AratKruglik/claude-laravel/tree/main/.claude/skills/database-optimizer
Command: npx skills add https://github.com/AratKruglik/claude-laravel --skill database-optimizer-aratkruglik

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses slow database queries, inefficient data retrieval, and overall poor database performance, ensuring applications run smoothly and responsively.

Core Features & Use Cases

  • Query Analysis: Identifies and analyzes slow-running SQL queries and their execution plans.
  • Index Optimization: Recommends and helps implement optimal indexing strategies to speed up data access.
  • Configuration Tuning: Provides guidance on tuning database parameters for better performance.
  • Use Case: A web application is experiencing slow load times due to inefficient database queries. This Skill can analyze the problematic queries, suggest appropriate indexes, and help rewrite them for optimal performance.

Quick Start

Use the database-optimizer skill to analyze slow queries in the PostgreSQL database.

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 queries using execution plans?▼

To optimize slow PostgreSQL queries, analyze the SQL EXPLAIN output to identify bottlenecks, then apply index design and query rewriting strategies to improve data retrieval efficiency and overall performance.

What's the best way to design indexes for MySQL performance tuning?▼

The best way to design indexes for MySQL performance tuning is to analyze slow-running queries and their execution plans, then implement optimal indexing strategies that directly speed up data access patterns.

How does analyzing SQL EXPLAIN output help with database optimization?▼

Analyzing SQL EXPLAIN output helps with database optimization by revealing how queries execute, allowing you to identify inefficient data retrieval paths, rewrite queries, and apply appropriate indexing strategies for better performance.

Can I tune database configuration parameters for both PostgreSQL and MySQL?▼

Yes, you can tune database configuration parameters for both PostgreSQL and MySQL systems. This Skill helps adjust tuning parameters to improve performance alongside providing index design and query rewriting recommendations.

Why does my web application load slowly due to inefficient database queries?▼

Your web application loads slowly due to inefficient database queries lacking proper indexes or optimized execution plans. Analyzing slow queries and tuning database parameters can resolve these data retrieval bottlenecks.

Related Skills

Explore More Software Engineering Skills→
dieu-donneedieu-donnee

database-optimizer

Identify slow queries and validate index strategies with EXPLAIN ANALYZE across PostgreSQL and MySQL.

Community
Advanced
mvandermeulenmvandermeulen
2

sql-optimization-patterns

Analyze SQL execution plans and suggest indexing strategies for slow queries.

Community
Advanced
oakossoakoss
14

performance-optimizer

Identify and resolve performance bottlenecks across frontend, backend, and database layers.

Official
Advanced
Zhow01Zhow01
52

sql-optimization-patterns

Analyze SQL execution plans and optimize queries for PostgreSQL databases.

Community
Advanced