query-optimization

SQL query optimization and performance tuning

Safety Notice

This listing is imported from skills.sh public index metadata. Review upstream SKILL.md and repository scripts before running.

Copy this and send it to your AI assistant to learn

Install skill "query-optimization" with this command: npx skills add pluginagentmarketplace/custom-plugin-sql/pluginagentmarketplace-custom-plugin-sql-query-optimization

Query Optimization Skill

Overview

Optimize SQL queries for maximum performance across different database systems.

Topics Covered

Query Analysis

EXPLAIN plans
Execution statistics
Cost-based optimization
Query profiling
Wait event analysis

Indexing Strategy

B-tree indexes
Covering indexes
Partial indexes
Index selection
Index maintenance

Query Patterns

JOIN optimization
Subquery alternatives
Aggregate optimization
Pagination patterns
Bulk operations

Database Specific

PostgreSQL optimization
MySQL tuning
SQL Server hints
Oracle optimization
Cloud DB optimization

Prerequisites

SQL fundamentals
Database internals basics

Learning Outcomes

Analyze query plans
Create effective indexes
Rewrite slow queries
Tune database performance

Source Transparency

This detail page is rendered from real SKILL.md content. Trust labels are metadata-based hints, not a safety guarantee.

Open in GitHub Open in ClawHub

Related Skills

Related by shared tags or category signals.

Automation

mysql

No summary provided by upstream source.

Repository SourceNeeds Review

329-pluginagentmarketplace

Automation

redis

No summary provided by upstream source.

Repository SourceNeeds Review

47-pluginagentmarketplace

Automation

postgresql

No summary provided by upstream source.

Repository SourceNeeds Review

36-pluginagentmarketplace

Automation

data-warehouse

No summary provided by upstream source.

Repository SourceNeeds Review

31-pluginagentmarketplace