by timescale
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
# Add to your Claude Code skills
git clone https://github.com/timescale/pg-aiguideAI-optimized PostgreSQL expertise for coding assistants
pg-aiguide helps AI coding tools write dramatically better PostgreSQL code. It provides:
Use it either as:
AI coding tools often generate Postgres code that is:
pg-aiguide fixes that by giving AI agents deep, versioned PostgreSQL knowledge and proven patterns.
https://github.com/user-attachments/assets/5a426381-09b5-4635-9050-f55422253a3d
<details> <summary>Video Transcript </summary>Prompt given to Claude Code:
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 current working directory. Then compare the two files and let me know which approach generated the better schema, using both qualitative and quantitative reasons. For this example, only use standard Postgres.
Result (summarized):
</details> <details> <summary>Manual MCP configuration using JSON</summary> </details>GENERATED ALWAYS AS IDENTITY, NULLS NOT DISTINCT)Conclusion: pg-aiguide produces more robust, performant, maintainable schemas.
pg-aiguide is available as a public MCP server:
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}
Or it can be used as a Claude Code Plugin:
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide