sql-optimization — Skills — getagentictools

What it does

[ ] Avoiding SELECT in production queries

[ ] Using appropriate JOIN types (INNER vs LEFT/RIGHT)

[ ] Filtering early in WHERE clauses

[ ] Using EXISTS instead of IN for subqueries when appropriate

[ ] Avoiding functions in WHERE clauses that prevent index usage

[ ] Creating indexes on frequently queried columns

[ ] Using composite indexes in the right column order

Universal SQL performance optimization across MySQL, PostgreSQL, SQL Server, Oracle, and other databases.

Source

Repository: https://github.com/github/awesome-copilot

sql-optimization FAQ

What does the sql-optimization skill do?

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance. [ ] Avoiding SELECT in production queries [ ] Using appropriate JOIN types (INNER vs LEFT/RIGHT)

How do I install sql-optimization?

Run: npx -y skills add https://github.com/github/awesome-copilot --skill sql-optimization --agent claude-code — the source lives at github.com/github/awesome-copilot.

Maintain sql-optimization?

Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.

[![sql-optimization on getagentictools](https://getagentictools.com/badge/skills/github-awesome-copilot-sql-optimization.svg)](https://getagentictools.com/skills/github-awesome-copilot-sql-optimization?ref=badge)

npx agentictools info skills/github-awesome-copilot-sql-optimization

The second line is the CLI lookup for this page — handy in READMEs and docs.