Does it offer guidance on indexing strategy?

Absolutely. It covers complex indexing scenarios including composite indexes, partial indexes for filtered data, and covering indexes to improve data retrieval speeds.

Can this skill help with batch processing performance?

Yes, it includes optimized patterns for bulk inserts and updates to reduce network round trips and improve transaction throughput in high-volume environments.

Does this skill support both PostgreSQL and MySQL?

Yes, it provides specific optimization techniques, query syntax, and performance monitoring commands tailored for both PostgreSQL and MySQL database systems.

How does this skill help identify slow queries?

It provides a structured framework to analyze query plans using EXPLAIN ANALYZE, identifies missing indexes, and suggests specific rewriting patterns to minimize execution time.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: aj-geddes

byaj-geddes

•

데이터베이스 관리

Analyzes and optimizes SQL queries for PostgreSQL and MySQL to improve performance and reduce execution time.

The SQL Query Optimization skill provides a comprehensive framework for identifying and resolving performance bottlenecks in relational database systems. It equips developers with specialized strategies for analyzing query execution plans, implementing advanced indexing techniques like partial and covering indexes, and refactoring inefficient SQL patterns into performant code. Whether you are dealing with slow-running joins, complex aggregations, or high-volume bulk operations, this skill helps you establish performance baselines and maintain highly responsive database architectures through proven optimization methodologies.

주요 기능

01Advanced indexing strategies including composite, partial, and covering indexes.

02Performance monitoring techniques for identifying slow-running queries.

03Automated query plan analysis for PostgreSQL and MySQL using EXPLAIN.

04Query rewriting patterns for window functions and join optimization.

05Bulk operation patterns to reduce network round trips and overhead.

0618 GitHub stars

사용 사례

01Designing efficient indexing strategies for high-traffic database tables.

02Analyzing and fixing performance bottlenecks in complex analytical joins.

03Refactoring slow-running legacy queries to reduce server latency.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add aj-geddes/useful-ai-prompts sql-query-optimization

For use in Claude.ai and ChatGPT

Download Skill