Can it help with slow query performance?

Yes, the skill is specifically designed to analyze query patterns and recommend indexes that significantly improve execution speed and reduce resource usage.

Which databases are supported by this skill?

The skill supports PostgreSQL (psql), MySQL (mysql), and MongoDB (mongosh) through integrated bash tool access.

What kind of artifacts does this skill produce?

It produces implementation scripts, comprehensive documentation of changes, test validation reports, and monitoring configuration dashboards.

Does it automatically apply changes to production?

No, the skill follows a safety-first structured process that requires testing in non-production environments and manual validation before final production deployment.

Database Index Advisor

Name: Database Index Advisor
Author: Brmbobo

byBrmbobo

0•

Gestión de Bases de Datos

Optimizes database performance by designing, implementing, and validating efficient indexing strategies for SQL and NoSQL systems.

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.

Características Principales

01Automated analysis of current database indexing and query performance benchmarks

020 GitHub stars

03Integrated error handling for permissions, network issues, and resource constraints

04Generation of production-ready migration scripts and monitoring dashboards

05End-to-end implementation workflow including risk assessment and staging validation

06Cross-platform support for PostgreSQL, MySQL, and MongoDB via native shell tools

Casos de Uso

01Optimizing slow-running queries in large-scale production databases

02Auditing existing schemas to remove redundant indexes and reduce storage overhead

03Designing efficient indexing strategies for new data models during the development phase

Características Principales

01Automated analysis of current database indexing and query performance benchmarks

020 GitHub stars

03Integrated error handling for permissions, network issues, and resource constraints

04Generation of production-ready migration scripts and monitoring dashboards

05End-to-end implementation workflow including risk assessment and staging validation

06Cross-platform support for PostgreSQL, MySQL, and MongoDB via native shell tools

Casos de Uso

01Optimizing slow-running queries in large-scale production databases

02Auditing existing schemas to remove redundant indexes and reduce storage overhead

03Designing efficient indexing strategies for new data models during the development phase