MCP server and Claude plugin providing AI-optimized PostgreSQL skills and semantic documentation search.
pg-aiguide is easy to set up with strong trust signals. Check agent compatibility and use-case fit before adding it to your workflow.
gh repo view timescale/pg-aiguide --webOpen the official README and confirm the supported install method.
Add the server entry to your MCP client config.
Restart your agent and verify that the server tools appear.
Repository setup guidance
Strong trust signals; still review the README and permissions before production use.
Last commit was about 76 days ago.
1814 GitHub stars indicate community interest.
34 open issues signal maintenance load.
Apache-2.0 license detected.
2 security/trust notes recorded.
Setup difficulty is 2/5.
An MCP server that exposes llms.txt files to IDEs for context-aware development.
Optimize markdown documentation for LLMs and RAG systems, reducing token consumption by 67-95%.
Turn OpenAPI, MCP, Doxygen, godoc, rustdoc, and Markdown into static documentation sites you own.
Local-first MCP server that turns any public GitHub, GitLab, or Bitbucket repo into fresh, version-pinned documentation for AI coding assistants.
pg-aiguide helps AI coding tools write better PostgreSQL code by giving them curated best practices and the ability to search official documentation. It works as a plugin or server that AI assistants can use to improve database schemas and queries.
pg-aiguide is a tool designed to enhance AI coding assistants' ability to generate high-quality PostgreSQL code. It offers two main features: a collection of AI-optimized 'skills' that encode best practices for PostgreSQL development, and a semantic search capability over official documentation for PostgreSQL, TimescaleDB, and PostGIS. The skills are curated and opinionated, ensuring AI agents follow modern, efficient patterns. The semantic search is version-aware, so the AI can access documentation relevant to the specific PostgreSQL version in use. The tool can be integrated as an MCP server, a Claude Code plugin, or via Agent Skills using npx. It is particularly useful for developers using AI assistants like Claude Code, Cursor, or Codex to build database-backed applications. By providing this knowledge, pg-aiguide helps avoid common pitfalls such as missing constraints, outdated syntax, or suboptimal indexing, leading to more robust and performant database schemas.
1,814
Stars
104
Forks
34
Issues
Apache-2.0
License
MCP server and Claude plugin providing AI-optimized PostgreSQL skills and semantic documentation search.
Backend developers using AI coding assistants for database work., Database administrators who want to leverage AI for schema design., AI tool developers looking to enhance their agents' database capabilities.
The setup section provides repository-level starting guidance, not a guarantee of an independently verified installation. Check the official README and release notes.
The MCP server is public and may send queries to external servers; ensure sensitive data is not included in prompts. As with any AI tool, generated code should be reviewed for correctness and security before production use.
Similar or complementary options to evaluate include mcpdoc, llm-docs-builder, sourcey.
Aug 20, 2026