About
This skill provides Claude with specialized capabilities for analyzing, designing, and optimizing database indexes to significantly improve query performance. It automates the complex process of identifying bottlenecks, proposing optimal index structures, and safely implementing changes across PostgreSQL, MySQL, and MongoDB environments. By following a rigorous 5-step lifecycle—from initial state assessment and solution design to staging validation and production deployment—it ensures that database optimizations are data-driven, thoroughly tested, and deployed with robust monitoring and rollback procedures.
