# pg.ddx.io: the PostgreSQL community's memory

> pg.ddx.io: the PostgreSQL community's memory is a free MCP server for databases. Search PostgreSQL mailing lists, commits, commitfest and docs, each cross-linked. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Free
- **Platforms:** API, Web
- **Website:** https://pg.ddx.io
- **MCP Registry name:** io.ddx.pg/archive
- **Categories:** databases, knowledge and memory, developer tools
- **Listing updated:** 2026-11-15

## About

The archive holds 85 mailing lists and issue trackers back to 1991, 18 git repositories, the commitfest, cfbot, the buildfarm, docs for releases 14 to 19 and the wiki. Its distinguishing feature is linking: a thread lists the commits it produced, and a commit links the thread named in its Discussion line, so an agent can cite both.

A worked example on the site traces a cursor crash at temp_file_limit from the bug thread to the fix commit and the first releases that shipped it. Tools read code at any tag, branch or commit since 1996 with blame and grep, follow a patch through the commitfest and cfbot, and check buildfarm status. The default endpoint lists the core tools and /mcp/full lists all 126.

It is free, read-only and needs no account. Two optional cookies remember search settings, access logs are kept 7 days, and the site says it is run by one person as a public good. A legacy SSE endpoint exists for older clients.

## Features

- **Thread and commit linking:** Each thread lists its commits and each commit its discussion thread.
- **Code at any version:** Read files, blame and grep at any tag, branch or commit since 1996.
- **Commitfest tracking:** Follow patches through the commitfest, cfbot and buildfarm.
- **Hybrid search:** Keyword and semantic ranking across lists, docs, wiki and commits.
- **Search syntax:** Phrases, exclusions, site, date, regex and link filters.
- **126 tools:** Core set by default, full set at /mcp/full.

## Good for

- Find why a PostgreSQL behavior changed and cite the thread
- See which releases first shipped a bug fix
- Check where a commitfest patch stands
- Read a function as of an old release tag
- Find failing patches in the buildfarm

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http archive https://pg.ddx.io/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://pg.ddx.io/mcp
```

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

```json
{
  "mcpServers": {
    "archive": {
      "url": "https://pg.ddx.io/mcp"
    }
  }
}
```

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

```json
{
  "servers": {
    "archive": {
      "type": "http",
      "url": "https://pg.ddx.io/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "archive": {
      "serverUrl": "https://pg.ddx.io/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "archive": {
      "type": "http",
      "url": "https://pg.ddx.io/mcp"
    }
  }
}
```

## Tools

- `hybrid_search`: Keyword and semantic search across the archive.
- `cross_reference`: Link a thread and its commits.
- `get_thread`: Fetch a mailing list thread.
- `get_commit`: Commit details with first releases.
- `read_file`: Read a file at any tag, branch or commit.
- `blame`: Blame a file.
- `code_search`: Search the code.
- `search_commitfest`: Search commitfest entries.
- `get_entry`: Get a commitfest entry.
- `find_failing_patches`: Find patches failing in cfbot.
- `commit_buildfarm_status`: Buildfarm status for a commit.

## FAQ

### Does it need an account?

No key or account is needed.

### How many tools are there?

126 in total; the default endpoint lists the core tools.

### Which transports are offered?

Streamable HTTP, plus legacy SSE.

### What data is kept?

Two optional cookies; access logs are kept 7 days.

### Is it free?

Yes, free and read-only.

### Is pg.ddx.io: the PostgreSQL community's memory free?

Yes. pg.ddx.io: the PostgreSQL community's memory is free to use.

### How do I add pg.ddx.io: the PostgreSQL community's memory to Claude Code?

Run this command in your terminal: claude mcp add --transport http archive https://pg.ddx.io/mcp

### What are the best alternatives to pg.ddx.io: the PostgreSQL community's memory?

The closest alternatives to pg.ddx.io: the PostgreSQL community's memory are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

## Alternatives

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Nautilus Compass Memory](https://ai-powered.com/mcp/nautilus-compass-memory): Nautilus Compass Memory is an open-source MCP server for knowledge and memory.

---
Source: https://ai-powered.com/mcp/pg-ddx-io-the-postgresql-community-s-memory
