pg-aiguide provides AI coding assistants with semantic search across the official PostgreSQL manual (version-aware) and curated, opinionated PostgreSQL best practices through AI-optimized skills that help generate higher-quality database schemas. The server addresses the problem of AI-generated PostgreSQL code being outdated, missing constraints and indexes, and unaware of modern features by delivering deep, versioned PostgreSQL knowledge and proven patterns. It operates as an Agent Skill, public MCP server, or Claude Code plugin and includes ecosystem documentation for extensions like TimescaleDB.
claude mcp add --transport stdio timescale-pg-aiguide uvx pg-aiguide