{"id":"f1efc975-513a-4fa7-aacc-69d35b0ca851","shortId":"LLpHks","kind":"skill","title":"PostgreSQL Diagnostic Analyzer","tagline":"Runs diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, and bloat using pgstattuple and pg_repack extension analysis.","description":"# PostgreSQL Diagnostic Analyzer\n\nRuns diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, and bloat using pgstattuple and pg_repack extension analysis.\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-analyzer/)","tags":["postgresql","diagnostic","analyzer","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-diagnostic-analyzer","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-analyzer","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,241 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.134Z","embedding":null,"createdAt":"2026-05-18T13:18:27.861Z","updatedAt":"2026-05-18T19:11:49.134Z","lastSeenAt":"2026-05-18T19:11:49.134Z","tsv":"'/brianc/node-postgres':174 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':115 '/brianc/node-postgres/head/readme.md':181 '/skills/postgresql-diagnostic-analyzer/)':188 'activ':15,49 'agent':183 'agentskillexchange.com':187 'agentskillexchange.com/skills/postgresql-diagnostic-analyzer/)':186 'analysi':34,68 'analyz':3,37 'basic':130 'bind':129 'bloat':27,61 'block':118 'bootstrap':94 'build':111 'caveat':105 'client':120 'content':25,59 'develop/contribute':153 'diagnost':2,5,36,39 'doc':178 'document':137,156 'environ':80 'exchang':185 'extens':33,67 'extract':175 'featur':170 'focus':149 'get':134 'getting-start':133 'github.com':114,173 'github.com/brianc/node-postgres':172 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':113 'identifi':21,55 'instal':69,73,82 'javascript':124 'lerna':93 'libpq':128 'lock':18,24,52,58 'manag':164 'match':78 'modul':163 'nativ':127 'node':109 'node-postgr':108 'node.js':122 'non':117 'non-block':116 'note':136 'npm':81 'option':126 'overal':155 'packag':139 'path':76 'pg':10,13,17,31,44,47,51,65,83 'pgstattupl':29,63 'pleas':168 'postgr':110 'postgresql':1,8,35,42,119 'project':159 'pure':123 'queri':6,23,40,57 'raw.githubusercontent.com':180 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':179 'readm':147 'relat':162 'repack':32,66 'repo':142,167 'requir':103 'root':87 'run':4,38,88,95,99 'see':169 'setup':75 'skill':184 'skill-postgresql-diagnostic-analyzer' 'slow':22,56 'sourc':171,182 'source-agentskillexchange' 'start':135 'stat':11,14,45,48 'statement':12,46 'status':112 'system':19,53 'test':97,102 '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':72,107,177 'usag':131 'use':9,28,43,62,70 'view':20,54 'workspac':86 'yarn':89,92,96","prices":[{"id":"0538364d-9073-4350-bd95-1a5619780cb6","listingId":"f1efc975-513a-4fa7-aacc-69d35b0ca851","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.861Z"}],"sources":[{"listingId":"f1efc975-513a-4fa7-aacc-69d35b0ca851","source":"github","sourceId":"agentskillexchange/skills/postgresql-diagnostic-analyzer","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-diagnostic-analyzer","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:27.861Z","lastSeenAt":"2026-05-18T19:11:49.134Z"}],"details":{"listingId":"f1efc975-513a-4fa7-aacc-69d35b0ca851","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-diagnostic-analyzer","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":"af85efcb87b9c78be2f9f6bc11e160c12e8bfe4e","skill_md_path":"skills/postgresql-diagnostic-analyzer/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-diagnostic-analyzer"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Diagnostic Analyzer","description":"Runs diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, and bloat using pgstattuple and pg_repack extension analysis."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-diagnostic-analyzer"},"updatedAt":"2026-05-18T19:11:49.134Z"}}