Sql Optimization Patterns
This is your systematic approach to fixing slow queries and designing databases that don't fall over under load. It walks you through analyzing EXPLAIN plans, adding the right indexes, and killing N+1 queries before they murder your API response times. The implementation playbook gives you concrete patterns to follow rather than vague advice. Honestly, this is most valuable when you're already neck-deep in performance problems or designing a schema that needs to scale. It won't magically teach you SQL from scratch, but if you know your way around queries and need to make them faster, it gives you a structured method instead of just throwing indexes at the wall.
- skills.sh installs
- 334
- GitHub stars
- 39.4K
- last updated
- Jun 3, 2026
Install
$ npx -y skills add sickn33/antigravity-awesome-skills --skill sql-optimization-patterns --agent claude-codeInstalls into .claude/skills of the current project.
Files
SQL Optimization Patterns
Diagnose slow SQL with query plans, preserve query results, and verify indexing or query changes against representative data.
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
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/sickn33/antigravity-awesome-skills
- Category
- Databases
- First seen
- Jun 3, 2026
More from sickn33/antigravity-awesome-skills
All 708- Tdd Orchestrator334
- C4 Architecture C4 Architecture333
- Voice Ai Engine Development332
- Data Storytelling328
- Django Pro328
- Seo Authority Builder327
- Conductor Status325
- Dotnet Architect325
- Kpi Dashboard Design324
- Dotnet Backend323
- Csharp Pro322
- Langchain Architecture322
- Internal Comms Anthropic321
- Database Cloud Optimization Cost Optimize320
- Bash Defensive Patterns319
- Comprehensive Review Full Review319
- Error Debugging Multi Agent Review319
- Computer Vision Expert317
- Context Management Context Save317
- Data Engineering Data Driven Feature317
- Error Debugging Error Analysis317
- Deployment Engineer314
- Uv Package Manager314
- Ml Engineer312
Recommended
More Databases
bun-redissecondsky/claude-skillsUse when working with Redis in Bun (ioredis, Upstash), caching, pub/sub, session storage, or key-value operations.328skills.sh installs
alphafold-databasedavila7/claude-code-templatesAccess AlphaFold's 200M+ AI-predicted protein structures. Retrieve structures by UniProt ID, download PDB/mmCIF files, analyze confidence metrics (pLDDT, PAE), 326skills.sh installs
streamlit-snowflakejezweb/claude-skillsBuild and deploy Streamlit apps natively in Snowflake. Covers snowflake.yml scaffolding, Snowpark sessions, multi-page structure, Marketplace publishing as Nati320skills.sh installs
database-cloud-optimization-cost-optimizesickn33/antigravity-awesome-skillsdatabase cloud optimization cost optimize320skills.sh installs
supabase-authnice-wolf-studio/claude-code-supabase-skillsManage authentication and user operations in Supabase. Use for sign up, sign in, sign out, password resets, and user management.318skills.sh installsfda-databasedavila7/claude-code-templatesQuery openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data anal313skills.sh installs