Database Index Advisor

概要

This skill provides automated assistance for identifying performance bottlenecks and recommending optimal indexing strategies across various database systems, including PostgreSQL, MySQL, and MongoDB. It guides users through a structured end-to-end workflow—from assessing current query metrics and existing schemas to implementing changes in staging and deploying them with comprehensive monitoring and rollback procedures. It is an essential tool for developers looking to reduce query latency, lower cloud resource consumption, and ensure data-heavy applications scale effectively.

主な機能

• Automated analysis of current database indexing and query performance benchmarks
• 0 GitHub stars
• Integrated error handling for permissions, network issues, and resource constraints
• Generation of production-ready migration scripts and monitoring dashboards
• End-to-end implementation workflow including risk assessment and staging validation
• Cross-platform support for PostgreSQL, MySQL, and MongoDB via native shell tools

ユースケース

• Optimizing slow-running queries in large-scale production databases
• Auditing existing schemas to remove redundant indexes and reduce storage overhead
• Designing efficient indexing strategies for new data models during the development phase