Agent skill
query-optimization
SQL query optimization and performance tuning
Install this agent skill to your Project
npx add-skill https://github.com/pluginagentmarketplace/custom-plugin-sql/tree/main/skills/query-optimization
SKILL.md
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
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
pluginagentmarketplace/custom-plugin-sql
migrations
Database schema migrations and version control
pluginagentmarketplace/custom-plugin-sql
sql-fundamentals
Master SQL fundamentals including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations. Learn data types, WHERE clauses, ORDER BY, GROUP BY, and basic joins.
pluginagentmarketplace/custom-plugin-sql
redis
Redis data structures and commands including strings, lists, hashes, sets, sorted sets, streams, and transactions for high-performance caching and real-time applications.
pluginagentmarketplace/custom-plugin-sql
data-warehouse
Data warehouse design mastery with star schema, dimensional modeling, fact/dimension tables, slowly changing dimensions, and enterprise best practices. Complete schema examples included.
pluginagentmarketplace/custom-plugin-sql
transactions
Database transactions, ACID properties, and concurrency control
pluginagentmarketplace/custom-plugin-sql
mongodb
MongoDB fundamentals including document model, CRUD operations, querying, indexing, and aggregation framework for NoSQL database applications.
Didn't find tool you were looking for?