🎯

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(315 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

10,291Installs

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

🎯

documentation-writer🎯Skill

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

🎯

excalidraw-diagram-generator🎯Skill

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

🎯

refactor🎯Skill

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

🎯

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.

🎯

multi-stage-dockerfile🎯Skill

Creates optimized multi-stage Dockerfiles for any language or framework, separating builder and runtime stages to produce smaller, more secure container images.

🎯

create-readme🎯Skill

Creates README.md files for projects.

🎯

memory-merger🎯Skill

Merges mature lessons from domain memory files into instruction files, consolidating knowledge with minimal redundancy across global, user, and workspace scopes.