{"id":"a8160de5-8410-4588-9e0b-9c314f8f68fc","shortId":"6k7bZt","kind":"skill","title":"PostgreSQL Query Plan Diagnostics","tagline":"Analyzes PostgreSQL query execution plans using EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) and the pg_stat_statements extension. Identifies sequential scans, nested loop inefficiencies, and index recommendations for slow queries.","description":"# PostgreSQL Query Plan Diagnostics\n\nAnalyzes PostgreSQL query execution plans using EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) and the pg_stat_statements extension. Identifies sequential scans, nested loop inefficiencies, and index recommendations for slow queries.\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-plan-diagnostics-wave48/)","tags":["postgresql","query","plan","diagnostics","wave48","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-query-plan-diagnostics-wave48","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-plan-diagnostics-wave48","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,263 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:50.136Z","embedding":null,"createdAt":"2026-05-18T13:18:29.259Z","updatedAt":"2026-05-18T19:11:50.136Z","lastSeenAt":"2026-05-18T19:11:50.136Z","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-plan-diagnostics-wave48/)':186 'agent':181 'agentskillexchange.com':185 'agentskillexchange.com/skills/postgresql-query-plan-diagnostics-wave48/)':184 'analyz':5,12,38,45 'basic':128 'bind':127 'block':116 'bootstrap':92 'buffer':13,46 'build':109 'caveat':103 'client':118 'develop/contribute':151 'diagnost':4,37 'doc':176 'document':135,154 'environ':78 'exchang':183 'execut':8,41 'explain':11,44 'extens':21,54 'extract':173 'featur':168 'focus':147 'format':14,47 '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 'identifi':22,55 'index':29,62 'ineffici':27,60 'instal':67,71,80 'javascript':122 'json':15,48 'lerna':91 'libpq':126 'loop':26,59 'manag':162 'match':76 'modul':161 'nativ':125 'nest':25,58 'node':107 'node-postgr':106 'node.js':120 'non':115 'non-block':114 'note':134 'npm':79 'option':124 'overal':153 'packag':137 'path':74 'pg':18,51,81 'plan':3,9,36,42 'pleas':166 'postgr':108 'postgresql':1,6,34,39,117 'project':157 'pure':121 'queri':2,7,33,35,40,66 'raw.githubusercontent.com':178 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':177 'readm':145 'recommend':30,63 'relat':160 'repo':140,165 'requir':101 'root':85 'run':86,93,97 'scan':24,57 'see':167 'sequenti':23,56 'setup':73 'skill':182 'skill-postgresql-query-plan-diagnostics-wave48' 'slow':32,65 'sourc':169,180 'source-agentskillexchange' 'start':133 'stat':19,52 'statement':20,53 'status':110 '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':10,43,68 'workspac':84 'yarn':87,90,94","prices":[{"id":"d763dccd-5f5d-44e1-80d4-eb4e5584c207","listingId":"a8160de5-8410-4588-9e0b-9c314f8f68fc","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:29.259Z"}],"sources":[{"listingId":"a8160de5-8410-4588-9e0b-9c314f8f68fc","source":"github","sourceId":"agentskillexchange/skills/postgresql-query-plan-diagnostics-wave48","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-query-plan-diagnostics-wave48","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:29.259Z","lastSeenAt":"2026-05-18T19:11:50.136Z"}],"details":{"listingId":"a8160de5-8410-4588-9e0b-9c314f8f68fc","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-query-plan-diagnostics-wave48","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":"47b35c43552a3803dcf01596d84198fb724812e2","skill_md_path":"skills/postgresql-query-plan-diagnostics-wave48/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-query-plan-diagnostics-wave48"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Query Plan Diagnostics","description":"Analyzes PostgreSQL query execution plans using EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) and the pg_stat_statements extension. Identifies sequential scans, nested loop inefficiencies, and index recommendations for slow queries."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-query-plan-diagnostics-wave48"},"updatedAt":"2026-05-18T19:11:50.136Z"}}