{"id":"io.ddx.pg/archive","slug":"io-ddx-pg-archive","title":"pg.ddx.io: the PostgreSQL community's memory","description":"Every PostgreSQL mailing list since 1991, linked to the commits, code, commitfest and docs.","version":"2026.10.22","publisher":{"kind":"domain","id":"pg.ddx.io","label":"pg.ddx.io","url":"https://pg.ddx.io"},"website":"https://pg.ddx.io/","repository":"","remotes":[{"type":"streamable-http","url":"https://pg.ddx.io/mcp"},{"type":"sse","url":"https://pg.ddx.io/mcp/sse"}],"packages":[],"published":"2026-10-23","updated":"2026-10-23","status":"online","auth":"","latency_ms":1340,"checked":"2026-11-19","uptime":100,"checks":3,"tools":[{"name":"retrieve_context","title":"Retrieve Context","description":"START HERE for a question about PostgreSQL. Searches every mailing list (inbox narrows it) with hybrid keyword + semantic ranking and returns cited passages that fit token_budget (default 4000, max 32000): one passage per thread (with author, up to 3 of that person's messages per thread), each the author's own words (quotes, signature and patch removed, cut at ~1200 chars) with url, inbox, message","read_only":true},{"name":"animal_history","title":"Animal History","description":"One animal's runs, newest first; branch and since filter.","read_only":true},{"name":"animal_owner_contributions","title":"Animal Owner Contributions","description":"Animals one owner runs (owner_name or owner_email; at least one): the branches each tracks, last status, first_seen_at and days since.","read_only":true},{"name":"blame_symbol","title":"Blame Symbol","description":"The commits that changed a symbol's lines in its file.","read_only":true},{"name":"browse_by_date","title":"Browse by Date","description":"Threads active in a date range [since, until) on one list.","read_only":true},{"name":"build_status_freshness","title":"Build Status Freshness","description":"cfbot data age: last_build_at is the newest build finish time held (from GitHub Actions), seen_at the newest time our sync saw a result, build_count the builds stored. An old seen_at means our cfbot scraper stalled; an old last_build_at with a recent seen_at means cfbot itself has not built lately.","read_only":true},{"name":"buildfarm_overview","title":"Buildfarm Overview","description":"Buildfarm health: animal count, recent runs, failing animals, top owners, OS / branch breakdown, freshness.","read_only":true},{"name":"check_upstream_status","title":"Check Upstream Status","description":"Was a pull request merged upstream: the patch series' latest head commit and any merge information.","read_only":true},{"name":"code_index_status","title":"Code Index Status","description":"Code index statistics: files, symbols by kind and language, edges, communities.","read_only":true},{"name":"codebase_map","title":"Codebase Map","description":"File and symbol counts per directory.","read_only":true},{"name":"commit_buildfarm_status","title":"Commit Buildfarm Status","description":"Buildfarm results for one postgres commit: each animal that built it with branch, status (passed/failed/flapping), failing stage and log url, and a {passed, failed, flapping, unknown} rollup. Cite the SHA and log urls.","read_only":true},{"name":"commit_history","title":"Commit History","description":"Everything linked to one commit: subject, author and date with its sha, the message body (commit.message, trailers removed), the mail thread its Discussion: link names (participants resolved to people and organizations), the commitfest entry if tracked, and Discord mentions. For postgres also first_releases (per branch the change landed on: branch, sha, release e.g. 14.23 or null when unreleased, ","read_only":true},{"name":"commitfest_stats","title":"Commitfest Stats","description":"All commitfests: entries by status, top authors, and totals of people, commitfests and entries.","read_only":true},{"name":"contribution_summary","title":"Contribution Summary","description":"Per release: people, distinct commits, count of commits per role (canonical authoritative repos only), revert commits.","read_only":true},{"name":"detect_changes","title":"Detect Changes","description":"The symbols that changed between two commits (file content hashes).","read_only":true},{"name":"discussion_links","title":"Discussion Links","description":"A commit's Discussion / Closes / Fixes / Backpatch-through trailers: raw text and extracted URL. The mail they lead to, the committers announcement and mail citing the SHA: git_search (mail_refs).","read_only":true},{"name":"embedding_status","title":"Embedding Status","description":"Embedding coverage of a list: messages embedded, model, last run.","read_only":true},{"name":"entry_branches","title":"Entry Branches","description":"Repository branches tracked for a commitfest entry: repo, branch_name, is_authoritative.","read_only":true},{"name":"entry_history","title":"Entry History","description":"An entry's status across commitfests, matched by shared thread Message-ID (precise), else by title prefix (weak).","read_only":true},{"name":"find_breaks","title":"Find Breaks","description":"Animals that failed on a branch between two commits: from the first run of from_commit to the last run of to_commit on that branch (run times, not git order: the buildfarm has no commit order).","read_only":true},{"name":"find_contributions","title":"Find Contributions","description":"One person's contribution rows: commit SHAs and animals, each with role and release. By email, else name.","read_only":true},{"name":"find_dead_code","title":"Find Dead Code","description":"Functions and methods nothing calls (no incoming call edges).","read_only":true},{"name":"find_entries_for_author","title":"Find Entries for Author","description":"Commitfest entries a person authored: email (exact) or name (substring, case-sensitive).","read_only":true},{"name":"find_entries_for_thread","title":"Find Entries for Thread","description":"Commitfest entries whose page links any message of the thread.","read_only":true},{"name":"find_entries_with_failures_on","title":"Find Entries With Failures on","description":"An animal's recent failed runs, and commitfest entries failing in cfbot on branches it tracks. Correlated by branch and time (buildfarm builds commits, cfbot cf/<id> branches), not joined.","read_only":true},{"name":"find_failing_patches","title":"Find Failing Patches","description":"Commitfest entries whose latest cfbot build fails on a platform: cf_id, title, entry_status, needs_rebase (the build is of an older version: the newest does not apply), commitfest_number. Cite https://commitfest.postgresql.org/patch/<cf_id>/.","read_only":true},{"name":"find_failing_runs","title":"Find Failing Runs","description":"The newest failing buildfarm runs fleet-wide: what is broken now.","read_only":true},{"name":"find_passing_long_pending","title":"Find Passing Long Pending","description":"Entries green on every platform that apply to master, not updated for min_days: why isn't it committed?","read_only":true},{"name":"find_patches_by_platform_status","title":"Find Patches by Platform Status","description":"Entries passing on one platform and failing on another (e.g. linux vs macos: a portability bug).","read_only":true},{"name":"find_pattern","title":"Find Pattern","description":"Regex search of code symbol bodies (trigram-indexed).","read_only":true},{"name":"find_rebase_needed_patches","title":"Find Rebase Needed Patches","description":"Entries cfbot says no longer apply to master: they need a rebase.","read_only":true},{"name":"find_related_discussions","title":"Find Related Discussions","description":"Mail related to a commit, topic or PR. A postgres commit SHA (7-40 hex): the mail that refers to it (match_mode commit): Discussion: threads, then the committers announcement, then mail citing the hash, each with how_it_refers. Otherwise a case-insensitive substring of subjects and Message-IDs; no hit falls back to semantic search over every list.","read_only":true},{"name":"find_similar_messages","title":"Find Similar Messages","description":"Messages near one message by embedding: related or duplicate threads.","read_only":true},{"name":"get_animal","title":"Get Animal","description":"One animal: hardware, OS, compiler, owner, branches, last status, its last 20 runs.","read_only":true},{"name":"get_attachment","title":"Get Attachment","description":"One attachment of a message, whole: by 1-based index or filename substring (as get_message/get_thread list them). Text as text whatever its type (a .patch is ready for git apply); binary as base64 (encoding=base64). size = decoded bytes; url downloads it. Large text: read it in pieces with start_line/end_line (2000 lines a call; total_lines and cut say what is left). Cite https://postgr.es/m/<mess","read_only":true},{"name":"get_author_messages","title":"Get Author Messages","description":"One list's messages from a sender (name or address, as search's f:), newest first; since/until bound them.","read_only":true},{"name":"get_callees","title":"Get Callees","description":"What a symbol calls or references (forward call graph).","read_only":true},{"name":"get_callers","title":"Get Callers","description":"Reverse call graph: who calls or references qualified_name, with file and lines (like `git grep -w` on call sites). HEAD only; macros and function pointers are not followed. Read one with git_show_file at its line.","read_only":true},{"name":"get_commitfest","title":"Get Commitfest","description":"One commitfest: entries by status and its top authors.","read_only":true},{"name":"get_communities","title":"Get Communities","description":"Louvain clusters of the call graph: related symbols by functional area.","read_only":true},{"name":"get_community","title":"Get Community","description":"One community and its symbols.","read_only":true},{"name":"get_contributor","title":"Get Contributor","description":"A contributor by email (exact) or name (substring): canonical name, page hash, totals and per-release counts by role (authored, reviewed, committed, reported, ...), the 5 latest credited commits (commit_sha = git SHA, roles = their roles in it) and animals they own. People who hid their page are left out of name lookups. Recent activity: whats_new. Cite https://pg.ddx.io/community/<hash>.","read_only":true},{"name":"get_contributor_history","title":"Get Contributor History","description":"Every list message from a sender (address or name).","read_only":true},{"name":"get_dependents","title":"Get Dependents","description":"Transitive dependents: the blast radius if this symbol changes.","read_only":true},{"name":"get_doc_page","title":"Get Doc Page","description":"One docs page as text: url, path, body, fetched_at. Find the path with search_docs; cite the url.","read_only":true},{"name":"get_entry","title":"Get Entry","description":"One commitfest entry by cf_id: title, status, commitfest, authors, reviewers, committer, mail threads and branches. Thread: get_thread; cfbot: find_failing_patches. Cite https://commitfest.postgresql.org/patch/<cf_id>/.","read_only":true},{"name":"get_execution_flows","title":"Get Execution Flows","description":"Execution paths through the call graph from entry points.","read_only":true},{"name":"get_impact","title":"Get Impact","description":"Impact of changing a symbol: risk level, blast radius, communities and flows affected.","read_only":true},{"name":"get_inbox_info","title":"Get Inbox Info","description":"A list's name, addresses, message_count and last activity. message_count counts a cross-posted message on each list (search shows one copy), never a patch file split out of its message; list_sources, get_inbox_stats and get_inbox_summary give the same number.","read_only":true},{"name":"get_inbox_stats","title":"Get Inbox Stats","description":"A list's message counts per period, top authors and trends. total_messages = get_inbox_info's message_count; oldest_date, newest_date and messages_by_period skip a Date: that did not parse, one in the future, and a broken clock dated years before the list began.","read_only":true},{"name":"get_inbox_summary","title":"Get Inbox Summary","description":"One list: total messages, top 10 posters, threads, date range, average messages per day over its life.","read_only":true},{"name":"get_message","title":"Get Message","description":"One message by Message-ID: headers, in_reply_to/references, decoded body (default the author's own words: quoted replies and attributions, forwarded or Outlook-quoted mail, inline patches, diffstats and signature removed; full_text=true for everything), attachments [{index, filename, content_type, size}], has_patch. quotes: each comes back with own_words (in their own text, whitespace-normalized) ","read_only":true},{"name":"get_message_headers","title":"Get Message Headers","description":"A message's headers as key/value pairs, all or one.","read_only":true},{"name":"get_message_references","title":"Get Message References","description":"A message's references: References/In-Reply-To and Message-IDs in its body, each looked up in the archive.","read_only":true},{"name":"get_new_messages","title":"Get New Messages","description":"Messages after an article-number cursor, to poll without rescanning: after=0 first, then the returned last_article_num.","read_only":true},{"name":"get_patch_branches","title":"Get Patch Branches","description":"Git branches made from a pull request's patch series.","read_only":true},{"name":"get_patch_build_history","title":"Get Patch Build History","description":"Build matrix for one entry: per-job status (passing, failing, building, paused), platform, config, log URL, at (when the job finished on GitHub Actions; null while building or not fetched yet), started_at, seen_at (when our sync first saw this result), and a rollup with last_build_at (the newest job finish; null if none), seen_at, passing_platforms, failing_platforms, applies_cleanly and needs_reb","read_only":true},{"name":"get_patch_series","title":"Get Patch Series","description":"Every iteration of a pull request posted to the lists.","read_only":true},{"name":"get_raw_message","title":"Get Raw Message","description":"A message's raw RFC 822 bytes.","read_only":true},{"name":"get_repo_sync_stats","title":"Get Repo Sync Stats","description":"A repository's commit cadence (median interval, suggested poll) and fetch log.","read_only":true},{"name":"get_repository_summary","title":"Get Repository Summary","description":"One repository: commits, top 10 contributors, branches, languages (indexed symbols), most-touched paths (sampled).","read_only":true},{"name":"get_signature","title":"Get Signature","description":"A symbol's signature and doc comment.","read_only":true},{"name":"get_source_info","title":"Get Source Info","description":"One source by name, as list_sources has it: kind, item_count, last_update, next_sync, freshness_status, description; a postgresql.org list also has poll: p_new (P(mail we lack since its last poll)), due, next_poll, factors, last outcome.","read_only":true},{"name":"get_symbol","title":"Get Symbol","description":"A symbol by qualified name: source, signature, docs, file location.","read_only":true},{"name":"get_tests_for","title":"Get Tests for","description":"Test symbols that reference a symbol.","read_only":true},{"name":"get_thread","title":"Get Thread","description":"A thread by any of its Message-IDs, oldest first. Each message: from, to, cc, date, message_id, decoded body (default own words: quotes, signature, inline patch removed; full_text=true for all; never raw MIME), attachments [{index, filename, content_type, size}], has_patch. 20 messages per page (limit max 500; offset, next_offset, has_more); bodies cut at max_body_chars (body_truncated). include_b","read_only":true},{"name":"get_thread_references","title":"Get Thread References","description":"A thread's cross-reference graph: Message-IDs cited in its bodies and the threads they point to.","read_only":true},{"name":"get_wiki_history","title":"Get Wiki History","description":"A wiki page's revisions.","read_only":true},{"name":"get_wiki_page","title":"Get Wiki Page","description":"One wiki.postgresql.org page by title (\"Don't Do This\", \"Todo\"): latest revision, author, date. Find titles with search_wiki, older revisions with get_wiki_history. Cite https://wiki.postgresql.org/wiki/<title>.","read_only":true},{"name":"git_analyze_activity","title":"Git Analyze Activity","description":"Commits per period: development pace.","read_only":true},{"name":"git_analyze_authors","title":"Git Analyze Authors","description":"Per author: commits, first and last date; by commit count.","read_only":true},{"name":"git_analyze_bus_factor","title":"Git Analyze Bus Factor","description":"Files with the fewest distinct authors (knowledge silos).","read_only":true},{"name":"git_analyze_churn","title":"Git Analyze Churn","description":"Most often changed files.","read_only":true},{"name":"git_analyze_coupling","title":"Git Analyze Coupling","description":"File pairs often changed together (hidden dependencies).","read_only":true},{"name":"git_analyze_hotspots","title":"Git Analyze Hotspots","description":"Churn per directory: the most changed areas.","read_only":true},{"name":"git_blame","title":"Git Blame","description":"A file's version history, not per-line blame (that is blame): the commits that changed it on a commit's history (git log <rev> -- <path>), newest first: sha, commit_id, author, date, summary, status (added/modified/deleted). Renames not followed. has_more: older ones exist.","read_only":true},{"name":"git_diff","title":"Git Diff","description":"Two modes: range (head_branch, optionally base_branch: commits in head not in base, filtered by author/message/path) or diff (from_commit, to_commit: unified diffs between two commits).","read_only":true},{"name":"git_log","title":"Git Log","description":"Commit history like `git log`, newest first; path, author (substring), since/until and branch (any branch, tag or major such as 17 or 9.6; default the indexed branch) filter. Each commit: sha (cite it), commit_id, message (subject for a branch log), author, dates. has_more.","read_only":true},{"name":"git_search","title":"Git Search","description":"Commit messages (or paths with search_in=paths) by keywords, newest first: every word, case-insensitive (git log -i --grep per word). Each commit: sha (cite it), commit_id, message, author, date, people credited, mail_refs (up to 5 messages that refer to it {inbox, message_id, subject, url, how_it_refers: discussion-trailer, committers-announcement or mentions-hash}). A SHA or 7+ hex prefix return","read_only":true},{"name":"git_show_file","title":"Git Show File","description":"A file at any commit (git show <rev>:<path>) from the clone. An unknown name or path is an error, never a silent HEAD. At most 2000 lines a call: start_line/end_line pick them, total_lines gives the length, cut=true says more follow. Lines numbered with a tab unless numbered=false. sha (cite it with path and lines) and ref; a binary file returns a note.","read_only":true}],"server_info":{"name":"pg.ddx.io","version":"1.0"},"category":"developer","tags":["communication","data","productivity"],"kind":"remote","source":"registry","submitted":{},"first_party":true,"domain_rank":714837,"score":100,"indexable":true,"first_seen":"2026-10-23","stars":0,"badges":["official","new"],"sponsor":null,"page":"https://agentsindex.org/agents/io-ddx-pg-archive/"}