{"id":"6e737558-6863-4bf9-8a2c-ee3f06a496d4","shortId":"uV62V5","kind":"skill","title":"PostgreSQL Query Plan Explainer","tagline":"Interprets PostgreSQL EXPLAIN ANALYZE output using pg_stat_statements and auto_explain module data. Identifies sequential scan bottlenecks, index recommendations via HypoPG, and buffer cache hit ratios.","description":"# PostgreSQL Query Plan Explainer\n\nInterprets PostgreSQL EXPLAIN ANALYZE output using pg_stat_statements and auto_explain module data. Identifies sequential scan bottlenecks, index recommendations via HypoPG, and buffer cache hit ratios.\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-explainer/)","tags":["postgresql","query","plan","explainer","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-query-plan-explainer","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-explainer","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,228 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.235Z","embedding":null,"createdAt":"2026-05-18T13:18:29.380Z","updatedAt":"2026-05-18T19:11:50.235Z","lastSeenAt":"2026-05-18T19:11:50.235Z","tsv":"'/brianc/node-postgres':168 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':109 '/brianc/node-postgres/head/readme.md':175 '/skills/postgresql-query-plan-explainer/)':182 'agent':177 'agentskillexchange.com':181 'agentskillexchange.com/skills/postgresql-query-plan-explainer/)':180 'analyz':8,39 'auto':15,46 'basic':124 'bind':123 'block':112 'bootstrap':88 'bottleneck':22,53 'buffer':28,59 'build':105 'cach':29,60 'caveat':99 'client':114 'data':18,49 'develop/contribute':147 'doc':172 'document':131,150 'environ':74 'exchang':179 'explain':4,7,16,35,38,47 'extract':169 'featur':164 'focus':143 'get':128 'getting-start':127 'github.com':108,167 'github.com/brianc/node-postgres':166 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':107 'hit':30,61 'hypopg':26,57 'identifi':19,50 'index':23,54 'instal':63,67,76 'interpret':5,36 'javascript':118 'lerna':87 'libpq':122 'manag':158 'match':72 'modul':17,48,157 'nativ':121 'node':103 'node-postgr':102 'node.js':116 'non':111 'non-block':110 'note':130 'npm':75 'option':120 'output':9,40 'overal':149 'packag':133 'path':70 'pg':11,42,77 'plan':3,34 'pleas':162 'postgr':104 'postgresql':1,6,32,37,113 'project':153 'pure':117 'queri':2,33 'ratio':31,62 'raw.githubusercontent.com':174 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':173 'readm':141 'recommend':24,55 'relat':156 'repo':136,161 'requir':97 'root':81 'run':82,89,93 'scan':21,52 'see':163 'sequenti':20,51 'setup':69 'skill':178 'skill-postgresql-query-plan-explainer' 'sourc':165,176 'source-agentskillexchange' 'start':129 'stat':12,43 'statement':13,44 'status':106 'test':91,96 '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':66,101,171 'usag':125 'use':10,41,64 'via':25,56 'workspac':80 'yarn':83,86,90","prices":[{"id":"e9718ec1-a4a0-4bd5-ac0f-424ae52ff8d5","listingId":"6e737558-6863-4bf9-8a2c-ee3f06a496d4","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.380Z"}],"sources":[{"listingId":"6e737558-6863-4bf9-8a2c-ee3f06a496d4","source":"github","sourceId":"agentskillexchange/skills/postgresql-query-plan-explainer","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-query-plan-explainer","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:29.380Z","lastSeenAt":"2026-05-18T19:11:50.235Z"}],"details":{"listingId":"6e737558-6863-4bf9-8a2c-ee3f06a496d4","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-query-plan-explainer","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":"4f7c3822933b78fd5fdf408f6973e0c7181d44ed","skill_md_path":"skills/postgresql-query-plan-explainer/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-query-plan-explainer"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Query Plan Explainer","description":"Interprets PostgreSQL EXPLAIN ANALYZE output using pg_stat_statements and auto_explain module data. Identifies sequential scan bottlenecks, index recommendations via HypoPG, and buffer cache hit ratios."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-query-plan-explainer"},"updatedAt":"2026-05-18T19:11:50.235Z"}}