SQL Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
Install
npx skills add rmyndharis/antigravity-skills --skill sql-optimization-patternsgit clone --depth 1 https://github.com/rmyndharis/antigravity-skills.git /tmp/antigravity-skills
mkdir -p ~/.claude/skills
cp -r /tmp/antigravity-skills/skills/sql-optimization-patterns ~/.claude/skills/sql-optimization-patternsPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# SQL Optimization Patterns Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis. ## Use this skill when - Debugging slow-running queries - Designing performant database schemas - Optimizing application response times - Reducing database load and costs - Improving scalability for growing datasets - Analyzing EXPLAIN query plans - Implementing efficient indexes - Resolving N+1 query problems ## Do not use this skill when - The task is unrelated to sql optimization patterns - You need a different domain or tool outside this scope ## Instructions - Clarify goals, constraints, and required inputs. - Apply relevant best practices and validate outcomes. - Provide actionable steps and verification. - If detailed examples are required, open `resources/implementation-playbook.md`. ## Resources - `resources/implementation-playbook.md` for detailed patterns and examples.
Details
- Skill name
sql-optimization-patterns- Repository
- rmyndharis/antigravity-skills
- Path
skills/sql-optimization-patterns/SKILL.md- License
- MIT
- Repo updated
- 7 November 2026
FAQ
What does the SQL Optimization Patterns skill do?
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
How do I install the SQL Optimization Patterns skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add rmyndharis/antigravity-skills --skill sql-optimization-patterns. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is SQL Optimization Patterns popular?
It lives in rmyndharis/antigravity-skills, which has 2,047 GitHub stars and 295 forks.
Related skills
Airflow Dag Patterns
2krmyndharis/antigravity-skills
Build production Apache Airflow DAGs with best practices for operators, sensors, testing, and deployment. Use when creating data pipelines, orchestrating workflows, or scheduling batch jobs.
Agent Orchestration Improve Agent
2krmyndharis/antigravity-skills
Systematic improvement of existing agents through performance analysis, prompt engineering, and continuous iteration.
Agent Orchestration Multi Agent Optimize
2krmyndharis/antigravity-skills
Optimize multi-agent systems with coordinated profiling, workload distribution, and cost-aware orchestration. Use when improving agent performance, throughput, or reliability.
SQL Pro
2krmyndharis/antigravity-skills
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems. Use for database optimization or complex analysis.
Database Migration
2krmyndharis/antigravity-skills
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
Vector Database Engineer
2krmyndharis/antigravity-skills
Design vector storage, indexing, and semantic retrieval with Pinecone, Weaviate, Qdrant, Milvus, or pgvector. Use when implementing RAG, similarity search, or recommendation systems.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.