pg Aiguide MCP Server: Install & Setup

Install pg Aiguide in Claude Code

Remote URL

Claude Code

claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docs

mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)

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

npm

Claude Code

claude mcp add pg-aiguide -e OPENAI_API_KEY=... -e PGHOST=... -e PGPORT=... -e PGUSER=... -e PGPASSWORD=... -e PGDATABASE=... -- npx -y @tigerdata/pg-aiguide

mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "...",
        "PGHOST": "...",
        "PGPORT": "...",
        "PGUSER": "...",
        "PGPASSWORD": "...",
        "PGDATABASE": "..."
      }
    }
  }
}

Docker

Claude Code

claude mcp add pg-aiguide -e OPENAI_API_KEY=... -e PGHOST=... -e PGPORT=... -e PGUSER=... -e PGPASSWORD=... -e PGDATABASE=... -- docker run -i --rm -e OPENAI_API_KEY -e PGHOST -e PGPORT -e PGUSER -e PGPASSWORD -e PGDATABASE ghcr.io/timescale/pg-aiguide:0.6.1

mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "OPENAI_API_KEY",
        "-e",
        "PGHOST",
        "-e",
        "PGPORT",
        "-e",
        "PGUSER",
        "-e",
        "PGPASSWORD",
        "-e",
        "PGDATABASE",
        "ghcr.io/timescale/pg-aiguide:0.6.1"
      ],
      "env": {
        "OPENAI_API_KEY": "...",
        "PGHOST": "...",
        "PGPORT": "...",
        "PGUSER": "...",
        "PGPASSWORD": "...",
        "PGDATABASE": "..."
      }
    }
  }
}

Replace each ... with your own value.

Frequently asked questions

What does the pg Aiguide MCP server do?

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

Is the pg Aiguide MCP server free?

The server is free, but you will likely need an account. The server itself is free, but it connects to a service that needs an account or API key, which may have paid tiers. Check the provider for current pricing.

Does pg Aiguide run locally or remotely?

Local + Remote. Can run locally or be used as a hosted remote server.

How do I add pg Aiguide to Claude Code?

Run: claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docs

More databases MCP servers

View all

Qdrant

1.6k

qdrant/mcp-server-qdrant

Implement semantic memory layer on top of the Qdrant vector search engine

LocalFreePython

Mysql

2.2k

benborla/mcp-server-mysql

MySQL database integration with configurable access controls and schema inspection.

LocalAccount needed

MySQL

1.4k

designcomputer/mysql_mcp_server

MySQL database integration with configurable access controls, schema inspection and security guidelines.

LocalFreePython

Mindwtr

2.4k1.7k

dongdongbh/Mindwtr

Task automation via SQLite, desktop Local API, or Mindwtr Cloud; read-only by default.

LocalFree

ArcadeDB

1.2k

ArcadeData/arcadedb

Built into ArcadeDB, a multi-model database (graph, document, key-value, time-series, vector) with SQL, Cypher, Gremlin and MongoDB QL support.

LocalFreeJava

LINQ to DB

3.3k

linq2db/linq2db

Inspect database schemas and execute SQL queries across multiple database providers with LINQ to DB.

LocalFree