AgentIndex icon
AgentIndex
ToolsCategoriesTrendingNewCompare
Submit Tool
Home/
RAG / Knowledge Base/
pg-aiguide
pg-aiguide logo

pg-aiguide

Active·★ 1.7k·Apache-2.0·Updated 2026-05-21
★ Code Assistant★ Dev Tooling

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

pg-aiguide enhances AI coding tools by providing deep, versioned PostgreSQL knowledge and proven best practices, helping them generate dramatically better database code. It prevents AI from producing outdated, incomplete, or non-optimal Postgres schemas by integrating semantic search of manuals and AI-optimized "skills."

#PostgreSQL#AI Assistant#Code Generation#Database Schema#Best Practices#Semantic Search#TimescaleDB#Developer Tools
$ Install
$ claude plugin marketplace add timescale/pg-aiguide && claude plugin install pg@aiguide
↗ Visit site★ GitHub
01

Features

01Performs semantic search across the official PostgreSQL manual, with results scoped to a specific Postgres version.
02Provides AI-optimized "skills" that offer curated, opinionated PostgreSQL best practices for AI agents.
03Supports documentation for the PostgreSQL extension ecosystem, starting with TimescaleDB.
04Improves AI-generated database schemas with more constraints, indexes, and modern PostgreSQL features.
05Offers guidance on schema design, indexing strategies, data types, and performance tuning.
02

Compatibility

AI Coding Agents
Target Audience
Verified via docs
Claude Code
Plugin
Verified via docs
Cursor
IDE Integration
Verified via docs
VS Code
IDE Integration
Verified via docs
VS Code Insiders
IDE Integration
Verified via docs
Visual Studio
IDE Integration
Verified via docs
03

Quick start

1
$ claude plugin marketplace add timescale/pg-aiguide
2
$ claude plugin install pg@aiguide
04

Use cases

↳Improving the quality and robustness of PostgreSQL code generated by AI coding assistants.
↳Designing optimal and performant PostgreSQL database schemas with AI assistance.
↳Accessing version-aware PostgreSQL documentation and best practices via AI semantic search.
↳Integrating advanced PostgreSQL expertise into various AI coding agents and IDEs.
↳Leveraging modern PostgreSQL features and best practices in AI-assisted development for better data integrity and performance.
05

Alternatives

mindsdb logo
mindsdb★ 39.2k
Federated Query Engine for AI - The only MCP Server you'll ever need
vs →
Brave Search MCP logo
Brave Search MCP★ 86.5k
Allow your AI Agent to search the real-time internet using Brave Search API. Essential for getting up-to-date information.
vs →
Context7 logo
Context7★ 56.4k
MCP Server that provides up-to-date code documentation for LLMs and AI code editors.
vs →
GitHub MCP Server logo
GitHub MCP Server★ 30.3k
GitHub's official MCP Server. Allows AI agents to interact directly with your GitHub repositories (read files, search code, issues).
vs →
CopilotKit logo
CopilotKit★ 31.8k
React UI + elegant infrastructure for AI Copilots, AI chatbots, and in-app AI agents. The Agentic Frontend.
vs →
genai-toolbox logo
genai-toolbox★ 15.4k
MCP Toolbox for Databases is an open source MCP server for databases.
vs →
chrome-devtools-mcp logo
chrome-devtools-mcp★ 42.3k
Chrome DevTools for coding agents
vs →
awesome-cursorrules logo
awesome-cursorrules★ 39.8k
📄 Configuration files that enhance Cursor AI editor experience with custom rules and behaviors
vs →
See all alternatives →

Related searches

pg-aiguide AlternativesBest RAG / Knowledge Base Tools 2026Open Source RAG / Knowledge Basepg-aiguide Tutorialpg-aiguide Vs CompetitorsPostgreSQLAI AssistantCode Generation

Comments

Log in to leave a comment
  • R
    Riley WilsonMay 21, 2026

    Significantly reduces the back-and-forth when generating complex PostgreSQL queries.

  • S
    Scout GarciaApr 16, 2026

    PostgreSQL skills and documentation via MCP means AI coding tools write better SQL, not just syntactically correct SQL.

  • P
    Peyton ClarkMar 9, 2026

    The Postgres-specific knowledge helps with things like index selection and query planning that generic AI misses.

  • A
    Alex WilsonFeb 28, 2026

    Works as a Claude plugin — Postgres expertise available inline during development.

On this page
01Features02Compatibility03Quick start04Use cases05Alternatives
Stats
GitHub Stars★ 1.7k
Last commit1w ago
StatusActive
LicenseApache-2.0
CategoryRAG / Knowledge Base
Trend (30d)
+0k↑ 1.6%
Links
Documentation↗Discussion↗Issues↗Releases↗

Deploy on DigitalOcean — Get $200 Free Credit

Ad
© 2026 AgentIndex.app|Built by a 10-year iOS Developer.
QYSGitHubBuy me a coffee ☕

Browse by Category

Code AssistantWorkflow AutomationRAG / Knowledge BaseMulti-AgentBrowser AutomationLLM InfraDev ToolingObservability

Not affiliated with Anthropic, OpenAI or Microsoft.