How does the skill ensure database safety during optimization?

The skill enforces a strict five-step process including baseline assessment, non-production testing, mandatory backups, and the creation of detailed rollback plans before any changes are applied.

Does it provide documentation for the changes made?

Absolutely. It produces comprehensive implementation artifacts, test results, and operational runbooks documenting every change and decision made during the process.

Which database systems does this skill support?

It supports popular relational and non-relational databases including PostgreSQL, MySQL, and MongoDB using native CLI tools like psql, mysql, and mongosh.

Can this skill help with database monitoring?

Yes, it generates monitoring configurations, dashboards, and alerts to provide ongoing observability of query performance and resource usage.

Do I need to provide specific credentials?

Yes, you must ensure Claude has the required permissions and credentials to execute shell commands for the specific database tools you intend to optimize.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: Brmbobo

byBrmbobo

0•

データベース管理

Analyzes and improves database query performance through automated assessment, implementation, and monitoring of SQL execution plans.

This specialized skill enables Claude to handle complex database performance tuning across PostgreSQL, MySQL, and MongoDB. It guides users through a systematic optimization lifecycle—from identifying bottlenecks and analyzing baseline metrics to implementing structural changes and configuring real-time monitoring. By automating best practices in query design and infrastructure scaling, it ensures high-performance data operations while minimizing risks through robust validation and rollback procedures.

主な機能

01Structured deployment workflow with staging validation

02Automated query plan analysis and bottleneck identification

03Monitoring and observability dashboard configuration

04Cross-platform support for PostgreSQL, MySQL, and MongoDB

05Runbook and operational documentation generation

060 GitHub stars

ユースケース

01Establishing performance baselines and real-time alerts

02Optimizing slow legacy queries to reduce application latency

03Automating database indexing and schema refactoring

主な機能

01Structured deployment workflow with staging validation

02Automated query plan analysis and bottleneck identification

03Monitoring and observability dashboard configuration

04Cross-platform support for PostgreSQL, MySQL, and MongoDB

05Runbook and operational documentation generation

060 GitHub stars

ユースケース

01Establishing performance baselines and real-time alerts

02Optimizing slow legacy queries to reduce application latency

03Automating database indexing and schema refactoring