
SQL optimization
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis acro
- Scripts
- None
- Platforms
- Claude Code, Codex, Cursor
- GitHub stars
- 41.3K
- Last commit
- 1 day ago
- License
- MIT
- Listing updated
- today
When your agent uses it
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.
From the skill's SKILL.md. Your agent reads this description to decide when to load the skill.
What it can access
From a static check of its 1 file (9 KB) on GitHub on 17 November 2026. Nothing was run. Read the files before you install a skill: it can tell your agent to run anything its tools allow.
Install
Copy the skill folder to ~/.claude/skills/sql-optimization to use it in all your projects:
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.claude/skills &&
rm -rf ~/.claude/skills/sql-optimization &&
cp -R "$tmp/skills/sql-optimization" ~/.claude/skills/sql-optimization &&
rm -rf "$tmp"For one project only, put the folder in .claude/skills/sql-optimization inside it instead.
Copy the skill folder to ~/.agents/skills/sql-optimization to use it in every repository:
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.agents/skills &&
rm -rf ~/.agents/skills/sql-optimization &&
cp -R "$tmp/skills/sql-optimization" ~/.agents/skills/sql-optimization &&
rm -rf "$tmp"For one repository only, put the folder in .agents/skills/sql-optimization inside it instead.
Copy the skill folder to ~/.cursor/skills/sql-optimization to use it in every project:
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.cursor/skills &&
rm -rf ~/.cursor/skills/sql-optimization &&
cp -R "$tmp/skills/sql-optimization" ~/.cursor/skills/sql-optimization &&
rm -rf "$tmp"For one project only, put the folder in .cursor/skills/sql-optimization inside it instead.
Run in a terminal (add --scope workspace to install it for the current workspace only):
gemini skills install https://github.com/github/awesome-copilot.git --path skills/sql-optimizationOr copy the folder to ~/.gemini/skills/sql-optimization yourself.
For GitHub Copilot in VS Code, copy the skill folder to ~/.copilot/skills/sql-optimization:
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.copilot/skills &&
rm -rf ~/.copilot/skills/sql-optimization &&
cp -R "$tmp/skills/sql-optimization" ~/.copilot/skills/sql-optimization &&
rm -rf "$tmp"For one project only, put the folder in .github/skills/sql-optimization inside it instead.
Get the folder:
git clone --depth 1 https://github.com/github/awesome-copilot.gitThen copy awesome-copilot/skills/sql-optimization into your agent's skills folder as sql-optimization. Agents that support SKILL.md read one folder per skill.
SQL optimization FAQ
How do I install SQL optimization in Claude Code?
Copy the skill folder from GitHub to ~/.claude/skills/sql-optimization to use it in all your projects, or to .claude/skills/sql-optimization in one project.
Does SQL optimization run scripts?
No. It is instructions only, with no scripts. This comes from a static check of the files on GitHub; nothing was run. Read the files before you install it.
Which AI agents can use SQL optimization?
Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose. Each reads skills in the SKILL.md format from its own folder; the install steps on this page list them.
What are the best alternatives to SQL optimization?
The closest alternatives to SQL optimization are Pinecone rag, Migrating oracle to postgres stored procedures, Creating oracle to postgres migration integration tests, Postgresql optimization and Bigquery pipeline audit.
More from github/awesome-copilot

Design or review infrastructure, deployment, CI/CD, Docker, Kubernetes, health checks, rollback, feature flags, production readiness, and mo
- Open source
- 41.3K GitHub stars
- Cloud and infrastructure


Cross-references C# Web API controllers/DTOs against their TypeScript/JavaScript consumers (React, Angular, Vue, Svelte, Node.js, or hand-wr
- Open source
- 41.3K GitHub stars

Instrument a webapp to send useful telemetry data to Azure App Insights
- Open source
- 41.3K GitHub stars

Serves as a reviewer of the codebase with instructions on looking for Apple App Store optimizations or rejection reasons.
- Open source
- 41.3K GitHub stars

Triage and resolve Arch Linux issues with pacman, systemd, and rolling-release best practices.
- Open source
- 41.3K GitHub stars
Alternatives to SQL optimization

Pinecone rag
SkillBuild production RAG pipelines and persistent agent memory using Pinecone as the vector database backend
- Open source
- 41.3K GitHub stars
- Knowledge and memory

Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL
- Open source
- 41.3K GitHub stars
- Databases

Creates integration test cases targeting Oracle for .NET data access artifacts
- Open source
- 41.3K GitHub stars
- Databases

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities
- Open source
- 41.3K GitHub stars
- Databases

Audits Python + BigQuery pipelines for cost safety, idempotency, and production readiness
- Open source
- 41.3K GitHub stars
- Databases

Use when: comparing SQL Server tables across instances, data migration validation, ETL verification, row mismatch detection, schema drift, r
- Open source
- 41.3K GitHub stars
- Databases
