io.ddx.pg/archive

up checked 2026-11-11T08:37:47.562Z

Unclaimed · Unverified

Agent searches it appeared in, last 30 days: 0. Run this server? Claim the listing: verified label, uptime alerts and analytics.

Publisher-provided title

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

Publisher-provided description

Every PostgreSQL mailing list since 1991, linked to the commits, code, commitfest and docs.

Summary by lookupd

Searches PostgreSQL mailing lists, commits, commitfests and buildfarm results to answer questions and track patch and build status.

Install

Claude Code, remote (streamable-http)

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

Claude Code, remote (sse)

claude mcp add --transport sse archive https://pg.ddx.io/mcp/sse

Codex, remote (streamable-http)

codex mcp add archive --url https://pg.ddx.io/mcp

Codex, remote (sse)

codex mcp add archive --url https://pg.ddx.io/mcp/sse

Cursor, remote (streamable-http) → .cursor/mcp.json

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

Cursor, remote (sse) → .cursor/mcp.json

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

Other clients: docs. Or tell your agent: Set up lookupd for me: read https://lookupd.com/agent.md and follow it.

Tools (showing 30 of 126)

Publisher-provided text

• retrieve_context START HERE for a question about PostgreSQL. Searches every mailing list (inbox narrows it) with hybrid keyword + semantic ranking and returns cited passages tha
• animal_history Run timeline for one animal. Filterable by branch and start cutoff; ordered newest first.
• animal_owner_contributions Animals run by one owner: list, branches each tracks, last status, first_seen_at and elapsed days since first observation.
• blame_symbol Show the commit history that modified a symbol's file, filtered to the symbol's line range.
• browse_by_date Browse threads within a specific date range. Useful for exploring what was discussed during a particular time period.
• build_status_freshness Most recent :entry/last-build-at observation across all entries. Use to detect a stalled cfbot scraper.
• buildfarm_overview High-level buildfarm health: animal count, recent run counts, currently-failing animals, top owners, OS / branch breakdown, and freshness.
• check_upstream_status Check whether a pull request has been merged upstream. Returns the latest patch series head commit and any merge information.
• code_index_status Get code indexing statistics: files indexed, symbol counts by kind and language, edge count, community count.
• codebase_map Get a directory-level overview of the codebase showing file counts and symbol counts per directory.
• commit_buildfarm_status Buildfarm results for one PostgreSQL commit: every animal that built it, with branch, status (passed/failed/flapping), the failing stage and the log url, plus a
• commit_history Everything linked to one commit: subject, author and date with its sha, the mail thread its Discussion: link names (participants resolved to people and organiza
• commitfest_stats Overview of all indexed commitfests: count by status, top contributors (entries authored), distinct people / commitfests / entries totals.
• contribution_summary Summary of contribution counts per release: unique people, distinct commits, role breakdown (count(DISTINCT commit_sha) per role, canonical authoritative repos
• detect_changes Detect which symbols changed between two commits by comparing file content hashes.
• discussion_links Discussion / Closes / Fixes / Backpatch-through trailers attached to one commit. Returns the raw trailer text and any URL extracted. For the messages those link
• embedding_status Get embedding coverage statistics: how many messages have embeddings, which model was used, and when embeddings were last generated.
• entry_branches Repository branches tracked for a commitfest entry. Joins commitfest.entry_repos with ag_repositories so callers see repo name + branch_name + is_authoritative.
• entry_history Status changes for a commitfest entry across commitfests. The relational table doesn't carry an audit log, so we approximate the patch's lifeline by joining on
• find_breaks Animals that failed on a branch within the time window bounded by two commit SHAs. The window is defined by the earliest started_at observed for either SHA on t
• find_contributions Find raw contribution rows for one person: git commit SHAs / buildfarm animals tagged with a role + release. Useful for drill-down on a contributor's recent wor
• find_dead_code Find functions/methods with zero incoming call graph edges (potentially unused code).
• find_entries_for_author Find commitfest entries where the given person is an author. Looks up by email (exact) or by name (substring, case-sensitive).
• find_entries_for_thread Find commitfest entries linked to a pgsql-hackers thread by Message-ID. Resolves any Message-ID in the thread to the entries whose commitfest page links it.
• find_entries_with_failures_on Cross-domain feed: recent failed buildfarm runs for a named animal, plus commitfest entries with cfbot :failing rollups whose tracked branches overlap the anima
• find_failing_patches Commitfest entries whose latest cfbot build fails on at least one platform: cf_id, title, entry_status and commitfest_number. entry_status filters (default the
• find_failing_runs Most recent failing buildfarm runs across the entire fleet. Filterable by branch and start cutoff. Use to answer 'what is broken right now?'
• find_passing_long_pending Green patches stuck in review: entries whose builds pass on every platform yet whose :entry/last-updated is older than N days. Useful for the 'why isn't this co
• find_patches_by_platform_status Patches that pass on some platforms but not others. Example: passing on linux but failing on macos -> portability bug.
• find_pattern Search for a regex pattern in code symbol bodies. Uses trigram indexes for acceleration.

Details

• Version: 2026.10.22
• Transports: streamable-http, sse
• Uptime (7 days): 100%
• Median latency: 868 ms
• First indexed: 2026-11-01T09:03:00.602Z
• Last seen in registry: 2026-11-01T09:03:00.602Z
• Website: https://pg.ddx.io/

Badge for your README

Shows this live status and links here; updates hourly.

[![lookupd status](https://lookupd.com/badge/io.ddx.pg/archive.svg)](https://lookupd.com/servers/io.ddx.pg/archive)

• 62033 servers
• Last crawl: 2026-11-11T15:38:39.561Z
• API base: https://api.lookupd.com
• MCP URL: https://api.lookupd.com/mcp