pg-aiguide

Overview

pg-aiguide is a comprehensive MCP server that enhances AI coding assistants with deep PostgreSQL knowledge. It provides semantic search across official PostgreSQL documentation, TimescaleDB, and PostGIS manuals, along with curated best-practice skills that help generate more robust, performant database code. The server can be used with multiple AI coding tools including Claude Code, Cursor, VS Code, and more than 40 other agents.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• search_docs

  Unified search tool supporting semantic and keyword search across PostgreSQL, TimescaleDB, and PostGIS documentation.

  Try:Search for information on JSONB data types in PostgreSQLTry:Find documentation about TimescaleDB hypertablesTry:Search for PostGIS spatial index techniques
• view_skill

  View curated PostgreSQL best-practice skills for schema design, indexing, and performance.

  Try:Show me skills for optimizing PostgreSQL query performanceTry:Get best practices for PostgreSQL schema designTry:View skills for PostgreSQL indexing strategies

Comparable tools

Installation

{
  "mcpServers": {
    "pg-aiguide": {
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide

npx skills add timescale/pg-aiguide --skill postgres

FAQ

What PostgreSQL versions are supported?

The server provides version-aware search across the official PostgreSQL manual, allowing you to query specific versions of PostgreSQL documentation.

Can I extend pg-aiguide with custom skills?

Yes, the project welcomes contributions of new PostgreSQL best-practice skills. See DEVELOPMENT.md for instructions on adding new skills and documentation.

On Hacker News

Recent discussion from the developer community.

• Show HN: Pg-aiguide – Write better PostgreSQL code with AI▲ 3
  Story by cevian · 2025-11-24

Compare pg-aiguide with