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

Tools observed via MCP handshake

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. (Returns empty until the mailing-list cross-reference scrape lands; the index attribute
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.
find_rebase_needed_patches — Entries cfbot reports as no longer applying to master tip (:entry/applies-cleanly is false). These need an author rebase.
find_related_discussions — Find mailing list messages related to a commit, topic, or PR. A postgres commit SHA (7-40 hex) returns the mail that refers to that commit (match_mode commit):
find_similar_messages — Find messages similar to a given message using its embedding vector. Useful for finding related discussions or duplicate threads.
get_animal — Profile of one buildfarm animal: hardware/OS/compiler/owner, branches tracked, last build status, plus the last 20 runs (any branch).
get_attachment — The content of one attachment of a mail message (a patch, a log, a test case), chosen by 1-based index or a filename substring, as listed in get_message/get_thr
get_author_messages — Find messages by a specific author, optionally filtered by date range. Uses the f: (from) search prefix.
get_callees — Find all symbols that the given symbol calls/references (forward call graph).
get_callers — Reverse call graph: the symbols that call or reference qualified_name (from search_symbols), each with its file and lines, like `git grep -w <name>` restricted
get_commitfest — Get a single commitfest with entries grouped by status and the top contributors (authors with the most entries).
get_communities — List Louvain community clusters detected in the call graph. Communities group related symbols by functional area.
get_community — Get details and member symbols for a specific community.
get_contributor — A contributor's profile by email (exact) or name (substring): canonical name, page hash, totals and per-release counts by role (authored, reviewed, committed, r
get_contributor_history — Show all past mailing list submissions by a contributor (matched by email address or name).
get_dependents — Get transitive dependents: all symbols in the blast radius if this symbol changes.
get_doc_page — One PostgreSQL documentation page as text: path (e.g. "brin.html" or "sql-createtable.html") and optional version ("17", "current"; default the latest). Returns
get_entry — One commitfest entry by cf_id (the number in commitfest.postgresql.org/patch/<cf_id>/): title, status, commitfest, authors, reviewers, committer, its mail threa
get_execution_flows — Trace execution flow paths through the call graph from entry points.
get_impact — Analyze the impact of modifying a symbol: risk level, blast radius, affected communities and execution flows.
get_inbox_info — Get metadata for an inbox (name, addresses, message count, last activity)
get_inbox_stats — Return aggregate statistics about an inbox: message counts by time period, top authors, and activity trends.
get_inbox_summary — Per-inbox summary: total messages, top 10 posters, thread count, date range, and lifetime average messages/day (total messages divided by the days spanned by th
get_message — One mail message by Message-ID: headers, in_reply_to/references, decoded body text (by default the author's own words: quotes, signature and inline patch remove
get_message_headers — Get email headers as structured key/value pairs. Returns all headers or a specific header by name.
get_message_references — Discover cross-references in a message. Returns explicit References/In-Reply-To headers plus any Message-IDs found in the body text, with archive lookup for eac
get_new_messages — Return messages newer than a given article number cursor, enabling agents to poll for new messages without re-scanning. Use after=0 for the first call, then use
get_patch_branches — Get the git branches created from a patch series. Shows what branches were applied from email patches for code intelligence analysis.
get_patch_build_history — Build matrix for one entry: per-platform/config status, log URL, observation time, applies-cleanly flag, rollup.
get_patch_series — Get patch submission history for a forge pull request URL. Returns all iterations submitted to the mailing list.
get_raw_message — Get the complete raw RFC 822 email bytes for a message. Useful for agents that need to parse headers/structure themselves or forward messages.
get_repo_sync_stats — Get commit frequency analysis and sync statistics for a repository. Returns median commit interval, recommended poll frequency, and recent fetch log.
get_repository_summary — Per-repository summary: total commits, top 10 contributors, branches, language breakdown (from indexed symbols), and a sampled most-touched-paths list.
get_signature — Get the function/method signature and doc comment for a symbol.
get_source_info — Detail for a single source by name, the same row list_sources returns. Returns kind, item_count, last_update, next_sync, freshness_status, and description.
get_symbol — Get full details for a code symbol by its qualified name, including source code, signature, documentation, and file location.
get_tests_for — Find test symbols that reference the given symbol.
get_thread — A mail thread, found by any Message-ID in it, oldest first. Each message: from, to, cc, date, message_id, decoded body text (by default the author's own words:
get_thread_references — Cross-reference graph for an entire thread. Collects all Message-IDs referenced in body text across all messages in the thread and resolves which other threads
get_wiki_history — Get revision history for a wiki page.
get_wiki_page — One wiki.postgresql.org page by title: its latest revision content with author and date. Titles are as on the wiki ("Don't Do This", "Todo"). Use search_wiki to
git_analyze_activity — Show commit activity over time, bucketed by period. Useful for understanding development pace and trends.
git_analyze_authors — Get commit statistics per author: total commits, first and last commit dates. Ranked by commit count.
git_analyze_bus_factor — Identify files with the fewest distinct authors (bus factor risk). Files modified by only one person are knowledge silos.
git_analyze_churn — Identify the most frequently modified files in the repository. High-churn files may indicate hotspots or unstable code.
git_analyze_coupling — Find files that are frequently changed together. Logical coupling can reveal hidden dependencies between components.
git_analyze_hotspots — Aggregate file churn by directory to find the most actively changed areas of the codebase.
git_blame — File version history, not a per-line blame: the commits that changed a file on the history of a commit (like `git log <rev> -- <path>`), newest first, each with
git_diff — Two modes: (1) commit-range mode — pass base_branch and head_branch to get the list of commits unique to head_branch (set difference base..head), optionally fil
git_log — Commit history like `git log`, newest first, filtered by path (commits touching a file), author (substring), since/until (YYYY-MM-DD or RFC 3339) and branch (an
git_search — Search postgres commit messages (or file paths with search_in=paths) by keywords, newest first (all words must appear, case-insensitive; like `git log -i --grep
git_show_file — Read a file at any commit, branch, tag or major version (like `git show <rev>:<path>`), from the git clone. commit takes a SHA (>= 7 hex), branch, tag, 17 or 9.
history-of — One-shot historical context for CI: given content (a diff, file path, symbol, commit subject, or feature name), return the most relevant default-branch commits,
hybrid_search — Mailing-list search, keyword (BM25 over the authors' own words) and semantic (embeddings) blended per thread, over every list unless inbox names one or more. Re
hybrid_search_code — Combined keyword + semantic code search using Reciprocal Rank Fusion. Requires embeddings to be generated.
list_animals — List PostgreSQL buildfarm animals. Filterable by OS, branch tracked, last build status, or owner. Failing animals are returned first (sort key: last_status='fai
list_branches — List tracked branches for a repository, including head commit and default branch status.
list_commitfests — List PostgreSQL commitfests indexed in the mentat triple store. Each commitfest carries a status (:open / :in-progress / :closed) and an entry count grouped by
list_contributors — List PostgreSQL community contributors aggregated across git trailers (Reviewed-by, Tested-by, etc.), commit author/committer headers, and buildfarm animal owne
list_discord_channels — List monitored Discord channels with message counts.
list_doc_versions — List available documentation versions with page counts.
list_entries — List commitfest entries (proposed patch series). Filterable by status, commitfest number, or topic; paginated.
list_inboxes — List all configured agora mailboxes with name, message_count, latest_message_date, latest_import_date, listid (when known) and description. Optional min_message
list_projects — List bridge-configured projects linking a forge repository to a mailing list inbox.
list_recent — List recent messages from an inbox
list_repositories — List all registered git repositories with name, branch, commit_count, file_count, indexed-symbol_count, latest_commit, last_fetched_at, and import_state. Option
list_sources — Every source behind this server with its kind (inbox, repository, docs, wiki, discord), item count, last update and freshness (fresh/stale): the 56 mailing list
list_threads — Browse recent threads (topic-level view). Returns thread summaries with message counts, date ranges, and latest message metadata.
recent_commitfest_activity — Rolling window of commitfest entries updated in the last N days. Returns the entries plus a status histogram. Uses the relational commitfest.entries table for p
search_commitfest — Full-text search of commitfest entries (title first, then author/reviewer/committer names), in the current commitfest by default, or commitfests="all" (back to
release_contributors — Top contributors per role for one release. Scope: canonical authoritative repos only (ag_repositories.is_authoritative = TRUE). Returns top 20 per role across a
repository_stats — Get detailed statistics for a git repository including commit count, file count, branch, and import state.

when	check	result	http	latency	detail
6 h ago	mcp initialize	ok	200	104 ms	server pg.ddx.io 1.0 · protocol 2025-06-18 · 125 tools
13 h ago	mcp initialize	ok	200	200 ms	server pg.ddx.io 1.0 · protocol 2025-06-18 · 125 tools
20 h ago	mcp initialize	ok	200	145 ms	server pg.ddx.io 1.0 · protocol 2025-06-18 · 125 tools
23 h ago	http get	failed	—	—	timeout
28 h ago	mcp initialize	ok	200	116 ms	server pg.ddx.io 1.0 · protocol 2025-06-18 · 125 tools
35 h ago	http get	failed	—	—	timeout
35 h ago	mcp initialize	ok	200	162 ms	server pg.ddx.io 1.0 · protocol 2025-06-18 · 125 tools

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

This record is unclaimed

Evidence

What the publisher says

Capabilities

Where this record came from