{"id":"069bca2a-7c88-4c40-a327-d4b95db99621","shortId":"ByPLeg","kind":"skill","title":"PostgreSQL Performance Runbook","tagline":"Executes diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, bloated tables via pgstattuple, and generates EXPLAIN ANALYZE reports with buffer statistics.","description":"# PostgreSQL Performance Runbook\n\nExecutes diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, bloated tables via pgstattuple, and generates EXPLAIN ANALYZE reports with buffer statistics.\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-performance-runbook/)","tags":["postgresql","performance","runbook","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-performance-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-performance-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,277 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.713Z","embedding":null,"createdAt":"2026-05-18T13:18:28.498Z","updatedAt":"2026-05-18T19:11:49.713Z","lastSeenAt":"2026-05-18T19:11:49.713Z","tsv":"'/brianc/node-postgres':180 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':121 '/brianc/node-postgres/head/readme.md':187 '/skills/postgresql-performance-runbook/)':194 'activ':15,52 'agent':189 'agentskillexchange.com':193 'agentskillexchange.com/skills/postgresql-performance-runbook/)':192 'analyz':33,70 'basic':136 'bind':135 'bloat':26,63 'block':124 'bootstrap':100 'buffer':36,73 'build':117 'caveat':111 'client':126 'content':25,62 'develop/contribute':159 'diagnost':5,42 'doc':184 'document':143,162 'environ':86 'exchang':191 'execut':4,41 'explain':32,69 'extract':181 'featur':176 'focus':155 'generat':31,68 'get':140 'getting-start':139 'github.com':120,179 'github.com/brianc/node-postgres':178 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':119 'identifi':21,58 'instal':75,79,88 'javascript':130 'lerna':99 'libpq':134 'lock':18,24,55,61 'manag':170 'match':84 'modul':169 'nativ':133 'node':115 'node-postgr':114 'node.js':128 'non':123 'non-block':122 'note':142 'npm':87 'option':132 'overal':161 'packag':145 'path':82 'perform':2,39 'pg':10,13,17,47,50,54,89 'pgstattupl':29,66 'pleas':174 'postgr':116 'postgresql':1,8,38,45,125 'project':165 'pure':129 'queri':6,23,43,60 'raw.githubusercontent.com':186 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':185 'readm':153 'relat':168 'repo':148,173 'report':34,71 'requir':109 'root':93 'run':94,101,105 'runbook':3,40 'see':175 'setup':81 'skill':190 'skill-postgresql-performance-runbook' 'slow':22,59 'sourc':177,188 'source-agentskillexchange' 'start':141 'stat':11,14,48,51 'statement':12,49 'statist':37,74 'status':118 'system':19,56 'tabl':27,64 'test':103,108 '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':78,113,183 'usag':137 'use':9,46,76 'via':28,65 'view':20,57 'workspac':92 'yarn':95,98,102","prices":[{"id":"8cb6583f-230b-4b6d-b859-31c45018e67e","listingId":"069bca2a-7c88-4c40-a327-d4b95db99621","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:28.498Z"}],"sources":[{"listingId":"069bca2a-7c88-4c40-a327-d4b95db99621","source":"github","sourceId":"agentskillexchange/skills/postgresql-performance-runbook","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-performance-runbook","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:28.498Z","lastSeenAt":"2026-05-18T19:11:49.713Z"}],"details":{"listingId":"069bca2a-7c88-4c40-a327-d4b95db99621","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-performance-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":"f3bc0bd1dad1bf72e75cfeca3cb660a008aadbcd","skill_md_path":"skills/postgresql-performance-runbook/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-performance-runbook"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Performance Runbook","description":"Executes diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, bloated tables via pgstattuple, and generates EXPLAIN ANALYZE reports with buffer statistics."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-performance-runbook"},"updatedAt":"2026-05-18T19:11:49.713Z"}}