{"id":"39995554-e613-4077-bc3b-a61e9c67ff2c","shortId":"HSkkZG","kind":"skill","title":"PostgreSQL Slow Query Runbook","tagline":"Diagnoses PostgreSQL slow queries using pg_stat_statements extension, EXPLAIN ANALYZE output parsing, and pg_stat_user_indexes for index usage analysis. Identifies missing indexes, sequential scan bottlenecks, and lock contention issues.","description":"# PostgreSQL Slow Query Runbook\n\nDiagnoses PostgreSQL slow queries using pg_stat_statements extension, EXPLAIN ANALYZE output parsing, and pg_stat_user_indexes for index usage analysis. Identifies missing indexes, sequential scan bottlenecks, and lock contention issues.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- npm install pg\n- From your workspace root run yarn and then yarn lerna bootstrap\n- Run yarn test to run all the tests.\n\nRequirements and caveats from upstream:\n- # node-postgres\n- ![Build Status](https://github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)\n- Non-blocking PostgreSQL client for Node.js. Pure JavaScript and optional native libpq bindings.\n\nBasic usage or getting-started notes:\n- ## Documentation\n- Each package in this repo should have its own readme more focused on how to develop/contribute. For overall documentation on the project and the related modules managed by this repo please see:\n- ### Features\n\n- Source: https://github.com/brianc/node-postgres\n- Extracted from upstream docs: https://raw.githubusercontent.com/brianc/node-postgres/HEAD/README.md\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/postgresql-slow-query-runbook-agent/)","tags":["postgresql","slow","query","runbook","agent","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-slow-query-runbook-agent","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/postgresql-slow-query-runbook-agent","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,265 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-05-18T19:11:50.426Z","embedding":null,"createdAt":"2026-05-18T13:18:29.590Z","updatedAt":"2026-05-18T19:11:50.426Z","lastSeenAt":"2026-05-18T19:11:50.426Z","tsv":"'/brianc/node-postgres':178 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':119 '/brianc/node-postgres/head/readme.md':185 '/skills/postgresql-slow-query-runbook-agent/)':192 'agent':187 'agentskillexchange.com':191 'agentskillexchange.com/skills/postgresql-slow-query-runbook-agent/)':190 'analysi':26,62 'analyz':15,51 'basic':134 'bind':133 'block':122 'bootstrap':98 'bottleneck':32,68 'build':115 'caveat':109 'client':124 'content':35,71 'develop/contribute':157 'diagnos':5,41 'doc':182 'document':141,160 'environ':84 'exchang':189 'explain':14,50 'extens':13,49 'extract':179 'featur':174 'focus':153 'get':138 'getting-start':137 'github.com':118,177 'github.com/brianc/node-postgres':176 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':117 'identifi':27,63 'index':22,24,29,58,60,65 'instal':73,77,86 'issu':36,72 'javascript':128 'lerna':97 'libpq':132 'lock':34,70 'manag':168 'match':82 'miss':28,64 'modul':167 'nativ':131 'node':113 'node-postgr':112 'node.js':126 'non':121 'non-block':120 'note':140 'npm':85 'option':130 'output':16,52 'overal':159 'packag':143 'pars':17,53 'path':80 'pg':10,19,46,55,87 'pleas':172 'postgr':114 'postgresql':1,6,37,42,123 'project':163 'pure':127 'queri':3,8,39,44 'raw.githubusercontent.com':184 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':183 'readm':151 'relat':166 'repo':146,171 'requir':107 'root':91 'run':92,99,103 'runbook':4,40 'scan':31,67 'see':173 'sequenti':30,66 'setup':79 'skill':188 'skill-postgresql-slow-query-runbook-agent' 'slow':2,7,38,43 'sourc':175,186 'source-agentskillexchange' 'start':139 'stat':11,20,47,56 'statement':12,48 'status':116 'test':101,106 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'upstream':76,111,181 'usag':25,61,135 'use':9,45,74 'user':21,57 'workspac':90 'yarn':93,96,100","prices":[{"id":"61ac9e0b-c255-4255-9669-73cdc29d8327","listingId":"39995554-e613-4077-bc3b-a61e9c67ff2c","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:18:29.590Z"}],"sources":[{"listingId":"39995554-e613-4077-bc3b-a61e9c67ff2c","source":"github","sourceId":"agentskillexchange/skills/postgresql-slow-query-runbook-agent","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-slow-query-runbook-agent","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:29.590Z","lastSeenAt":"2026-05-18T19:11:50.426Z"}],"details":{"listingId":"39995554-e613-4077-bc3b-a61e9c67ff2c","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-slow-query-runbook-agent","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"4d6f476389fb94f4fdf62c17e558f7477e1b56d9","skill_md_path":"skills/postgresql-slow-query-runbook-agent/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-slow-query-runbook-agent"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Slow Query Runbook","description":"Diagnoses PostgreSQL slow queries using pg_stat_statements extension, EXPLAIN ANALYZE output parsing, and pg_stat_user_indexes for index usage analysis. Identifies missing indexes, sequential scan bottlenecks, and lock contention issues."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-slow-query-runbook-agent"},"updatedAt":"2026-05-18T19:11:50.426Z"}}