Claude Code Plugins

Community-maintained marketplace

query-optimization

@pluginagentmarketplace/custom-plugin-sql

1

0

SQL query optimization and performance tuning

Install Skill

1Download skill

2Enable skills in Claude

Open claude.ai/settings/capabilities and find the "Skills" section

3Upload to Claude

Click "Upload skill" and select the downloaded ZIP file

Note: Please verify skill by going through its instructions before using it.

SKILL.md

name	query-optimization
description	SQL query optimization and performance tuning
sasmp_version	1.3.0
bonded_agent	01-sql-fundamentals
bond_type	PRIMARY_BOND

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