skills.rest
saeed-vayghan
saeed-vayghanCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-optimizer

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

30|7|Updated Jan 13, 2026
Search Tags:#performance#indexing#database#optimization#sql#tuning
One-click install
npx skills add https://github.com/saeed-vayghan/gemini-agent-skills --skill database-optimizer-saeed-vayghan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/saeed-vayghan/gemini-agent-skills/tree/main/.gemini/skills/database-optimizer
Command: npx skills add https://github.com/saeed-vayghan/gemini-agent-skills --skill database-optimizer-saeed-vayghan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes assets (resource) components.

What problem does it solve?

This Skill addresses the critical need for high-performing and scalable database systems by identifying and resolving performance bottlenecks, optimizing query execution, and implementing efficient indexing strategies.

Core Features & Use Cases

  • Query Optimization: Analyzes and rewrites slow queries for faster execution.
  • Index Strategy: Designs and implements optimal indexing for improved data retrieval.
  • Performance Tuning: Adjusts database configurations for peak efficiency across various systems (PostgreSQL, MySQL, MongoDB, etc.).
  • Use Case: A user experiencing slow load times on their e-commerce platform can use this skill to diagnose and fix the underlying database issues, leading to a smoother customer experience.

Quick Start

Use the database-optimizer skill to analyze and improve the performance of my PostgreSQL database.

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 SQL queries to achieve sub-second response times?▼

To optimize slow SQL queries, you must analyze query execution plans, rewrite inefficient queries, tune database configurations, and implement strategic indexing to achieve sub-second response times and reduce high resource utilization.

What is the best way to design an indexing strategy for database performance tuning?▼

The best way to design an indexing strategy for database performance tuning is to analyze query execution plans and implement strategic indexing that targets slow queries, ensuring efficient data retrieval and robust database architecture.

Does database optimization work with both SQL and NoSQL systems like MongoDB?▼

Database optimization works across multiple systems including PostgreSQL, MySQL, and MongoDB, by tuning configurations and addressing scalability challenges to ensure efficient resource allocation and sub-second query response times.

How do I diagnose high resource utilization affecting my database scalability?▼

Diagnose high resource utilization by analyzing query execution plans to identify performance bottlenecks, then resolve them through query optimization and performance tuning to support robust database architecture and scalability.

When should I analyze a query execution plan for database optimization?▼

You should analyze a query execution plan for database optimization when experiencing slow queries, high resource utilization, or scalability challenges, using the analysis to rewrite queries and implement efficient indexing strategies.

Related Skills

Explore More Software Engineering Skills→
rabbicserabbicse

database-optimizer

Optimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.

Community
Advanced
7a336e6e7a336e6e
1

Optimizing Performance

Diagnose PostgreSQL bottlenecks via EXPLAIN ANALYZE and optimize indexing.

Community
Advanced
pacphipacphi
7

V3 MCP Optimization

Optimize claude-flow v3 MCP servers with connection pooling and load balancing.

Community
Advanced
oakossoakoss
14

performance-optimizer

Identify and resolve performance bottlenecks across frontend, backend, and database layers.

Official
Advanced