{"id":"c3be267e-f51a-45d9-a4ad-53abe1597c09","shortId":"3XDf6L","kind":"skill","title":"PostgreSQL Query Optimizer Agent","tagline":"Optimizes PostgreSQL queries using EXPLAIN ANALYZE output parsing with pg_stat_statements extension data. Suggests index creation via HypoPG hypothetical index simulator and validates query plans against pg_hint_plan directives.","description":"# PostgreSQL Query Optimizer Agent\n\nOptimizes PostgreSQL queries using EXPLAIN ANALYZE output parsing with pg_stat_statements extension data. Suggests index creation via HypoPG hypothetical index simulator and validates query plans against pg_hint_plan directives.\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-optimizer-explain-api/)","tags":["postgresql","query","optimizer","explain","api","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code"],"capabilities":["skill","source-agentskillexchange","skill-postgresql-query-optimizer-explain-api","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-optimizer-explain-api","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,262 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.004Z","embedding":null,"createdAt":"2026-05-18T13:18:28.862Z","updatedAt":"2026-05-18T19:11:50.004Z","lastSeenAt":"2026-05-18T19:11:50.004Z","tsv":"'/brianc/node-postgres':176 '/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':117 '/brianc/node-postgres/head/readme.md':183 '/skills/postgresql-query-optimizer-explain-api/)':190 'agent':4,39,185 'agentskillexchange.com':189 'agentskillexchange.com/skills/postgresql-query-optimizer-explain-api/)':188 'analyz':10,45 'basic':132 'bind':131 'block':120 'bootstrap':96 'build':113 'caveat':107 'client':122 'creation':21,56 'data':18,53 'develop/contribute':155 'direct':35,70 'doc':180 'document':139,158 'environ':82 'exchang':187 'explain':9,44 'extens':17,52 'extract':177 'featur':172 'focus':151 'get':136 'getting-start':135 'github.com':116,175 'github.com/brianc/node-postgres':174 'github.com/brianc/node-postgres/actions/workflows/ci.yml/badge.svg)':115 'hint':33,68 'hypopg':23,58 'hypothet':24,59 'index':20,25,55,60 'instal':71,75,84 'javascript':126 'lerna':95 'libpq':130 'manag':166 'match':80 'modul':165 'nativ':129 'node':111 'node-postgr':110 'node.js':124 'non':119 'non-block':118 'note':138 'npm':83 'optim':3,5,38,40 'option':128 'output':11,46 'overal':157 'packag':141 'pars':12,47 'path':78 'pg':14,32,49,67,85 'plan':30,34,65,69 'pleas':170 'postgr':112 'postgresql':1,6,36,41,121 'project':161 'pure':125 'queri':2,7,29,37,42,64 'raw.githubusercontent.com':182 'raw.githubusercontent.com/brianc/node-postgres/head/readme.md':181 'readm':149 'relat':164 'repo':144,169 'requir':105 'root':89 'run':90,97,101 'see':171 'setup':77 'simul':26,61 'skill':186 'skill-postgresql-query-optimizer-explain-api' 'sourc':173,184 'source-agentskillexchange' 'start':137 'stat':15,50 'statement':16,51 'status':114 'suggest':19,54 'test':99,104 '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':74,109,179 'usag':133 'use':8,43,72 'valid':28,63 'via':22,57 'workspac':88 'yarn':91,94,98","prices":[{"id":"5b6475bd-457c-437c-8283-cfc643eac418","listingId":"c3be267e-f51a-45d9-a4ad-53abe1597c09","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.862Z"}],"sources":[{"listingId":"c3be267e-f51a-45d9-a4ad-53abe1597c09","source":"github","sourceId":"agentskillexchange/skills/postgresql-query-optimizer-explain-api","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-query-optimizer-explain-api","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:28.862Z","lastSeenAt":"2026-05-18T19:11:50.004Z"}],"details":{"listingId":"c3be267e-f51a-45d9-a4ad-53abe1597c09","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"postgresql-query-optimizer-explain-api","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":"0c3aed7b6832c752e860bcea1b62190deb91c28d","skill_md_path":"skills/postgresql-query-optimizer-explain-api/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/postgresql-query-optimizer-explain-api"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"PostgreSQL Query Optimizer Agent","description":"Optimizes PostgreSQL queries using EXPLAIN ANALYZE output parsing with pg_stat_statements extension data. Suggests index creation via HypoPG hypothetical index simulator and validates query plans against pg_hint_plan directives."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/postgresql-query-optimizer-explain-api"},"updatedAt":"2026-05-18T19:11:50.004Z"}}