What kind of output does the SQL Query Optimizer produce?

It generates implementation artifacts (scripts/code), comprehensive documentation of changes, validation test results, and monitoring configuration dashboards.

Which database systems are compatible with this skill?

The SQL Query Optimizer supports PostgreSQL (psql), MySQL (mysql), and MongoDB (mongosh) through its integrated bash tool capabilities.

How does this skill ensure safe database changes?

It follows a strict five-step process that mandates assessment, non-production testing, monitoring setup, and the creation of rollback procedures before any production deployment.

Can this skill help with indexing strategies?

Yes, it analyzes existing schemas and query patterns to suggest optimal indexing strategies that can significantly reduce data retrieval times.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: BbgnsurfTech

byBbgnsurfTech

•

データベース管理

Analyzes and optimizes database queries to improve performance, reduce latency, and minimize resource consumption across SQL and NoSQL systems.

The SQL Query Optimizer skill provides Claude with a structured framework to diagnose and resolve database performance bottlenecks. It enables automated query analysis, indexing strategy suggestions, and execution plan optimization for PostgreSQL, MySQL, and MongoDB. By following a rigorous five-step workflow—from initial assessment to production deployment—this skill ensures that database changes are implemented safely, validated against performance baselines, and documented thoroughly to prevent regressions and improve overall application scalability.

主な機能

01Multi-database support including PostgreSQL, MySQL, and MongoDB (mongosh)

021 GitHub stars

03Structured implementation workflow with built-in rollback and recovery planning

04Comprehensive query performance analysis and bottleneck identification

05Automated refactoring of inefficient queries based on best practices

06Post-optimization validation through metric comparison and test results

ユースケース

01Optimizing database resource usage to reduce cloud infrastructure costs

02Identifying and fixing slow-running queries that cause application timeouts

03Modernizing legacy database schemas and query patterns for better scalability

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection sql-query-optimizer

For use in Claude.ai and ChatGPT

Download Skill