{"id":"fed31f4c-e3b8-406f-befb-a9b8e6b120f2","shortId":"mEHEUb","kind":"skill","title":"pgcli Interactive PostgreSQL Client with Autocompletion","tagline":"pgcli is an interactive PostgreSQL CLI with context-aware autocompletion, syntax highlighting, and multi-line query editing. Part of the dbcli project with 13k+ GitHub stars, it makes database exploration and query writing dramatically more productive.","description":"# pgcli Interactive PostgreSQL Client with Autocompletion\n\npgcli is an interactive PostgreSQL CLI with context-aware autocompletion, syntax highlighting, and multi-line query editing. Part of the dbcli project with 13k+ GitHub stars, it makes database exploration and query writing dramatically more productive.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- $ pip install -U pgcli\n- $ brew install pgcli # Only on macOS\n- $ brew install pgcli\n- $ pip install pgcli\n\nRequirements and caveats from upstream:\n- If you already know how to install python packages, then you can simply do:\n- If you don't know how to install python packages, please check the\n- .. _prompt_toolkit: https://github.com/jonathanslenders/python-prompt-toolkit\n\nBasic usage or getting-started notes:\n- -----------\n- ::\n- or\n\n- Source: https://github.com/dbcli/pgcli\n- Extracted from upstream docs: https://raw.githubusercontent.com/dbcli/pgcli/HEAD/README.rst\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/pgcli-interactive-postgresql-client/)","tags":["pgcli","interactive","postgresql","client","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex"],"capabilities":["skill","source-agentskillexchange","skill-pgcli-interactive-postgresql-client","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/pgcli-interactive-postgresql-client","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,088 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:43.248Z","embedding":null,"createdAt":"2026-05-18T13:18:19.920Z","updatedAt":"2026-05-18T19:11:43.248Z","lastSeenAt":"2026-05-18T19:11:43.248Z","tsv":"'/dbcli/pgcli':165 '/dbcli/pgcli/head/readme.rst':172 '/jonathanslenders/python-prompt-toolkit':153 '/skills/pgcli-interactive-postgresql-client/)':179 '13k':32,76 'agent':174 'agentskillexchange.com':178 'agentskillexchange.com/skills/pgcli-interactive-postgresql-client/)':177 'alreadi':124 'autocomplet':6,17,50,61 'awar':16,60 'basic':154 'brew':105,111 'caveat':119 'check':147 'cli':12,56 'client':4,48 'context':15,59 'context-awar':14,58 'databas':37,81 'dbcli':29,73 'doc':169 'dramat':42,86 'edit':25,69 'environ':100 'exchang':176 'explor':38,82 'extract':166 'get':158 'getting-start':157 'github':33,77 'github.com':152,164 'github.com/dbcli/pgcli':163 'github.com/jonathanslenders/python-prompt-toolkit':151 'highlight':19,63 'instal':89,93,102,106,112,115,128,143 'interact':2,10,46,54 'know':125,140 'line':23,67 'maco':110 'make':36,80 'match':98 'multi':22,66 'multi-lin':21,65 'note':160 'packag':130,145 'part':26,70 'path':96 'pgcli':1,7,45,51,104,107,113,116 'pip':101,114 'pleas':146 'postgresql':3,11,47,55 'product':44,88 'project':30,74 'prompt':149 'python':129,144 'queri':24,40,68,84 'raw.githubusercontent.com':171 'raw.githubusercontent.com/dbcli/pgcli/head/readme.rst':170 'requir':117 'setup':95 'simpli':134 'skill':175 'skill-pgcli-interactive-postgresql-client' 'sourc':162,173 'source-agentskillexchange' 'star':34,78 'start':159 'syntax':18,62 'toolkit':150 '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' 'u':103 'upstream':92,121,168 'usag':155 'use':90 'write':41,85","prices":[{"id":"2b912df3-ef05-4ea9-a98f-593f45312a0b","listingId":"fed31f4c-e3b8-406f-befb-a9b8e6b120f2","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:19.920Z"}],"sources":[{"listingId":"fed31f4c-e3b8-406f-befb-a9b8e6b120f2","source":"github","sourceId":"agentskillexchange/skills/pgcli-interactive-postgresql-client","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/pgcli-interactive-postgresql-client","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:19.920Z","lastSeenAt":"2026-05-18T19:11:43.248Z"}],"details":{"listingId":"fed31f4c-e3b8-406f-befb-a9b8e6b120f2","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"pgcli-interactive-postgresql-client","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":"1fa61917f6870138a1861329d819836b1a769d37","skill_md_path":"skills/pgcli-interactive-postgresql-client/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/pgcli-interactive-postgresql-client"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"pgcli Interactive PostgreSQL Client with Autocompletion","description":"pgcli is an interactive PostgreSQL CLI with context-aware autocompletion, syntax highlighting, and multi-line query editing. Part of the dbcli project with 13k+ GitHub stars, it makes database exploration and query writing dramatically more productive."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/pgcli-interactive-postgresql-client"},"updatedAt":"2026-05-18T19:11:43.248Z"}}