pg-aiguide — Postgres Skills + MCP Search

Practical Notes

• GitHub: 1,723 stars · 89 forks; pushed 2026-04-28 (verified via GitHub API).
• README quickstart includes npx skills add timescale/pg-aiguide --skill postgres and an interactive install mode.
• README provides a manual MCP config snippet and a public endpoint: https://mcp.tigerdata.com/docs.

Main

Make the “skills” measurable:

• Before you add skills, run your agent on one real migration task and keep the output.
• Add postgres skills, then repeat the same task and compare: naming, constraints, indexing, and clarity of comments.
• Treat the MCP doc search as a backstop: ask the agent to cite which manual section it relied on when generating non-trivial SQL.

This is a low-effort way to prevent “AI SQL roulette” from reaching production.

FAQ

Q: Is it only for Claude Code? A: No—README says it works with multiple agents via npx skills and also offers an MCP server endpoint.

Q: Do I need to self-host the MCP server? A: Not necessarily—README provides a public server URL for doc search.

Q: How do I avoid overfitting? A: Use skills as defaults, but still review migrations and require citations for risky changes.