Which databases are supported by this skill?

This skill provides native support for PostgreSQL (psql), MySQL (mysql), and MongoDB (mongosh) environments.

What triggers this Claude Code skill?

You can activate the skill using natural language phrases like 'optimize queries', 'analyze performance', or 'improve query speed'.

Can it help with indexing?

Yes, it identifies missing or inefficient indexes and provides the necessary scripts to implement structural improvements.

How does it safely handle database changes?

The skill follows a strict five-step process: assessment, design, non-production implementation, validation, and finally scheduled production deployment with rollback plans.

Database Query Performance Analyzer

Name: Database Query Performance Analyzer
Author: jeremylongshore

byjeremylongshore

•

896

•

データベース管理

Optimizes database performance by analyzing query execution plans and implementing automated improvements across PostgreSQL, MySQL, and MongoDB.

The Database Query Performance Analyzer skill empowers Claude Code to identify bottlenecks and latency issues within your database layer. It provides a structured framework to assess current query baselines, design optimization strategies, and safely implement changes in non-production environments first. By leveraging direct shell access to psql, mysql, and mongosh, this skill automates the performance tuning process, ensuring your application remains fast, scalable, and efficient while maintaining a comprehensive audit trail of all optimizations and configuration changes.

主な機能

01Structured optimization workflow with risk mitigation

02896 GitHub stars

03Cross-database support for PostgreSQL, MySQL, and MongoDB

04Automated generation of maintenance runbooks and dashboards

05Performance baseline comparison and validation reporting

06Automated query profiling and bottleneck identification

ユースケース

01Diagnosing and resolving slow API response times caused by inefficient database queries

02Periodic database maintenance to identify missing indexes and optimize schema performance

03Refining complex SQL queries during the development phase to ensure scalability

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills analyzing-query-performance

For use in Claude.ai and ChatGPT

Download Skill

主な機能

01Structured optimization workflow with risk mitigation

02896 GitHub stars

03Cross-database support for PostgreSQL, MySQL, and MongoDB

04Automated generation of maintenance runbooks and dashboards

05Performance baseline comparison and validation reporting

06Automated query profiling and bottleneck identification

ユースケース

01Diagnosing and resolving slow API response times caused by inefficient database queries

02Periodic database maintenance to identify missing indexes and optimize schema performance

03Refining complex SQL queries during the development phase to ensure scalability

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills analyzing-query-performance

For use in Claude.ai and ChatGPT

Download Skill