Can this skill automatically apply changes to my production database?

While the skill automates implementation, it follows a structured five-step process that mandates non-production validation and risk assessment before any production deployment.

Which databases are supported by this skill?

This skill provides specialized support for PostgreSQL, MySQL, and MongoDB through integrated bash tool access (psql, mysql, and mongosh).

Does this skill provide observability tools?

Yes, it generates monitoring configurations, dashboard templates (JSON), and alert setup procedures to ensure long-term performance visibility.

How do I start a performance analysis session?

You can trigger the skill by asking Claude to 'optimize queries', 'analyze performance', or 'improve query speed' within your project directory.

Does it handle error recovery?

Yes, the skill includes built-in protocols for handling permission issues, network failures, and resource constraints, including the preparation of detailed rollback plans.

Database Query Performance Analyzer

Name: Database Query Performance Analyzer
Author: Brmbobo

byBrmbobo

0•

Database Management

Optimizes database performance by analyzing queries, identifying bottlenecks, and automating structural improvements across SQL and NoSQL environments.

The Database Query Performance Analyzer is a comprehensive Claude Code skill designed to streamline the optimization of database interactions. It automates the end-to-end process of identifying slow queries, designing performance-improving solutions, and implementing changes safely across multiple environments. By providing structured analysis for PostgreSQL, MySQL, and MongoDB, this skill helps developers improve application response times and reduce infrastructure overhead through data-driven query tuning, automated indexing recommendations, and production-ready implementation workflows.

Key Features

01Automated creation of monitoring dashboards and observability configurations

02Generation of optimized implementation plans and indexing strategies

03Identification of execution bottlenecks and baseline metric benchmarking

040 GitHub stars

05Automated performance analysis for PostgreSQL, MySQL, and MongoDB queries

06Safe deployment workflows including non-production validation and rollback planning

Use Cases

01Diagnosing and fixing slow-running database queries in production environments

02Automating the design and testing of new database indexes for better performance

03Establishing observability and performance guardrails for database-heavy applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add brmbobo/web2podcast analyzing-query-performance

For use in Claude.ai and ChatGPT

Download Skill