{"id":"9366e4dc-b9e6-4ff9-8463-bc3c51a31951","shortId":"9MBHjU","kind":"skill","title":"sql-optimization-patterns","tagline":"Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.","description":"# SQL Optimization Patterns\n\nTransform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.\n\n## Use this skill when\n\n- Debugging slow-running queries\n- Designing performant database schemas\n- Optimizing application response times\n- Reducing database load and costs\n- Improving scalability for growing datasets\n- Analyzing EXPLAIN query plans\n- Implementing efficient indexes\n- Resolving N+1 query problems\n\n## Do not use this skill when\n\n- The task is unrelated to sql optimization patterns\n- You need a different domain or tool outside this scope\n\n## Instructions\n\n- Clarify goals, constraints, and required inputs.\n- Apply relevant best practices and validate outcomes.\n- Provide actionable steps and verification.\n- If detailed examples are required, open `resources/implementation-playbook.md`.\n\n## Resources\n\n- `resources/implementation-playbook.md` for detailed patterns and examples.\n\n## Limitations\n- Use this skill only when the task clearly matches the scope described above.\n- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.\n- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.","tags":["sql","optimization","patterns","antigravity","awesome","skills","sickn33","agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding"],"capabilities":["skill","source-sickn33","skill-sql-optimization-patterns","topic-agent-skills","topic-agentic-skills","topic-ai-agent-skills","topic-ai-agents","topic-ai-coding","topic-ai-workflows","topic-antigravity","topic-antigravity-skills","topic-claude-code","topic-claude-code-skills","topic-codex-cli","topic-codex-skills"],"categories":["antigravity-awesome-skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/sickn33/antigravity-awesome-skills/sql-optimization-patterns","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add sickn33/antigravity-awesome-skills","source_repo":"https://github.com/sickn33/antigravity-awesome-skills","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 34515 github stars · SKILL.md body (1,284 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-04-22T12:51:49.297Z","embedding":null,"createdAt":"2026-04-18T21:45:20.290Z","updatedAt":"2026-04-22T12:51:49.297Z","lastSeenAt":"2026-04-22T12:51:49.297Z","tsv":"'+1':80 'action':122 'analysi':22,43 'analyz':71 'appli':114 'applic':58 'ask':173 'best':116 'boundari':181 'clarif':175 'clarifi':108 'clear':148 'constraint':110 'cost':65 'criteria':184 'databas':7,28,55,62 'dataset':70 'debug':48 'describ':152 'design':53 'detail':127,136 'differ':100 'domain':101 'effici':76 'environ':164 'environment-specif':163 'exampl':128,139 'expert':169 'explain':72 'fast':12,33 'goal':109 'grow':69 'implement':75 'improv':66 'index':18,39,77 'input':113,178 'instruct':107 'lightn':11,32 'lightning-fast':10,31 'limit':140 'load':63 'match':149 'miss':186 'n':79 'need':98 'open':131 'oper':13,34 'optim':3,16,24,37,57,95 'outcom':120 'output':158 'outsid':104 'pattern':4,25,96,137 'perform':54 'permiss':179 'plan':21,42,74 'practic':117 'problem':82 'proper':17,38 'provid':121 'queri':8,20,29,41,52,73,81 'reduc':61 'relev':115 'requir':112,130,177 'resolv':78 'resourc':133 'resources/implementation-playbook.md':132,134 'respons':59 'review':170 'run':51 'safeti':180 'scalabl':67 'schema':56 'scope':106,151 'skill':46,87,143 'skill-sql-optimization-patterns' 'slow':6,27,50 'slow-run':49 'source-sickn33' 'specif':165 'sql':2,23,94 'sql-optimization-pattern':1 'step':123 'stop':171 'substitut':161 'success':183 'systemat':15,36 'task':90,147 'test':167 'time':60 'tool':103 'topic-agent-skills' 'topic-agentic-skills' 'topic-ai-agent-skills' 'topic-ai-agents' 'topic-ai-coding' 'topic-ai-workflows' 'topic-antigravity' 'topic-antigravity-skills' 'topic-claude-code' 'topic-claude-code-skills' 'topic-codex-cli' 'topic-codex-skills' 'transform':5,26 'treat':156 'unrel':92 'use':44,85,141 'valid':119,166 'verif':125","prices":[{"id":"33c65eef-d4fa-403e-99ff-5c04db864b7f","listingId":"9366e4dc-b9e6-4ff9-8463-bc3c51a31951","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"sickn33","category":"antigravity-awesome-skills","install_from":"skills.sh"},"createdAt":"2026-04-18T21:45:20.290Z"}],"sources":[{"listingId":"9366e4dc-b9e6-4ff9-8463-bc3c51a31951","source":"github","sourceId":"sickn33/antigravity-awesome-skills/sql-optimization-patterns","sourceUrl":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/sql-optimization-patterns","isPrimary":false,"firstSeenAt":"2026-04-18T21:45:20.290Z","lastSeenAt":"2026-04-22T12:51:49.297Z"}],"details":{"listingId":"9366e4dc-b9e6-4ff9-8463-bc3c51a31951","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"sickn33","slug":"sql-optimization-patterns","github":{"repo":"sickn33/antigravity-awesome-skills","stars":34515,"topics":["agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows","antigravity","antigravity-skills","claude-code","claude-code-skills","codex-cli","codex-skills","cursor","cursor-skills","developer-tools","gemini-cli","gemini-skills","kiro","mcp","skill-library"],"license":"mit","html_url":"https://github.com/sickn33/antigravity-awesome-skills","pushed_at":"2026-04-22T06:40:00Z","description":"Installable GitHub library of 1,400+ agentic skills for Claude Code, Cursor, Codex CLI, Gemini CLI, Antigravity, and more. Includes installer CLI, bundles, workflows, and official/community skill collections.","skill_md_sha":"ecb1f6d0a49a39d4fec759e01c98f967b00b966e","skill_md_path":"skills/sql-optimization-patterns/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/sql-optimization-patterns"},"layout":"multi","source":"github","category":"antigravity-awesome-skills","frontmatter":{"name":"sql-optimization-patterns","description":"Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis."},"skills_sh_url":"https://skills.sh/sickn33/antigravity-awesome-skills/sql-optimization-patterns"},"updatedAt":"2026-04-22T12:51:49.297Z"}}