skills.rest
camelranchentertainment
camelranchentertainmentCOMMUNITY
Explore all skills by this author →
GitHub

database-optimizer

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
One-click install
npx skills add https://github.com/camelranchentertainment/Booking-Platform --skill database-optimizer-camelranchentertainment
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
rabbicserabbicse

database-optimizer

Optimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.

Community
Advanced
jsamuelsen11jsamuelsen11

performance-tuning

Analyze PostgreSQL query plans and statistics to identify performance bottlenecks.

Community
Advanced
JasonLoJasonLo

ss-database-optimizer

Optimize PostgreSQL and MySQL queries through index design and execution plan analysis.

Community
Advanced
sandeepmvlsandeepmvl
21

multi-database-and-replicas

Configure primary-replica architectures and multi-database isolation in Ruby on Rails.

Community
Advanced