Which databases are supported by this skill?

The Database Index Advisor supports popular database systems including PostgreSQL (via psql), MySQL (via mysql), and MongoDB (via mongosh).

Can it handle permission and access issues?

Yes, it includes specialized error handling for permissions, connection failures, and resource constraints to ensure a smooth optimization process.

How does it identify which indexes to optimize?

The skill assesses current configurations, baseline metrics, and existing query patterns to identify pain points and propose indexes based on industry best practices.

What kind of outputs does the skill generate?

It produces implementation artifacts like scripts and config files, technical documentation, validation test results, and monitoring configurations such as dashboards and alerts.

Does this skill automatically apply changes to production?

No, it follows a structured safety protocol that emphasizes testing in non-production environments first and provides comprehensive rollback plans before any production deployment.

Database Index Advisor

Name: Database Index Advisor
Author: jeremylongshore

byjeremylongshore

•

983

•

Database Management

Optimizes database performance by designing and implementing efficient indexing strategies across SQL and NoSQL systems.

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.

Key Features

01Strategic index design tailored to specific query patterns and constraints

02Comprehensive monitoring setup including dashboards and alert configurations

03Structured 5-step implementation workflow for safe database changes

04983 GitHub stars

05Automated performance analysis for PostgreSQL, MySQL, and MongoDB

06Automated generation of scripts, configuration files, and runbooks

Use Cases

01Automating routine database maintenance and performance tuning across multiple environments

02Designing optimal indexing strategies for new data models during the development phase

03Identifying and resolving slow query performance issues in high-traffic applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills analyzing-database-indexes

For use in Claude.ai and ChatGPT

Download Skill

Key Features

01Strategic index design tailored to specific query patterns and constraints

02Comprehensive monitoring setup including dashboards and alert configurations

03Structured 5-step implementation workflow for safe database changes

04983 GitHub stars

05Automated performance analysis for PostgreSQL, MySQL, and MongoDB

06Automated generation of scripts, configuration files, and runbooks

Use Cases

01Automating routine database maintenance and performance tuning across multiple environments

02Designing optimal indexing strategies for new data models during the development phase

03Identifying and resolving slow query performance issues in high-traffic applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills analyzing-database-indexes

For use in Claude.ai and ChatGPT

Download Skill