skills.rest
AndyAnh174
AndyAnh174COMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-optimizer

Optimize relational and cloud database performance through index tuning and query rewriting.

Updated Feb 26, 2026
Search Tags:#performance#caching#indexing#database#scalability#optimization#query-tuning
One-click install
npx skills add https://github.com/AndyAnh174/wellness --skill database-optimizer-andyanh174
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/AndyAnh174/wellness/tree/main/.agent/skills/database-optimizer
Command: npx skills add https://github.com/AndyAnh174/wellness --skill database-optimizer-andyanh174

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Expert guidance to identify and resolve bottlenecks in database systems, delivering faster queries, better indexing, and scalable architectures.

Core Features & Use Cases

  • Advanced Query Optimization
  • Modern Indexing Strategies
  • Performance Monitoring & Baseline Tracking
  • N+1 Query Resolution and caching architectures
  • Cloud and multi-database optimization for heterogeneous environments

Quick Start

Provide a diagnostic plan to identify and resolve a slow multi-join query in a PostgreSQL production 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 multi-join queries in a PostgreSQL production database?▼

Resolve slow PostgreSQL queries by analyzing execution plans, rewriting inefficient query structures, and applying targeted indexing strategies. This approach identifies performance bottlenecks and delivers automated recommendations for faster data retrieval.

What is the best way to resolve N+1 query problems and improve database caching?▼

Resolving N+1 query problems involves implementing modern caching architectures alongside query rewriting to eliminate redundant database calls. This strategy minimizes repetitive fetches, reduces latency, and improves overall application scalability.

Does database optimization work for both OLTP and OLAP workloads across cloud environments?▼

Database optimization supports both OLTP and OLAP workloads across relational and cloud databases within heterogeneous environments. It manages diverse system demands through continuous performance monitoring, execution plan analysis, and scalable architecture planning.

Can I use indexing strategies and performance monitoring for MySQL and SQL Server?▼

Indexing strategies and performance monitoring are fully supported for MySQL, SQL Server, PostgreSQL, and cloud services. This cross-platform compatibility enables consistent baseline tracking and automated tuning recommendations across diverse database environments.

How do I plan a database migration without sacrificing scalability?▼

Planning a database migration requires establishing performance baselines, analyzing execution plans, and applying scalable indexing strategies to maintain throughput. This preparation ensures the target architecture efficiently handles projected workloads without performance degradation.

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
JeffallanJeffallan
10.9k

database-optimizer

Diagnose slow queries and optimize indexes for PostgreSQL and MySQL.

Community
Advanced
an8079an8079
4

performance-tuning

Optimize application performance across concurrency, database, caching, and vector retrieval layers.

Community
Advanced
AmidVoshakulAmidVoshakul

database-optimizer

Analyze execution plans and implement indexing strategies to optimize database performance.

Community
Advanced