Pg Aiguide MCP Server

Access PostgreSQL manuals and curated best practices for enhanced AI-generated schemas.

Data last scanned today · Reviewed today

502 tools★ 1,797PythonApache-2.0

Overview

Pg Aiguide provides AI coding assistants with semantic search capabilities across official PostgreSQL, TimescaleDB, and PostGIS documentation. By integrating version-aware manual lookups and curated, opinionated development patterns, it assists agents in generating more performant and robust database schemas. The server functions as a public MCP implementation or a specialized plugin for tools like Claude Code. It focuses on improving common AI coding outcomes by injecting knowledge of modern PostgreSQL features, proper indexing strategies, and necessary data constraints.

Our verdict

This server carries a high-risk rating with a security score of 50/100. The primary risk stems from the fact that it is a community-maintained project rather than an official vendor release, and critical aspects such as authentication, OAuth support, and read-only modes have not yet been editorially reviewed. Given these unverified security dimensions, it should be used with caution in environments handling sensitive database configurations or production credentials.

Supports semantic search across multiple database documentation sets
Integrates with over 40 distinct AI coding agents
Uses a small dependency footprint of nine packages
Features documentation-backed patterns for PG17 and beyond

Lacks editorial security reviews for OAuth and authentication
Maintained by the community instead of an official database vendor
Read-only mode verification is currently pending

Setup

Claude Desktop

{
  "mcpServers": {
    "pg-aiguide": {
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "command": "npx"
    }
  }
}

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows), then restart Claude Desktop. Some servers require API keys or tokens as environment variables — check the project's README and add an "env" object if needed.

No read-only mode — running this grants full read/write access.
No built-in authentication — anyone with access to this config can invoke every tool it exposes.

Tools

Tool	Description	Risk
search_docs	Unified search tool supporting semantic and keyword search across PostgreSQL, Tiger Data, and PostGIS documentation sources.	low
view_skill	Exposes curated, opinionated PostgreSQL best-practice skills used automatically by AI coding assistants.	low

Compatibility

Client	Local	Docker	Remote	Read-only
ChatGPT
Claude Desktop
Cursor
VS Code
Windsurf

Frequently asked questions

›What documentation is searchable via this MCP server?

The server provides semantic search capabilities for the official PostgreSQL, TimescaleDB, and PostGIS manuals.

›How do I add pg-aiguide best-practice skills to my AI coding agent?

You can install curated PostgreSQL skills using the npx command 'npx skills add timescale/pg-aiguide --skill postgres', or run 'npx skills add timescale/pg-aiguide' to select individual skills interactively.

›Can I use pg-aiguide as a Claude Code plugin?

Yes, you can install it as a plugin by running 'claude plugin marketplace add timescale/pg-aiguide' followed by 'claude plugin install pg@aiguide'.

›What configuration is required to add the MCP server manually?

To configure it manually, add the pg-aiguide server with the URL 'https://mcp.tigerdata.com/docs' to your agent's MCP configuration JSON file.