Which database engines does this skill support?

The Query Performance Analyzer supports major database systems including PostgreSQL, MySQL, and MongoDB using standard shell utilities like psql, mysql, and mongosh.

Does this skill provide safety measures for production changes?

Yes, it follows a strict protocol including prerequisite validation, non-production testing, rollback plan creation, and real-time monitoring during deployment.

How do I trigger the performance analysis?

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

What kind of outputs does the skill generate?

It produces implementation artifacts like scripts and config files, detailed documentation, test results, and monitoring configurations such as dashboard JSON files.

Query Performance Analyzer

Name: Query Performance Analyzer
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

Optimizes database query performance using automated analysis and structured implementation workflows for SQL and NoSQL systems.

The Query Performance Analyzer is a specialized Claude Code skill designed to identify bottlenecks and enhance the efficiency of database operations. It provides a rigorous five-step framework for assessing query health, designing optimization strategies, and safely implementing changes across PostgreSQL, MySQL, and MongoDB environments. By integrating deep performance diagnostics with automated monitoring and rollback procedures, this skill helps developers eliminate slow-running queries and ensure high-scale database reliability.

Key Features

01Built-in error handling for permissions, connectivity, and resource constraints

023 GitHub stars

03Comprehensive query analysis for PostgreSQL, MySQL, and MongoDB

04Structured optimization workflow from baseline assessment to production deployment

05Automated generation of implementation scripts and configuration files

06Customizable monitoring dashboards and observability alerts

Use Cases

01Identifying and refactoring slow-running SQL queries in production environments

02Benchmarking database latency and throughput during architectural migrations

03Automating the deployment of performance-tuning indexes and configurations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection query-performance-analyzer

For use in Claude.ai and ChatGPT

Download Skill