{"id":"9239da27-5424-44d8-a704-0a06ac9d512f","shortId":"TXN9h6","kind":"skill","title":"PostgreSQL Diagnostic Runbook","tagline":"Diagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and the pgbadger log analyzer. Identifies slow queries, lock contention, and bloat via pgstattuple extension.","description":"# PostgreSQL Diagnostic Runbook\n\nDiagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and the pgbadger log analyzer. Identifies slow queries, lock contention, and bloat via pgstattuple extension.\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-diagnostic-runbook/)","tags":["postgresql","diagnostic","runbook","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-diagnostic-runbook","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-diagnostic-runbook","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,215 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:49.245Z","embedding":null,"createdAt":"2026-05-18T13:18:27.951Z","updatedAt":"2026-05-18T19:11:49.245Z","lastSeenAt":"2026-05-18T19:11:49.245Z","tsv":"'/brianc/node-postgres':164 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':105 '/brianc/node-postgres/head/readme.md':171 '/skills/postgresql-diagnostic-runbook/)':178 'activ':14,43 'agent':173 'agentskillexchange.com':177 'agentskillexchange.com/skills/postgresql-diagnostic-runbook/)':176 'analyz':19,48 'basic':120 'bind':119 'bloat':26,55 'block':108 'bootstrap':84 'build':101 'caveat':95 'client':110 'content':24,53 'develop/contribute':143 'diagnos':4,33 'diagnost':2,31 'doc':168 'document':127,146 'environ':70 'exchang':175 'extens':29,58 'extract':165 'featur':160 'focus':139 'get':124 'getting-start':123 'github.com':104,163 'github.com/brianc/node-postgres':162 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':103 'identifi':20,49 'instal':59,63,72 'issu':7,36 'javascript':114 'lerna':83 'libpq':118 'lock':23,52 'log':18,47 'manag':154 'match':68 'modul':153 'nativ':117 'node':99 'node-postgr':98 'node.js':112 'non':107 'non-block':106 'note':126 'npm':71 'option':116 'overal':145 'packag':129 'path':66 'perform':6,35 'pg':9,12,38,41,73 'pgbadger':17,46 'pgstattupl':28,57 'pleas':158 'postgr':100 'postgresql':1,5,30,34,109 'project':149 'pure':113 'queri':22,51 'raw.githubusercontent.com':170 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':169 'readm':137 'relat':152 'repo':132,157 'requir':93 'root':77 'run':78,85,89 'runbook':3,32 'see':159 'setup':65 'skill':174 'skill-postgresql-diagnostic-runbook' 'slow':21,50 'sourc':161,172 'source-agentskillexchange' 'start':125 'stat':10,13,39,42 'statement':11,40 'status':102 'test':87,92 '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':62,97,167 'usag':121 'use':8,37,60 'via':27,56 'workspac':76 'yarn':79,82,86","prices":[{"id":"1e958766-0376-4c4d-bf0f-86f3111c1cb1","listingId":"9239da27-5424-44d8-a704-0a06ac9d512f","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:27.951Z"}],"sources":[{"listingId":"9239da27-5424-44d8-a704-0a06ac9d512f","source":"github","sourceId":"agentskillexchange/skills/postgresql-diagnostic-runbook","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-diagnostic-runbook","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:27.951Z","lastSeenAt":"2026-05-18T19:11:49.245Z"}],"details":{"listingId":"9239da27-5424-44d8-a704-0a06ac9d512f","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-diagnostic-runbook","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":"23008da254aa9db73f018ca6552d7d6c458e07bb","skill_md_path":"skills/postgresql-diagnostic-runbook/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-diagnostic-runbook"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Diagnostic Runbook","description":"Diagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and the pgbadger log analyzer. Identifies slow queries, lock contention, and bloat via pgstattuple extension."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-diagnostic-runbook"},"updatedAt":"2026-05-18T19:11:49.245Z"}}