{"id":"483e5f41-fbf2-4ef5-9eae-d637433e5728","shortId":"9ta4fp","kind":"skill","title":"PostgreSQL Performance Diagnostic Suite","tagline":"Diagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE. Integrates with pgBadger for log analysis and pg_stat_user_tables for index recommendations.","description":"# PostgreSQL Performance Diagnostic Suite\n\nDiagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE. Integrates with pgBadger for log analysis and pg_stat_user_tables for index recommendations.\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-diagnostic-suite/)","tags":["postgresql","performance","diagnostic","suite","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-performance-diagnostic-suite","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-diagnostic-suite","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,239 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.515Z","embedding":null,"createdAt":"2026-05-18T13:18:28.278Z","updatedAt":"2026-05-18T19:11:49.515Z","lastSeenAt":"2026-05-18T19:11:49.515Z","tsv":"'/brianc/node-postgres':170 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':111 '/brianc/node-postgres/head/readme.md':177 '/skills/postgresql-performance-diagnostic-suite/)':184 'activ':15,47 'agent':179 'agentskillexchange.com':183 'agentskillexchange.com/skills/postgresql-performance-diagnostic-suite/)':182 'analysi':24,56 'analyz':18,50 'basic':126 'bind':125 'block':114 'bootstrap':90 'build':107 'caveat':101 'client':116 'develop/contribute':149 'diagnos':5,37 'diagnost':3,35 'doc':174 'document':133,152 'environ':76 'exchang':181 'explain':17,49 'extract':171 'featur':166 'focus':145 'get':130 'getting-start':129 'github.com':110,169 'github.com/brianc/node-postgres':168 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':109 'index':31,63 'instal':65,69,78 'integr':19,51 'issu':8,40 'javascript':120 'lerna':89 'libpq':124 'log':23,55 'manag':160 'match':74 'modul':159 'nativ':123 'node':105 'node-postgr':104 'node.js':118 'non':113 'non-block':112 'note':132 'npm':77 'option':122 'overal':151 'packag':135 'path':72 'perform':2,7,34,39 'pg':10,13,26,42,45,58,79 'pgbadger':21,53 'pleas':164 'postgr':106 'postgresql':1,6,33,38,115 'project':155 'pure':119 'raw.githubusercontent.com':176 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':175 'readm':143 'recommend':32,64 'relat':158 'repo':138,163 'requir':99 'root':83 'run':84,91,95 'see':165 'setup':71 'skill':180 'skill-postgresql-performance-diagnostic-suite' 'sourc':167,178 'source-agentskillexchange' 'start':131 'stat':11,14,27,43,46,59 'statement':12,44 'status':108 'suit':4,36 'tabl':29,61 'test':93,98 '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':68,103,173 'usag':127 'use':9,41,66 'user':28,60 'workspac':82 'yarn':85,88,92","prices":[{"id":"0b104437-16fe-4c72-850d-86251c199ddc","listingId":"483e5f41-fbf2-4ef5-9eae-d637433e5728","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.278Z"}],"sources":[{"listingId":"483e5f41-fbf2-4ef5-9eae-d637433e5728","source":"github","sourceId":"agentskillexchange/skills/postgresql-performance-diagnostic-suite","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-performance-diagnostic-suite","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:28.278Z","lastSeenAt":"2026-05-18T19:11:49.515Z"}],"details":{"listingId":"483e5f41-fbf2-4ef5-9eae-d637433e5728","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-performance-diagnostic-suite","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":"6a42cfeacac242617c6544cf907fd039e4a44366","skill_md_path":"skills/postgresql-performance-diagnostic-suite/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-performance-diagnostic-suite"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Performance Diagnostic Suite","description":"Diagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE. Integrates with pgBadger for log analysis and pg_stat_user_tables for index recommendations."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-performance-diagnostic-suite"},"updatedAt":"2026-05-18T19:11:49.515Z"}}