Skill Detail
Ground PostgreSQL code generation in exact docs and best-practice skills through pg-aiguide
Give coding agents a PostgreSQL-specific reference layer with semantic doc search and curated schema, indexing, and constraint guidance before they generate database code.
Library & API ReferenceMCP
Library & API Reference
MCP
Security Reviewed
⭐ 1.7k GitHub stars
INSTALL WITH ANY AGENT
npx skills add agentskillexchange/skills --skill ground-postgresql-code-generation-in-exact-docs-and-best-practice-skills-through-pg-aiguide
Works best when you want a reusable capability, not another fragile one-off prompt.
At a glance
Tools required
An AI coding agent with MCP support or npx skills support, plus optional access to the public pg-aiguide docs server.
Install & setup
Add the MCP server at https://mcp.tigerdata.com/docs to your coding agent, or install the packaged skills with npx skills add timescale/pg-aiguide –skill postgres.
Author
Timescale
Publisher
Organization
Last updated
Apr 22, 2026
Quick brief
Use pg-aiguide when an agent is designing PostgreSQL schemas, indexes, or query patterns and needs authoritative, version-aware guidance instead of guessing from generic training data. The operator workflow is specific: connect the MCP server or install the packaged skills, search the official PostgreSQL and extension docs, and apply curated best-practice patterns during code generation. That keeps the listing skill-shaped, because it is about grounding database code generation in verified Postgres knowledge, not about listing PostgreSQL itself or a generic docs site.