skills.rest
Movchanets
MovchanetsCOMMUNITY
Explore all skills by this author →
GitHub

database-optimizer

Diagnose slow queries and inefficient indexes across multiple database systems.

Updated May 5, 2026
Search Tags:#caching#indexing#scalability#microservices#query tuning#performance monitoring#database optimization
One-click install
npx skills add https://github.com/Movchanets/Microservices_Learning --skill database-optimizer-movchanets
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/Movchanets/Microservices_Learning/tree/main/.agents/skills/database-optimizer
Command: npx skills add https://github.com/Movchanets/Microservices_Learning --skill database-optimizer-movchanets

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you diagnose and fix database performance problems such as slow queries, inefficient indexing, excessive I/O, and scaling bottlenecks.

Core Features & Use Cases

  • Query Optimization: Analyze query structure and execution behavior to reduce latency and resource usage.
  • Indexing Strategy: Design or refine indexes based on workload patterns, join paths, and filtering needs.
  • Scalability Planning: Improve caching, partitioning, replication, and data modeling for high-traffic systems.
  • Use Case: A microservices team can use this Skill to investigate a slow order lookup path, tune the SQL, validate the plan, and recommend indexing or caching changes.

Quick Start

Ask the database-optimizer skill to analyze your slow queries, schema design, and workload patterns, then return prioritized tuning actions with validation steps.

Frequently Asked Questions about database-optimizer

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

FAQPage Schema
How do I identify slow database queries and fix performance bottlenecks?▼

To fix slow database queries, you analyze execution plans to identify inefficient indexes and excessive I/O. This Skill diagnoses query structure and scaling bottlenecks, then returns prioritized tuning actions with validation steps for measurable performance gains.

What is the best way to design an indexing strategy for high-traffic microservices?▼

Designing an indexing strategy requires analyzing workload patterns, join paths, and filtering needs. This Skill refines indexes based on your microservices data access patterns to reduce latency and resource usage across PostgreSQL, MySQL, and SQL Server.

Does query tuning work with both SQL and NoSQL databases like MongoDB?▼

Query tuning works with both SQL and NoSQL databases. This Skill diagnoses performance and improves query behavior across PostgreSQL, MySQL, SQL Server, and MongoDB by analyzing execution behavior and validating optimization changes.

How do I validate database optimization changes safely before production?▼

To validate database optimization changes safely, you apply benchmarking and monitoring against the proposed tuning actions. This Skill requires safe optimization validation to ensure indexing and query tuning deliver measurable performance gains without regressions.

Why does adding indexes not improve my slow query performance?▼

Adding indexes fails to improve slow query performance when execution plans reveal scaling bottlenecks or inefficient data access patterns. This Skill analyzes execution plans, caching layers, and partitioning to identify hidden I/O bottlenecks beyond missing indexes.

Related Skills

Explore More Software Engineering Skills→
LaurentPRAT-DBLaurentPRAT-DB

performance-tuning

Analyze Databricks metrics and logs to tune Spark configuration and caching.

Community
Intermediate
dabblersportdabblersport

AgentDB Performance Optimization

Optimize AgentDB vector database performance with quantization, HNSW indexing, and caching.

Community
Intermediate
tassosgomestassosgomes

dotnet-performance

Optimize .NET performance bottlenecks in EF Core queries, caching, and HttpClient resilience.

Community
Advanced
botPhUbotPhU

postgres-expert

Analyze and optimize PostgreSQL queries, indexing, and configuration.

Community
Advanced