{"id":"8449650c-14cb-4511-8b3a-a3aeea4d40d9","shortId":"Gd2fvZ","kind":"skill","title":"PostgreSQL Query Diagnostics","tagline":"Diagnoses slow PostgreSQL queries using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE output parsing. Integrates with the pgBadger log analyzer and pg_stat_user_tables for index recommendation.","description":"# PostgreSQL Query Diagnostics\n\nDiagnoses slow PostgreSQL queries using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE output parsing. Integrates with the pgBadger log analyzer and pg_stat_user_tables for index recommendation.\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-query-diagnostics/)","tags":["postgresql","query","diagnostics","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-query-diagnostics","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-query-diagnostics","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,225 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.916Z","embedding":null,"createdAt":"2026-05-18T13:18:28.741Z","updatedAt":"2026-05-18T19:11:49.916Z","lastSeenAt":"2026-05-18T19:11:49.916Z","tsv":"'/brianc/node-postgres':172 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':113 '/brianc/node-postgres/head/readme.md':179 '/skills/postgresql-query-diagnostics/)':186 'activ':14,47 'agent':181 'agentskillexchange.com':185 'agentskillexchange.com/skills/postgresql-query-diagnostics/)':184 'analyz':17,25,50,58 'basic':128 'bind':127 'block':116 'bootstrap':92 'build':109 'caveat':103 'client':118 'develop/contribute':151 'diagnos':4,37 'diagnost':3,36 'doc':176 'document':135,154 'environ':78 'exchang':183 'explain':16,49 'extract':173 'featur':168 'focus':147 'get':132 'getting-start':131 'github.com':112,171 'github.com/brianc/node-postgres':170 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':111 'index':32,65 'instal':67,71,80 'integr':20,53 'javascript':122 'lerna':91 'libpq':126 'log':24,57 'manag':162 'match':76 'modul':161 'nativ':125 'node':107 'node-postgr':106 'node.js':120 'non':115 'non-block':114 'note':134 'npm':79 'option':124 'output':18,51 'overal':153 'packag':137 'pars':19,52 'path':74 'pg':9,12,27,42,45,60,81 'pgbadger':23,56 'pleas':166 'postgr':108 'postgresql':1,6,34,39,117 'project':157 'pure':121 'queri':2,7,35,40 'raw.githubusercontent.com':178 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':177 'readm':145 'recommend':33,66 'relat':160 'repo':140,165 'requir':101 'root':85 'run':86,93,97 'see':167 'setup':73 'skill':182 'skill-postgresql-query-diagnostics' 'slow':5,38 'sourc':169,180 'source-agentskillexchange' 'start':133 'stat':10,13,28,43,46,61 'statement':11,44 'status':110 'tabl':30,63 'test':95,100 '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':70,105,175 'usag':129 'use':8,41,68 'user':29,62 'workspac':84 'yarn':87,90,94","prices":[{"id":"a836a401-31d3-4641-8853-7f9d59b54f87","listingId":"8449650c-14cb-4511-8b3a-a3aeea4d40d9","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.741Z"}],"sources":[{"listingId":"8449650c-14cb-4511-8b3a-a3aeea4d40d9","source":"github","sourceId":"agentskillexchange/skills/postgresql-query-diagnostics","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-query-diagnostics","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:28.741Z","lastSeenAt":"2026-05-18T19:11:49.916Z"}],"details":{"listingId":"8449650c-14cb-4511-8b3a-a3aeea4d40d9","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-query-diagnostics","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":"95d5f654dc639744ca8612092210646736e85789","skill_md_path":"skills/postgresql-query-diagnostics/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-query-diagnostics"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Query Diagnostics","description":"Diagnoses slow PostgreSQL queries using pg_stat_statements, pg_stat_activity, and EXPLAIN ANALYZE output parsing. Integrates with the pgBadger log analyzer and pg_stat_user_tables for index recommendation."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-query-diagnostics"},"updatedAt":"2026-05-18T19:11:49.916Z"}}