# Pg Aiguide (MCP server)

> Pg Aiguide is an MCP server that adds database tools to AI assistants such as Claude Desktop, Claude Code and Cursor. Comprehensive PostgreSQL documentation and best practices, including ecosystem tools. It has 1,857 GitHub stars, is released under the Apache-2.0 license and runs locally with npx -y @tigerdata/pg-aiguide.

AI-optimized PostgreSQL expertise for coding assistants pg-aiguide helps AI coding tools write dramatically better PostgreSQL code. It provides:

## Key facts

| Fact | Value |
|---|---|
| Repository | https://github.com/timescale/pg-aiguide |
| GitHub stars | 1,857 |
| License | Apache-2.0 |
| Language | Python |
| Transport | stdio, streamable-http |
| Packages | npm: @tigerdata/pg-aiguide; docker: ghcr.io/timescale/pg-aiguide:0.6.1 |
| Remote URL | https://mcp.tigerdata.com/docs |
| Needs API key | yes |
| Official | no |
| Works with | Claude Desktop, Claude Code, Cursor, VS Code, Claude.ai, ChatGPT |
| Category | Databases |
| Latest release | v0.6.1 (Sep 4, 2026) |
| Last commit | Sep 25, 2026 |
| MCP registry name | io.github.timescale/pg-aiguide |

## Install

### Claude Desktop (claude_desktop_config.json)

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

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

### Claude Code

```sh
claude mcp add --env OPENAI_API_KEY=your-value --env PGHOST=your-value --env PGPORT=your-value --env PGUSER=your-value --env PGPASSWORD=your-value --env PGDATABASE=your-value --transport stdio pg-aiguide -- npx -y @tigerdata/pg-aiguide
```

### Cursor (.cursor/mcp.json)

```json
{
  "mcpServers": {
    "pg-aiguide": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "your-value",
        "PGHOST": "your-value",
        "PGPORT": "your-value",
        "PGUSER": "your-value",
        "PGPASSWORD": "your-value",
        "PGDATABASE": "your-value"
      }
    }
  }
}
```

Project file; use ~/.cursor/mcp.json to enable it in every project.

### VS Code (.vscode/mcp.json)

```json
{
  "inputs": [
    {
      "type": "promptString",
      "id": "openai_api_key",
      "description": "OPENAI_API_KEY",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pghost",
      "description": "PGHOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pgport",
      "description": "PGPORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pguser",
      "description": "PGUSER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pgpassword",
      "description": "PGPASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pgdatabase",
      "description": "PGDATABASE",
      "password": true
    }
  ],
  "servers": {
    "pg-aiguide": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "${input:openai_api_key}",
        "PGHOST": "${input:pghost}",
        "PGPORT": "${input:pgport}",
        "PGUSER": "${input:pguser}",
        "PGPASSWORD": "${input:pgpassword}",
        "PGDATABASE": "${input:pgdatabase}"
      }
    }
  }
}
```

### Claude Code (remote)

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

The same server is also hosted as a remote MCP endpoint, so nothing runs on your machine.

Config formats checked against the official docs on 2026-10-07.

## Environment variables

- `OPENAI_API_KEY` (secret) (required): Your API key for text embeddings via OpenAI
- `PGHOST` (secret) (required): PostgreSQL host to connect to
- `PGPORT` (secret) (required): PostgreSQL port to connect to
- `PGUSER` (secret) (required): PostgreSQL user to connect as
- `PGPASSWORD` (secret) (required): PostgreSQL password to connect with
- `PGDATABASE` (secret) (required): PostgreSQL database to connect to
- `DB_SCHEMA` (secret): PostgreSQL database schema to use

## Similar MCP servers

- [Dbx](https://appsgit.com/mcp-servers/dbx): Query databases from AI agents using connections configured in DBX. (24,945 stars, Apache-2.0)
- [Butterbase AI MCP Server](https://appsgit.com/mcp-servers/butterbase-ai-mcp-server): Butterbase MCP server — manage your backend: schemas, auth, functions, storage, RAG, deploys. (3,686 stars, Apache-2.0, needs API key)
- [DBHub](https://appsgit.com/mcp-servers/dbhub): Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite. (3,610 stars, MIT, needs API key)
- [LINQ to DB](https://appsgit.com/mcp-servers/linq-to-db): Inspect database schemas and execute SQL queries across multiple database providers with LINQ to DB. (3,332 stars, MIT)
- [Mindwtr](https://appsgit.com/mcp-servers/mindwtr): Task automation via SQLite, desktop Local API, or Mindwtr Cloud; read-only by default. (2,211 stars, AGPL-3.0, needs API key)
- [MCP Memory Service](https://appsgit.com/mcp-servers/mcp-memory-service): Open-source persistent memory for AI agent pipelines (LangGraph, CrewAI, AutoGen) and Claude. (1,988 stars, Apache-2.0)

---

Canonical page: https://appsgit.com/mcp-servers/pg-aiguide
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.