{"id":"546a6d8b-c15f-4392-8d37-ee428575322b","shortId":"RkekuK","kind":"skill","title":"postgresql-optimization","tagline":"PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.","description":"# PostgreSQL Optimization Workflow\n\n## Overview\n\nSpecialized workflow for PostgreSQL database optimization including query tuning, indexing strategies, performance analysis, vacuum management, and production database administration.\n\n## When to Use This Workflow\n\nUse this workflow when:\n- Optimizing slow PostgreSQL queries\n- Designing indexing strategies\n- Analyzing database performance\n- Tuning PostgreSQL configuration\n- Managing production databases\n\n## Workflow Phases\n\n### Phase 1: Performance Assessment\n\n#### Skills to Invoke\n- `database-optimizer` - Database optimization\n- `postgres-best-practices` - PostgreSQL best practices\n\n#### Actions\n1. Check database version\n2. Review configuration\n3. Analyze slow queries\n4. Check resource usage\n5. Identify bottlenecks\n\n#### Copy-Paste Prompts\n```\nUse @database-optimizer to assess PostgreSQL performance\n```\n\n### Phase 2: Query Analysis\n\n#### Skills to Invoke\n- `sql-optimization-patterns` - SQL optimization\n- `postgres-best-practices` - PostgreSQL patterns\n\n#### Actions\n1. Run EXPLAIN ANALYZE\n2. Identify scan types\n3. Check join strategies\n4. Analyze execution time\n5. Find optimization opportunities\n\n#### Copy-Paste Prompts\n```\nUse @sql-optimization-patterns to analyze and optimize queries\n```\n\n### Phase 3: Indexing Strategy\n\n#### Skills to Invoke\n- `database-design` - Index design\n- `postgresql` - PostgreSQL indexing\n\n#### Actions\n1. Identify missing indexes\n2. Create B-tree indexes\n3. Add composite indexes\n4. Consider partial indexes\n5. Review index usage\n\n#### Copy-Paste Prompts\n```\nUse @database-design to design PostgreSQL indexing strategy\n```\n\n### Phase 4: Query Optimization\n\n#### Skills to Invoke\n- `sql-optimization-patterns` - Query tuning\n- `sql-pro` - SQL expertise\n\n#### Actions\n1. Rewrite inefficient queries\n2. Optimize joins\n3. Add CTEs where helpful\n4. Implement pagination\n5. Test improvements\n\n#### Copy-Paste Prompts\n```\nUse @sql-optimization-patterns to optimize SQL queries\n```\n\n### Phase 5: Configuration Tuning\n\n#### Skills to Invoke\n- `postgres-best-practices` - Configuration\n- `database-admin` - Database administration\n\n#### Actions\n1. Tune shared_buffers\n2. Configure work_mem\n3. Set effective_cache_size\n4. Adjust checkpoint settings\n5. Configure autovacuum\n\n#### Copy-Paste Prompts\n```\nUse @postgres-best-practices to tune PostgreSQL configuration\n```\n\n### Phase 6: Maintenance\n\n#### Skills to Invoke\n- `database-admin` - Database maintenance\n- `postgresql` - PostgreSQL maintenance\n\n#### Actions\n1. Schedule VACUUM\n2. Run ANALYZE\n3. Check table bloat\n4. Monitor autovacuum\n5. Review statistics\n\n#### Copy-Paste Prompts\n```\nUse @database-admin to schedule PostgreSQL maintenance\n```\n\n### Phase 7: Monitoring\n\n#### Skills to Invoke\n- `grafana-dashboards` - Monitoring dashboards\n- `prometheus-configuration` - Metrics collection\n\n#### Actions\n1. Set up monitoring\n2. Create dashboards\n3. Configure alerts\n4. Track key metrics\n5. Review trends\n\n#### Copy-Paste Prompts\n```\nUse @grafana-dashboards to create PostgreSQL monitoring\n```\n\n## Optimization Checklist\n\n- [ ] Slow queries identified\n- [ ] Indexes optimized\n- [ ] Configuration tuned\n- [ ] Maintenance scheduled\n- [ ] Monitoring active\n- [ ] Performance improved\n\n## Quality Gates\n\n- [ ] Query performance improved\n- [ ] Indexes effective\n- [ ] Configuration optimized\n- [ ] Maintenance automated\n- [ ] Monitoring in place\n\n## Related Workflow Bundles\n\n- `database` - Database operations\n- `cloud-devops` - Infrastructure\n- `performance-optimization` - Performance\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":["postgresql","optimization","antigravity","awesome","skills","sickn33","agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows"],"capabilities":["skill","source-sickn33","skill-postgresql-optimization","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/postgresql-optimization","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 · 34616 github stars · SKILL.md body (3,840 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-23T00:51:24.449Z","embedding":null,"createdAt":"2026-04-18T21:42:34.112Z","updatedAt":"2026-04-23T00:51:24.449Z","lastSeenAt":"2026-04-23T00:51:24.449Z","tsv":"'1':70,89,139,189,243,292,340,385 '2':93,120,143,193,247,296,343,389 '3':96,147,174,199,250,300,346,392 '4':100,151,203,225,255,305,350,395 '5':104,155,207,258,275,309,353,399 '6':326 '7':369 'action':88,138,188,242,291,339,384 'activ':426 'add':200,251 'adjust':306 'admin':288,333,363 'administr':41,290 'alert':394 'analysi':14,35,122 'analyz':58,97,142,152,169,345 'ask':490 'assess':72,116 'autom':439 'autovacuum':311,352 'b':196 'b-tree':195 'best':83,86,134,283,319 'bloat':349 'bottleneck':106 'boundari':498 'buffer':295 'bundl':445 'cach':303 'check':90,101,148,347 'checklist':415 'checkpoint':307 'clarif':492 'clear':465 'cloud':450 'cloud-devop':449 'collect':383 'composit':201 'configur':63,95,276,285,297,310,324,381,393,421,436 'consid':204 'copi':108,160,212,262,313,357,403 'copy-past':107,159,211,261,312,356,402 'creat':194,390,411 'criteria':501 'ctes':252 'dashboard':376,378,391,409 'databas':5,17,27,40,59,66,77,79,91,113,181,217,287,289,332,334,362,446,447 'database-admin':286,331,361 'database-design':180,216 'database-optim':76,112 'describ':469 'design':55,182,184,218,220 'devop':451 'effect':302,435 'environ':481 'environment-specif':480 'execut':153 'expert':486 'expertis':241 'explain':141 'find':156 'gate':430 'grafana':375,408 'grafana-dashboard':374,407 'help':254 'identifi':105,144,190,418 'implement':256 'improv':260,428,433 'includ':29 'index':11,32,56,175,183,187,192,198,202,206,209,222,419,434 'ineffici':245 'infrastructur':452 'input':495 'invok':75,125,179,230,280,330,373 'join':149,249 'key':397 'limit':457 'mainten':327,335,338,367,423,438 'manag':18,37,64 'match':466 'mem':299 'metric':382,398 'miss':191,503 'monitor':351,370,377,388,413,425,440 'oper':448 'opportun':158 'optim':3,6,20,28,51,78,80,114,128,131,157,166,171,227,233,248,268,271,414,420,437,455 'output':475 'overview':22 'pagin':257 'partial':205 'past':109,161,213,263,314,358,404 'pattern':129,137,167,234,269 'perform':13,34,60,71,118,427,432,454,456 'performance-optim':453 'permiss':496 'phase':68,69,119,173,224,274,325,368 'place':442 'postgr':82,133,282,318 'postgres-best-practic':81,132,281,317 'postgresql':2,4,19,26,53,62,85,117,136,185,186,221,323,336,337,366,412 'postgresql-optim':1 'practic':84,87,135,284,320 'pro':239 'product':16,39,65 'prometheus':380 'prometheus-configur':379 'prompt':110,162,214,264,315,359,405 'qualiti':429 'queri':9,30,54,99,121,172,226,235,246,273,417,431 'relat':443 'requir':494 'resourc':102 'review':94,208,354,400,487 'rewrit':244 'run':140,344 'safeti':497 'scan':145 'schedul':341,365,424 'scope':468 'set':301,308,386 'share':294 'size':304 'skill':73,123,177,228,278,328,371,460 'skill-postgresql-optimization' 'slow':52,98,416 'source-sickn33' 'special':23 'specif':482 'sql':127,130,165,232,238,240,267,272 'sql-optimization-pattern':126,164,231,266 'sql-pro':237 'statist':355 'stop':488 'strategi':12,33,57,150,176,223 'substitut':478 'success':500 'tabl':348 'task':464 'test':259,484 'time':154 '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' 'track':396 'treat':473 'tree':197 'trend':401 'tune':10,31,61,236,277,293,322,422 'type':146 'usag':103,210 'use':44,47,111,163,215,265,316,360,406,458 'vacuum':36,342 'valid':483 'version':92 'work':298 'workflow':7,21,24,46,49,67,444","prices":[{"id":"29c88e75-bbc6-464a-bd02-26ef63119cd2","listingId":"546a6d8b-c15f-4392-8d37-ee428575322b","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:42:34.112Z"}],"sources":[{"listingId":"546a6d8b-c15f-4392-8d37-ee428575322b","source":"github","sourceId":"sickn33/antigravity-awesome-skills/postgresql-optimization","sourceUrl":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/postgresql-optimization","isPrimary":false,"firstSeenAt":"2026-04-18T21:42:34.112Z","lastSeenAt":"2026-04-23T00:51:24.449Z"}],"details":{"listingId":"546a6d8b-c15f-4392-8d37-ee428575322b","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"sickn33","slug":"postgresql-optimization","github":{"repo":"sickn33/antigravity-awesome-skills","stars":34616,"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":"163ee2a0511a43f901969a6bb9150d7763ccf4d3","skill_md_path":"skills/postgresql-optimization/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/postgresql-optimization"},"layout":"multi","source":"github","category":"antigravity-awesome-skills","frontmatter":{"name":"postgresql-optimization","description":"PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management."},"skills_sh_url":"https://skills.sh/sickn33/antigravity-awesome-skills/postgresql-optimization"},"updatedAt":"2026-04-23T00:51:24.449Z"}}