database-optimizer

Analyze database workloads and generate actionable tuning plans.

Updated Aug 23, 2026

Search Tags:#performance #caching #indexing #database #scalability #query-optimization #tuning

Ready to run

npx skills add https://github.com/MeoBaka/MeoPanel-Client --skill database-optimizer-meobaka

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/MeoBaka/MeoPanel-Client/tree/main/.claude/skills/database-optimizer
Command: npx skills add https://github.com/MeoBaka/MeoPanel-Client --skill database-optimizer-meobaka

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The skill helps organizations optimize and scale databases by identifying bottlenecks, tuning queries, and designing robust architectures.

Core Features & Use Cases

Advanced Query Optimization: analyze and rewrite expensive queries for better execution plans.
Modern Indexing Strategies: design and implement effective indexes to speed up workloads.
Performance Monitoring & Baseline Tracking: establish benchmarks and monitor regressions over time.
Database Scaling & Partitioning: plan horizontal and vertical scaling, including partitioning strategies.
Schema Design & Migration: optimize schemas and zero-downtime migration approaches.
Cloud-aware optimization: tailor strategies for cloud-hosted databases and managed services.

Quick Start

Analyze a slow-running database workload and generate a step-by-step optimization plan with concrete indexing, query rewrites, and caching recommendations.

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 database queries in a production environment?▼

To optimize slow database queries, you can analyze execution plans, rewrite expensive queries, and apply modern indexing strategies to reduce latency and improve performance across OLTP and OLAP workloads.

What is the best way to design an indexing strategy for scalable database architectures?▼

The best way to design an indexing strategy is to analyze your specific workloads and implement targeted indexes that speed up query execution, establishing performance baselines to monitor for regressions over time.

Can I plan zero-downtime database schema migrations for high-traffic applications?▼

Yes, you can plan zero-downtime database schema migrations by optimizing schemas and utilizing safe migration approaches that ensure continuous availability during the transition.

Does database partitioning work for both horizontal and vertical scaling?▼

Database partitioning works for both horizontal and vertical scaling, allowing you to design robust architectures that distribute workloads efficiently and maintain performance as data volume grows.

How do I tune cloud-hosted databases for better performance?▼

To tune cloud-hosted databases, you can tailor optimization strategies specifically for managed services, analyzing workloads to propose actionable tuning plans that reduce latency in cloud environments.

When should I use caching to reduce database latency?▼

You should use caching to reduce database latency when query optimization and indexing are insufficient, integrating cache design with monitoring tools to track performance baselines and prevent regressions.