database-optimization-guru
Database expert for query optimization, indexing, schema design, and performance tuning
Security Assessment
About database-optimization-guru
The 'database-optimization-guru' skill is designed to assist in optimizing database performance by providing expert guidance in areas like query optimization, indexing, schema design, and performance tuning. It helps users enhance the efficiency of their database systems, ensuring that they can handle large workloads with minimal latency and resource consumption. By utilizing this skill, users can improve the overall performance and scalability of their database environments, particularly for SQL-based systems like PostgreSQL, MySQL, Aurora, and Spanner.
FAQ
How do I get started with this skill?
Start by following the guidance in the 'core-guidance.md' module to classify your workload, identify risks, and set timelines. Then proceed with profiling your workload and adjusting your database design and queries accordingly.
Which database systems does this skill support?
This skill supports PostgreSQL, MySQL, Aurora, and Spanner. Research and tuning guidance are based on these platforms for 2024–2025.
Are there any specific limitations with this skill?
The skill currently lacks in-depth research on distributed SQL and automated tuning comparisons, which are highlighted as known gaps. These areas will be addressed in future updates.
Install database-optimization-guru
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
sandraschi/advanced-memory-mcp