skills.rest
fanguyun
fanguyunCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-optimizer

Diagnose slow queries and optimize indexes in PostgreSQL and MySQL databases.

Updated May 31, 2026
Search Tags:#query optimization#indexing#PostgreSQL#MySQL#database performance#configuration tuning
One-click install
npx skills add https://github.com/fanguyun/SkillManager --skill database-optimizer-fanguyun
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/fanguyun/SkillManager/tree/main/database-optimizer
Command: npx skills add https://github.com/fanguyun/SkillManager --skill database-optimizer-fanguyun

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps diagnose and resolve database performance issues in PostgreSQL and MySQL, providing advanced tools and knowledge for optimization and maintenance.

Core Features & Use Cases

  • Performance Diagnostics: Analyze query execution plans, identify slow queries, and measure database performance.
  • Index Optimization: Design and manage indexes for efficient data retrieval and improve query performance.
  • Configuration Tuning: Adjust database configuration parameters to optimize performance for specific workloads.
  • Use Case: If you are experiencing slow query times in your PostgreSQL or MySQL database and need to improve performance, this Skill provides a suite of tools and guidelines to optimize your database.

Quick Start

Use the 'database-optimizer' skill to analyze the performance of your PostgreSQL database and identify slow queries.

Frequently Asked Questions about database-optimizer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I diagnose slow queries in PostgreSQL and MySQL?▼

Diagnosing slow queries in PostgreSQL and MySQL requires analyzing query execution plans and measuring database performance metrics. This isolates inefficient retrieval paths and identifies exact latency bottlenecks within your database operations.

What is the best way to optimize indexes for database performance?▼

Optimizing indexes for database performance involves designing and managing them for efficient data retrieval. Proper index structures target slow query execution paths, significantly reducing retrieval times and improving overall database performance.

How do I tune database configuration parameters for specific workloads?▼

Tuning database configuration parameters for specific workloads involves adjusting internal settings to optimize performance. This aligns PostgreSQL or MySQL resource allocation with your specific traffic patterns, ensuring efficient database operations under varying loads.

Does this database performance tuning support partitioning strategies?▼

Yes, database performance tuning supports applying partitioning strategies. Partitioning divides large PostgreSQL and MySQL tables into smaller pieces, improving query performance and maintenance efficiency for specific data retrieval patterns.

When do I need to apply partitioning strategies for query optimization?▼

Apply partitioning strategies for query optimization when large tables cause slow query times. Partitioning splits data into smaller chunks, allowing PostgreSQL and MySQL to scan fewer rows and significantly improve retrieval performance.

Related Skills

Explore More Software Engineering Skills→
afonsoftafonsoft
1

sql-optimization

Optimize SQL queries and indexing across MySQL, PostgreSQL, SQL Server, and Oracle.

Community
Advanced
dieu-donneedieu-donnee

database-optimizer

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

Community
Advanced
cosmixcosmix
53

caching

Implement caching strategies with TTL management and Redis or Memcached.

Community
Advanced
ricablericable

training-llms-megatron

Train large language models with distributed parallelism across multi-GPU clusters.

Community
Advanced