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.

主な機能

Structured optimization workflow with risk mitigation
896 GitHub stars
Cross-database support for PostgreSQL, MySQL, and MongoDB
Automated generation of maintenance runbooks and dashboards
Performance baseline comparison and validation reporting
Automated query profiling and bottleneck identification

ユースケース

Diagnosing and resolving slow API response times caused by inefficient database queries
Periodic database maintenance to identify missing indexes and optimize schema performance
Refining 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

GitHub

概要