Vibe Index
🎯

query-optimization

🎯Skill

from pluginagentmarketplace/custom-plugin-sql

VibeIndex|
What it does

Optimizes SQL queries by analyzing execution plans, recommending indexing strategies, and improving performance across database systems.

πŸ“¦

Part of

pluginagentmarketplace/custom-plugin-sql(12 items)

query-optimization

Installation

Add MarketplaceAdd marketplace to Claude Code
/plugin marketplace add pluginagentmarketplace/custom-plugin-sql
Install PluginInstall plugin from marketplace
/plugin install custom-plugin-sql@pluginagentmarketplace-sql
git cloneClone repository
git clone https://github.com/pluginagentmarketplace/custom-plugin-sql.git
Claude CodeAdd plugin in Claude Code
/plugin load .
πŸ“– Extracted from docs: pluginagentmarketplace/custom-plugin-sql
Need more details? View full documentation on GitHub β†’
14Installs
2
-
AddedFeb 4, 2026
View on GitHubBack to Skills

Skill Details

SKILL.md

SQL query optimization and performance tuning

Overview

# 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

More from this repository10

🎯
mysql🎯Skill

mysql skill from pluginagentmarketplace/custom-plugin-sql

🎯
redis🎯Skill

redis skill from pluginagentmarketplace/custom-plugin-sql

🎯
data-warehouse🎯Skill

data-warehouse skill from pluginagentmarketplace/custom-plugin-sql

🎯
sql-fundamentals🎯Skill

sql-fundamentals skill from pluginagentmarketplace/custom-plugin-sql

🎯
transactions🎯Skill

transactions skill from pluginagentmarketplace/custom-plugin-sql

🎯
postgresql🎯Skill

Generates and optimizes PostgreSQL database queries, provides schema analysis, and assists with complex SQL development tasks.

🎯
data-analysis-sql🎯Skill

data-analysis-sql skill from pluginagentmarketplace/custom-plugin-sql

🎯
migrations🎯Skill

migrations skill from pluginagentmarketplace/custom-plugin-sql

🎯
security🎯Skill

Enforces comprehensive database security through access control, encryption, SQL injection prevention, and audit logging.

🎯
mongodb🎯Skill

Performs MongoDB database operations like querying, inserting, updating, and aggregating data with advanced filtering and optimization techniques.