database-optimizer

Name: database-optimizer
Availability: InStock
Author: camelranchentertainment

Optimize PostgreSQL and MySQL queries with EXPLAIN ANALYZE and indexing strategies.

1|Updated Jan 19, 2026

Search Tags:#database #postgresql #mysql #performance-tuning #query-optimization #execution-plan

Ready to run

npx skills add https://github.com/camelranchentertainment/Booking-Platform --skill database-optimizer-camelranchentertainment

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/camelranchentertainment/Booking-Platform/tree/main/.claude/skills/database-optimizer
Command: npx skills add https://github.com/camelranchentertainment/Booking-Platform --skill database-optimizer-camelranchentertainment

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Reduces database query latency and resource usage by optimizing queries, execution plans, and configurations across PostgreSQL and MySQL.

Core Features & Use Cases

Analyze slow queries with EXPLAIN ANALYZE to identify bottlenecks.
Design and implement indexing strategies, query rewrites, and partitioning.
Tune configuration and schema to improve throughput while mitigating contention.
Validate changes with before/after benchmarks and explain plans.

Quick Start

Run EXPLAIN ANALYZE on the target query, design a concrete optimization plan, and verify improvements with benchmark results.

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

Run EXPLAIN ANALYZE on the target query to identify execution plan bottlenecks, then design an optimization plan using indexing strategies, query rewrites, and configuration tuning to reduce database latency.

What is the best way to reduce MySQL query latency in production workloads?▼

Reduce MySQL query latency by applying index design, query rewrites, and configuration tuning to improve throughput while mitigating contention in production workloads.

How do I design indexing strategies and partitioning for database performance tuning?▼

Design indexing strategies and partitioning by analyzing execution plans to target bottlenecks, then implementing structural schema changes to improve query throughput and reduce resource consumption.

Can I validate database query optimization changes with before and after benchmarks?▼

Validate database query optimization changes by running before and after benchmarks alongside EXPLAIN plans to verify latency improvements and ensure safe rollout practices avoid performance regressions.

When should I not use query rewrites for database optimization?▼

Avoid query rewrites for database optimization when execution plans show adequate indexing and configuration tuning alone can mitigate contention, preventing unnecessary changes that risk performance regressions.