Expert in groups, rings, fields, and algebraic structures with applications to cryptography and number theory
The English summary is being prepared. Showing the original description.
sandraschi/advanced-memory-mcp20Updated Oct 13, 2026
FreePublished on GitHub
database-optimization-guru
Database expert for query optimization, indexing, schema design, and performance tuning
The English summary is being prepared. Showing the original description.
See how to installFiles included (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 (original)
Review the instructions the agent will receive before you install.
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.
Reviews
No reviews yet. Tell others what you thought.
Comments
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
More skills from this repository
Expert in Japanese honorific language covering 尊敬語・謙譲語・丁寧語 with deep understanding of situational usage, business contexts, and cultural nuances
The English summary is being prepared. Showing the original description.
sandraschi/advanced-memory-mcp20Updated Oct 13, 2026
Use when planning, scaffolding, validating, or packaging Claude skills inside Advanced Memory MCP.
The English summary is being prepared. Showing the original description.
sandraschi/advanced-memory-mcp20Updated Oct 13, 2026
Structured Zettelkasten workflow for AMD — observe, draft, enrich, retrieve, decide, preview, write, verify. Produces high-quality atomic knowledge cards with deliberate linking.
The English summary is being prepared. Showing the original description.
sandraschi/advanced-memory-mcp20Updated Oct 13, 2026
Master AI debate techniques with comprehensive counter-arguments against slop criticism, safety concerns, philosophical objections, and political rhetoric
The English summary is being prepared. Showing the original description.
sandraschi/advanced-memory-mcp20Updated Oct 13, 2026
ai-ide-developer
FreeMaster 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
The English summary is being prepared. Showing the original description.
sandraschi/advanced-memory-mcp20Updated Oct 13, 2026