{"id":"2f1bcf21-b553-42a3-b00c-9c64682737c1","shortId":"69W7V7","kind":"skill","title":"PostgreSQL Health Diagnostics Agent","tagline":"Queries PostgreSQL system catalogs pg_stat_activity, pg_stat_user_tables, and pg_locks to diagnose performance issues. Analyzes slow queries via pg_stat_statements and checks vacuum status through pg_stat_all_tables autovacuum columns.","description":"# PostgreSQL Health Diagnostics Agent\n\nQueries PostgreSQL system catalogs pg_stat_activity, pg_stat_user_tables, and pg_locks to diagnose performance issues. Analyzes slow queries via pg_stat_statements and checks vacuum status through pg_stat_all_tables autovacuum columns.\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-health-diagnostics-agent/)","tags":["postgresql","health","diagnostics","agent","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-health-diagnostics-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-health-diagnostics-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,269 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.355Z","embedding":null,"createdAt":"2026-05-18T13:18:28.040Z","updatedAt":"2026-05-18T19:11:49.355Z","lastSeenAt":"2026-05-18T19:11:49.355Z","tsv":"'/brianc/node-postgres':186 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':127 '/brianc/node-postgres/head/readme.md':193 '/skills/postgresql-health-diagnostics-agent/)':200 'activ':11,51 'agent':4,44,195 'agentskillexchange.com':199 'agentskillexchange.com/skills/postgresql-health-diagnostics-agent/)':198 'analyz':23,63 'autovacuum':39,79 'basic':142 'bind':141 'block':130 'bootstrap':106 'build':123 'catalog':8,48 'caveat':117 'check':31,71 'client':132 'column':40,80 'develop/contribute':165 'diagnos':20,60 'diagnost':3,43 'doc':190 'document':149,168 'environ':92 'exchang':197 'extract':187 'featur':182 'focus':161 'get':146 'getting-start':145 'github.com':126,185 'github.com/brianc/node-postgres':184 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':125 'health':2,42 'instal':81,85,94 'issu':22,62 'javascript':136 'lerna':105 'libpq':140 'lock':18,58 'manag':176 'match':90 'modul':175 'nativ':139 'node':121 'node-postgr':120 'node.js':134 'non':129 'non-block':128 'note':148 'npm':93 'option':138 'overal':167 'packag':151 'path':88 'perform':21,61 'pg':9,12,17,27,35,49,52,57,67,75,95 'pleas':180 'postgr':122 'postgresql':1,6,41,46,131 'project':171 'pure':135 'queri':5,25,45,65 'raw.githubusercontent.com':192 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':191 'readm':159 'relat':174 'repo':154,179 'requir':115 'root':99 'run':100,107,111 'see':181 'setup':87 'skill':196 'skill-postgresql-health-diagnostics-agent' 'slow':24,64 'sourc':183,194 'source-agentskillexchange' 'start':147 'stat':10,13,28,36,50,53,68,76 'statement':29,69 'status':33,73,124 'system':7,47 'tabl':15,38,55,78 'test':109,114 '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':84,119,189 'usag':143 'use':82 'user':14,54 'vacuum':32,72 'via':26,66 'workspac':98 'yarn':101,104,108","prices":[{"id":"4d0e39a2-071d-4209-b7ac-1d747867ce30","listingId":"2f1bcf21-b553-42a3-b00c-9c64682737c1","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.040Z"}],"sources":[{"listingId":"2f1bcf21-b553-42a3-b00c-9c64682737c1","source":"github","sourceId":"agentskillexchange/skills/postgresql-health-diagnostics-agent","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-health-diagnostics-agent","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:28.040Z","lastSeenAt":"2026-05-18T19:11:49.355Z"}],"details":{"listingId":"2f1bcf21-b553-42a3-b00c-9c64682737c1","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-health-diagnostics-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":"8681a90122b3d3a0d0a4058d445ffd838aab647c","skill_md_path":"skills/postgresql-health-diagnostics-agent/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-health-diagnostics-agent"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Health Diagnostics Agent","description":"Queries PostgreSQL system catalogs pg_stat_activity, pg_stat_user_tables, and pg_locks to diagnose performance issues. Analyzes slow queries via pg_stat_statements and checks vacuum status through pg_stat_all_tables autovacuum columns."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-health-diagnostics-agent"},"updatedAt":"2026-05-18T19:11:49.355Z"}}