Categories › Data & Databases › SQL databases
Every PostgreSQL mailing list since 1991, linked to the commits, code, commitfest and docs.
Remote server: your requests and data go to pg.ddx.io. Claude Code: claude mcp add --transport http pg-ddx-io-the-postgresql-community-s-mem https://pg.ddx.io/mcp · Claude app: Settings → Connectors → Add custom connector.
The tools this server listed when we connected to it, in its own words.
retrieve_context — START HERE for a question about PostgreSQL. Searches every mailing list (inbox narrows it) with hybrid keyword + semantic ranking and returnanimal_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 andcommit_history — Everything linked to one commit: subject, author and date with its sha, the mail thread its Discussion: link names (participants resolved tocommitfest_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 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 theembedding_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_nameentry_history — Status changes for a commitfest entry across commitfests. The relational table doesn't carry an audit log, so we approximate the patch's liffind_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 observedfind_contributions — Find raw contribution rows for one person: git commit SHAs / buildfarm animals tagged with a role + release. Useful for drill-down on a contfind_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 commitfesfind_entries_with_failures_on — Cross-domain feed: recent failed buildfarm runs for a named animal, plus commitfest entries with cfbot :failing rollups whose tracked branchfind_failing_patches — Commitfest entries whose latest cfbot build fails on at least one platform: cf_id, title, entry_status and commitfest_number. entry_status ffind_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 thfind_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 (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 whole 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 lisget_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 -wget_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.Not tested by KitScout yet. When our harness runs it, pros, cons and the tasks we tried appear here, with the date and evidence.