Manage Apple Reminders via the `remindctl` CLI on macOS (list, add, edit, complete, delete)....
query-optimization
2
0
# Install this skill:
npx skills add pluginagentmarketplace/custom-plugin-sql --skill "query-optimization"
Install specific skill from multi-skill repository
# Description
SQL query optimization and performance tuning
# 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
# Related Skills
Query Google Places API (New) via the goplaces CLI for text search, place details, resolve, and...
Notion API for creating and managing pages, databases, and blocks.
Manage Things 3 via the `things` CLI on macOS (add/update projects+todos via URL scheme;...
# Supported AI Coding Agents
This skill is compatible with the SKILL.md standard and works with all major AI coding agents:
Amp
Antigravity
Claude Code
Clawdbot
Codex
Cursor
Droid
Gemini CLI
GitHub Copilot
Goose
Kilo Code
Kiro CLI
OpenCode
Roo Code
Trae
Windsurf
Learn more about the SKILL.md standard and how to use these skills with your preferred AI coding agent.