{"id":"408089db-dd7d-4c5a-9cb6-2f4656f90774","shortId":"TMHgN3","kind":"skill","title":"Ground PostgreSQL code generation in exact docs and best-practice skills through pg-aiguide","tagline":"Give coding agents a PostgreSQL-specific reference layer with semantic doc search and curated schema, indexing, and constraint guidance before they generate database code.","description":"# Ground PostgreSQL code generation in exact docs and best-practice skills through pg-aiguide\n\nGive coding agents a PostgreSQL-specific reference layer with semantic doc search and curated schema, indexing, and constraint guidance before they generate database code.\n\n## Prerequisites\n\nAn AI coding agent with MCP support or npx skills support, plus optional access to the public pg-aiguide docs server.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- npx skills add timescale/pg-aiguide --skill postgres\n- npx skills add timescale/pg-aiguide\n\nBasic usage or getting-started notes:\n- Please describe the schema you would create for an e-commerce website two times, first with the tiger mcp server disabled, then with the tiger mcp server enabled. For each time, write the schema to its own file in the...\n- bash\n- Or pick individual skills interactively:\n\n- Source: https://github.com/timescale/pg-aiguide\n- Extracted from upstream docs: https://raw.githubusercontent.com/timescale/pg-aiguide/HEAD/README.md\n\n## Documentation\n\n- https://github.com/timescale/pg-aiguide\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide/)","tags":["ground","postgresql","code","generation","exact","docs","and","best","practice","skills","through","aiguide"],"capabilities":["skill","source-agentskillexchange","skill-ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide","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/ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide","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,279 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:10:48.395Z","embedding":null,"createdAt":"2026-05-18T13:17:00.192Z","updatedAt":"2026-05-18T19:10:48.395Z","lastSeenAt":"2026-05-18T19:10:48.395Z","tsv":"'/skills/ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide/)':203 '/timescale/pg-aiguide':185,196 '/timescale/pg-aiguide/head/readme.md':192 'access':97 'add':120,126 'agent':19,60,87,198 'agentskillexchange.com':202 'agentskillexchange.com/skills/ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide/)':201 'ai':85 'aiguid':16,57,103 'bash':176 'basic':128 'best':10,51 'best-practic':9,50 'code':3,18,41,44,59,82,86 'commerc':146 'constraint':35,76 'creat':141 'curat':31,72 'databas':40,81 'describ':136 'disabl':156 'doc':7,28,48,69,104,189 'document':193 'e':145 'e-commerc':144 'enabl':163 'environ':117 'exact':6,47 'exchang':200 'extract':186 'file':173 'first':150 'generat':4,39,45,80 'get':132 'getting-start':131 'github.com':184,195 'github.com/timescale/pg-aiguide':183,194 'give':17,58 'ground':1,42 'guidanc':36,77 'index':33,74 'individu':179 'instal':106,110 'interact':181 'layer':25,66 'match':115 'mcp':89,154,161 'note':134 'npx':92,118,124 'option':96 'path':113 'pg':15,56,102 'pg-aiguid':14,55,101 'pick':178 'pleas':135 'plus':95 'postgr':123 'postgresql':2,22,43,63 'postgresql-specif':21,62 'practic':11,52 'prerequisit':83 'public':100 'raw.githubusercontent.com':191 'raw.githubusercontent.com/timescale/pg-aiguide/head/readme.md':190 'refer':24,65 'schema':32,73,138,169 'search':29,70 'semant':27,68 'server':105,155,162 'setup':112 'skill':12,53,93,119,122,125,180,199 'skill-ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide' 'sourc':182,197 'source-agentskillexchange' 'specif':23,64 'start':133 'support':90,94 'tiger':153,160 'time':149,166 'timescale/pg-aiguide':121,127 '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' 'two':148 'upstream':109,188 'usag':129 'use':107 'websit':147 'would':140 'write':167","prices":[{"id":"69e4d6b2-27c9-4b48-897e-43d1db1bd4e2","listingId":"408089db-dd7d-4c5a-9cb6-2f4656f90774","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:17:00.192Z"}],"sources":[{"listingId":"408089db-dd7d-4c5a-9cb6-2f4656f90774","source":"github","sourceId":"agentskillexchange/skills/ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide","isPrimary":false,"firstSeenAt":"2026-05-18T13:17:00.192Z","lastSeenAt":"2026-05-18T19:10:48.395Z"}],"details":{"listingId":"408089db-dd7d-4c5a-9cb6-2f4656f90774","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide","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":"0a21cfff00874600c9dec720878bb59e5439ee13","skill_md_path":"skills/ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Ground PostgreSQL code generation in exact docs and best-practice skills through pg-aiguide","description":"Give coding agents a PostgreSQL-specific reference layer with semantic doc search and curated schema, indexing, and constraint guidance before they generate database code."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide"},"updatedAt":"2026-05-18T19:10:48.395Z"}}