skills.rest
jdiegosierra
jdiegosierraCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-optimization

Analyze query plans and metrics to design indexes and tune PostgreSQL and MySQL configurations.

1|Updated Mar 26, 2026
Search Tags:#performance#query optimization#database#postgresql#mysql#index#tuning
One-click install
npx skills add https://github.com/jdiegosierra/enterprise-agent-plugins --skill database-optimization-jdiegosierra
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimization
Source: https://github.com/jdiegosierra/enterprise-agent-plugins/tree/main/plugins/acme-engineering/src/skills/database-optimization
Command: npx skills add https://github.com/jdiegosierra/enterprise-agent-plugins --skill database-optimization-jdiegosierra

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses slow query execution, inefficient indexing, and database bottlenecks, enabling optimal performance for high-traffic systems.

Core Features & Use Cases

  • Performance Analysis: Review slow queries, execution plans, and system metrics to identify bottlenecks.
  • Index Design: Create and evaluate indexes to improve query speed without over-indexing.
  • Configuration Tuning: Adjust DB settings like shared buffers and cache sizes for better resource utilization.
  • Use Case: A large e-commerce database experiencing slow product searches can be optimized to deliver sub-100ms response times across millions of records.

Quick Start

Use the database-optimization skill to analyze the current slow queries and design indexing strategies for the sales table.

Frequently Asked Questions about database-optimization

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

FAQPage Schema
How do I fix slow PostgreSQL queries in a high-traffic database?▼

To fix slow PostgreSQL queries, analyze execution plans and system metrics to identify bottlenecks, then design targeted indexes and tune configuration parameters like shared buffers for incremental performance gains.

What is the best way to optimize MySQL database performance for large-scale environments?▼

The best way to optimize MySQL performance is by reviewing slow query logs, evaluating indexing strategies to prevent over-indexing, and adjusting configuration settings to ensure efficient resource utilization across millions of records.

How do I design indexes to improve query speed without over-indexing?▼

Design indexes by analyzing query execution plans to identify missing or inefficient indexes, evaluating their impact on query speed, and ensuring a balanced approach to avoid the performance overhead of over-indexing.

Does database tuning work for troubleshooting performance issues in large e-commerce systems?▼

Yes, database tuning troubleshoots performance issues in large e-commerce systems by optimizing slow product searches and adjusting DB settings, enabling sub-100ms response times across millions of records.

When should I adjust shared buffers and cache sizes for database performance tuning?▼

Adjust shared buffers and cache sizes during database performance tuning when system metrics indicate resource bottlenecks, ensuring better resource utilization through incremental changes and comprehensive documentation.

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
fsollafsolla

deprecation-and-migration

Plan and execute incremental migrations of legacy systems with feature flags.

Community
Advanced
linskybinglinskybing

redis-caching

Implement Redis caching with connection pooling, TTL strategies, and invalidation rules.

Community
Advanced
UnicornUnicorn

db-design-agent

Design database schemas and data models for relational and NoSQL applications.

Official
Intermediate