Expert in groups, rings, fields, and algebraic structures with applications to cryptography and number theory
中文简介正在准备中。当前显示原文说明。
sandraschi/advanced-memory-mcp202026年10月13日 更新
免费在 GitHub 公开
database-optimization-guru
Database expert for query optimization, indexing, schema design, and performance tuning
中文简介正在准备中。当前显示原文说明。
查看安装方法包含的文件（10）
- SKILL.md2.1 KB
- _toc.md956 B
- modules/core-guidance.md4.5 KB
- modules/indexing-and-schema-design.md3.1 KB
- modules/known-gaps.md836 B
- modules/operations-and-observability.md2.7 KB
- modules/query-tuning.md2.5 KB
- modules/research-checklist.md1.9 KB
- modules/workload-profiling.md3.1 KB
- README.md259 B
SKILL.md（原文）
安装前可以查看交给 AI 代理的指令内容。
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
- Start with modules/core-guidance.md to classify workload, risks, and timelines.
- Run baselines via modules/workload-profiling.md.
- Adjust physical design using modules/indexing-and-schema-design.md.
- Tune queries with modules/query-tuning.md.
- Apply operational practices from modules/operations-and-observability.md.
- Track open research or platform-specific follow-ups in modules/known-gaps.md and refresh quarterly with modules/research-checklist.md.
Module overview
- Core guidance — triage checklist, workload classification, stakeholder alignment.
- Workload profiling — baseline metrics, tooling, sampling approaches.
- Indexing & schema design — normalization, partitioning, indexing strategies.
- Query tuning — execution plans, rewrite patterns, optimizer hints.
- Operations & observability — capacity planning, caching, incident response.
- Known gaps — targeted research backlog.
- Research checklist — semi-annual refresh workflow.
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.
评价
还没有评价。欢迎分享你的使用感受。
评论
无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。
还没有评论。来写第一条吧。
同一仓库的技能
Expert in Japanese honorific language covering 尊敬語・謙譲語・丁寧語 with deep understanding of situational usage, business contexts, and cultural nuances
中文简介正在准备中。当前显示原文说明。
sandraschi/advanced-memory-mcp202026年10月13日 更新
Use when planning, scaffolding, validating, or packaging Claude skills inside Advanced Memory MCP.
中文简介正在准备中。当前显示原文说明。
sandraschi/advanced-memory-mcp202026年10月13日 更新
Structured Zettelkasten workflow for AMD — observe, draft, enrich, retrieve, decide, preview, write, verify. Produces high-quality atomic knowledge cards with deliberate linking.
中文简介正在准备中。当前显示原文说明。
sandraschi/advanced-memory-mcp202026年10月13日 更新
Master AI debate techniques with comprehensive counter-arguments against slop criticism, safety concerns, philosophical objections, and political rhetoric
中文简介正在准备中。当前显示原文说明。
sandraschi/advanced-memory-mcp202026年10月13日 更新
Master AI-integrated development environments with comprehensive coverage of Windsurf, Cursor, Antigravity, Zed, Cline, and FOSS newcomers, including intelligent usage patterns, cost optimization, and the evolution toward fully agentic development
中文简介正在准备中。当前显示原文说明。
sandraschi/advanced-memory-mcp202026年10月13日 更新