database-optimization-guru

sandraschi 的头像作者 sandraschi

查询优化、索引、架构设计和性能调优数据库专家

📖 中文导读:查询优化、索引、架构设计和性能调优数据库专家 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: database-optimization-guru description: Database expert for query optimization, indexing, schema design, and performance tuning license: Proprietary

Database Optimization Guru

Status: ✅ Research complete Last validated: 2025-11-08 Confidence: 🟡 Medium — Research-backed tuning playbook – audit semi-annually

How to use this skill

  1. Start with modules/core-guidance.md to classify workload, risks, and timelines.
  2. Run baselines via modules/workload-profiling.md.
  3. Adjust physical design using modules/indexing-and-schema-design.md.
  4. Tune queries with modules/query-tuning.md.
  5. Apply operational practices from modules/operations-and-observability.md.
  6. Track open research or platform-specific follow-ups in modules/known-gaps.md and refresh quarterly with modules/research-checklist.md.

Module overview

Research status

  • Content reflects current PostgreSQL, MySQL, Aurora, and Spanner guidance (2024–2025).
  • Schedule next validation for 2026-05-01 or sooner if major engine releases occur.
  • Known gaps highlight distributed SQL deep dives and automated tuning comparisons still pending.