database-optimizer

Analyze query execution plans and design indexing strategies for database performance.

1|Updated Jan 20, 2026

Search Tags:#query optimization #indexing #database #scalability #sql #nosql #performance tuning

Ready to run

npx skills add https://github.com/fakhriaditiarahman/Your-Skill-Agent --skill database-optimizer-fakhriaditiarahman

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/fakhriaditiarahman/Your-Skill-Agent/tree/main/.agent/skills/database-optimizer
Command: npx skills add https://github.com/fakhriaditiarahman/Your-Skill-Agent --skill database-optimizer-fakhriaditiarahman

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses database performance bottlenecks, slow queries, and scalability challenges by providing expert-level optimization strategies.

Core Features & Use Cases

Query Optimization: Analyzes and rewrites complex SQL queries for maximum efficiency.
Indexing Strategies: Designs and implements advanced indexing for faster data retrieval.
Performance Tuning: Optimizes database configurations, caching, and resource utilization.
Use Case: A high-traffic e-commerce site is experiencing slow page load times due to database queries; this Skill can identify the problematic queries, suggest optimal indexes, and tune the database configuration to resolve the issue.

Quick Start

Use the database-optimizer skill to analyze and optimize the slow query log from the attached file 'slow_queries.log'.

Frequently Asked Questions about database-optimizer

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

FAQPage Schema

How do I fix slow database queries causing high page load times?▼

To fix slow database queries, analyze query execution plans to identify bottlenecks and rewrite complex SQL for maximum efficiency. This resolves high-traffic performance issues by targeting problematic queries directly.

What is the best way to design indexing strategies for high-throughput databases?▼

Designing advanced indexing strategies involves creating targeted indexes for faster data retrieval. This reduces query latency in high-throughput systems by ensuring the database engine locates needed rows without full table scans.

Can I tune PostgreSQL and MySQL database configurations for better scalability?▼

Yes, you can tune PostgreSQL and MySQL configurations for better scalability by optimizing resource utilization and implementing multi-tier caching. This supports modern scalable architectures by maximizing database throughput.

How does analyzing a slow query log help with SQL performance tuning?▼

Analyzing a slow query log helps with SQL performance tuning by pinpointing exact queries causing delays. It enables targeted query optimization and indexing strategies to resolve specific database performance bottlenecks.

Does database optimization work for NoSQL architectures or only SQL systems?▼

Database optimization works for both NoSQL architectures and SQL systems. It addresses performance tuning across modern scalable architectures by applying specialized indexing and configuration tuning techniques for each database type.