🎯

sql-optimization

🎯Skill

from github/awesome-copilot

What it does

Optimizes SQL query performance across all databases with indexing strategies, query tuning, and execution plan analysis.

Overview

This skill provides universal SQL performance optimization guidance across MySQL, PostgreSQL, SQL Server, Oracle, and other SQL databases. It covers query performance analysis, indexing strategies, subquery optimization, pagination, batch operations, and execution plan analysis to systematically improve database performance.

Key Features

Query Performance Analysis - Identifies inefficient patterns like SELECT *, function calls in WHERE clauses, and correlated subqueries, replacing them with optimized alternatives using proper joins and indexed columns
Index Strategy Optimization - Guides creation of targeted composite indexes, partial indexes, and covering indexes aligned with actual query patterns rather than blanket indexing
Execution Plan Analysis - Teaches how to read and interpret execution plans to identify table scans, missing indexes, and inefficient join strategies
Pagination & Batch Operations - Optimizes large result set handling with keyset pagination and efficient batch insert/update patterns
Cross-Database Compatibility - Provides optimization techniques that work universally across major SQL database platforms

Who is this for?

Database administrators, backend developers, and data engineers working with SQL databases who need to diagnose and resolve query performance bottlenecks. Ideal for teams managing growing datasets where query response times are critical and systematic optimization approaches are needed.

📦

Same repository

github/awesome-copilot(224 items)

sql-optimization

Installation

Vibe Index InstallInstalls to .claude/skills/ - auto-recognized by Claude Code

npx vibeindex add github/awesome-copilot --skill sql-optimization

skills.sh Install⚠ Installs to .agents/skills/ - may not be auto-recognized by Claude Code

npx skills add github/awesome-copilot --skill sql-optimization

Manual InstallCopy SKILL.md content and save to the path below

~/.claude/skills/sql-optimization/SKILL.md

SKILL.md

7,064Installs

AddedFeb 25, 2026

View on GitHub Back to Skills

More from this repository10

🎯

git-commit🎯Skill

A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.

🎯

gh-cli🎯Skill

A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.

🎯

prd🎯Skill

Generates comprehensive Product Requirements Documents (PRDs) by systematically analyzing requirements and crafting detailed technical specifications

🎯

refactor🎯Skill

A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.

🎯

excalidraw-diagram-generator🎯Skill

Generates Excalidraw diagrams from natural language descriptions, creating visual representations of processes, systems, relationships, and ideas.

🎯

documentation-writer🎯Skill

Expert technical writer guided by the Diataxis framework, creating tutorials, how-to guides, reference docs, and explanation pages for software documentation.

🎯

chrome-devtools🎯Skill

Automates browser interactions, debugging, and performance analysis using Chrome DevTools for comprehensive web page inspection and control.

🎯

java-springboot🎯Skill

Provides Spring Boot best practices covering project setup, dependency injection, REST API design, data access with JPA, security configuration, and testing strategies.

🎯

web-design-reviewer🎯Skill

A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.

🎯

github-issues🎯Skill

Manages GitHub Issues through the GitHub API, enabling creation, searching, labeling, and triaging of issues directly from the coding environment.