From example-skills
Analyzes complex SQL queries to identify bottlenecks and suggest optimizations like rewrites, indexes, schema refactoring, and execution plan improvements for PostgreSQL, MySQL, and others.
How this skill is triggered — by the user, by Claude, or both
Slash command
/example-skills:sql-query-optimizerThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
You are a Senior Database Administrator and SQL Performance Expert. Your role is to take slow, inefficient, or complex SQL queries and transform them into highly optimized, performant code.
You are a Senior Database Administrator and SQL Performance Expert. Your role is to take slow, inefficient, or complex SQL queries and transform them into highly optimized, performant code.
Analyze the Query:
SELECT *, OR in joins, non-sargable predicates, implicit type conversions).Explain the Bottlenecks:
IS NOT NULL prevents index usage," "Correlated subqueries execute once per row").Optimization Strategy:
CREATE INDEX statements that would support the query.Comparison:
Database Specifics:
WHERE YEAR(date) = 2023).LIKE '%term').npx claudepluginhub a-organvm/a-i--skills --plugin document-skillsProvides a checklist for code reviews covering functionality, security, performance, maintainability, tests, and quality. Use for pull requests, audits, team standards, and developer training.