MCP tool reference

hybrid_search

Combined keyword + semantic search using Reciprocal Rank Fusion (RRF). Merges BM25 full-text results with vector similarity results for better relevance. Requires embeddings to be generated. Each result carries an 'excerpt': the author's own words, quoted text and signatures removed.

semantic_search

Search messages by semantic similarity using vector embeddings. Returns messages most similar in meaning to the query text. Requires embeddings to be generated first (see embedding_status). Each result carries an 'excerpt': the author's own words, quoted text and signatures removed.

search

Full-text search across mailing list messages. Supports prefix syntax: s:subject f:from t:to d:2024-01..2025-01 b:body_text. Each result carries an 'excerpt': the author's own words, quoted text and signatures removed.

search-regex

Full-text search across mailing list messages using POSIX regex patterns. Supports edit-distance fuzzy matching via the `k` parameter (0 = exact regex, >=1 = up to k insertions/deletions/substitutions per match). Same prefix syntax as `search`: s:subject f:from t:to d:2024-01..2025-01 b:body_text

get_message

Get a message by Message-ID, including headers, body, and attachment metadata. Pass body_only=true to receive just the first text/plain MIME part as 'body' (headers, HTML alternatives, and base64 attachments stripped); use get_raw_message for the full RFC822 envelope.

get_thread

Messages in a thread, found by any Message-ID in it. PAGED: returns up to 20 messages per call (limit, max 500) with has_more / next_offset; bodies are capped at 4000 characters each (max_body_chars; 0 = no cap, body_truncated marks a cut). Pass include_bodies=false for a cheap outline of the whole thread first, then fetch the messages you need with get_message.

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_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 each.

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 they point to.

get_attachment

Download the content of an attachment from a message. Identify the attachment by 1-based index or filename substring match. Text attachments are returned as text; binary attachments as base64.

find_similar_messages

Find messages similar to a given message using its embedding vector. Useful for finding related discussions or duplicate threads.

find_related_discussions

Find mailing list messages related to a commit, topic, or PR. Searches subject and Message-ID fields via case-insensitive substring; if substring search returns no hits and an embedding provider is configured, falls back to semantic search across all inboxes.

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, the associated mailing-list discussion (message links), and the tracked people involved (community page links). Read-only; composes git history + list search.

browse_by_date

Browse threads within a specific date range. Useful for exploring what was discussed during a particular time period.

get_patch_series

Get patch submission history for a forge pull request URL. Returns all iterations submitted to the mailing list.

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_author_messages

Find messages by a specific author, optionally filtered by date range. Uses the f: (from) search prefix.

get_contributor_history

Show all past mailing list submissions by a contributor (matched by email address or name).

search_patches

Find patch series by parsing [PATCH v2 3/7]-style subject prefixes. Returns structured patch metadata including version, sequence, total, and series grouping.

list_threads

Browse recent threads (topic-level view). Returns thread summaries with message counts, date ranges, and latest message metadata.

list_recent

List recent messages from an inbox

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 the returned last_article_num as the cursor for subsequent calls.

list_inboxes

List all configured agora mailboxes with name, message_count, latest_message_date, latest_import_date, listid (when known) and description. Optional min_messages filter; limit/offset are accepted for forward compatibility.

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 the archive).

embedding_status

Get embedding coverage statistics: how many messages have embeddings, which model was used, and when embeddings were last generated.

git_search

Search git commit messages or file paths by keyword (case-insensitive substring match).

commit_history

Cross-source historical overview of a git commit: the commit, the email discussion thread it links to (via its postgr.es/m/ Discussion link), the thread participants resolved to canonical people + organizations, the commitfest entry if tracked, and any Discord messages referencing it. Connects git → mailing list → commitfest → Discord → people knowledge graph for one change.

discussion_links

Discussion / Closes / Fixes / Backpatch-through trailers attached to one commit. Returns the raw trailer text and any URL extracted.

git_log

Browse commit history with optional filters by branch, path, author, and date range. Returns commits in reverse chronological order.

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 filtered by author/message/path; (2) content-diff mode — pass from_commit and to_commit to compute file-level unified diffs between two specific commits.

git_blame

Show the modification history for a file: which commits changed it, with author and summary for each version.

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. Optional min_commits and branch filters; limit/offset accepted for forward compatibility.

list_branches

List tracked branches for a repository, including head commit and default branch status.

repository_stats

Get detailed statistics for a git repository including commit count, file count, branch, and import state.

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_repo_sync_stats

Get commit frequency analysis and sync statistics for a repository. Returns median commit interval, recommended poll frequency, and recent fetch log.

check_upstream_status

Check whether a pull request has been merged upstream. Returns the latest patch series head commit and any merge information.

list_projects

List bridge-configured projects linking a forge repository to a mailing list inbox.

No arguments.

git_show_file

Show the content of a file at a specific commit (or HEAD). Returns the file content as text, or indicates if binary.

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_churn

Identify the most frequently modified files in the repository. High-churn files may indicate hotspots or unstable code.

git_analyze_hotspots

Aggregate file churn by directory to find the most actively changed areas of the codebase.

git_analyze_coupling

Find files that are frequently changed together. Logical coupling can reveal hidden dependencies between components.

git_analyze_bus_factor

Identify files with the fewest distinct authors (bus factor risk). Files modified by only one person are knowledge silos.

search_all_sources

Unified search across all document sources (docs, wiki, and email). Returns results ranked by relevance.

search_docs

Full-text search across documentation pages. Returns matching pages ranked by relevance.

get_doc_page

Get a specific documentation page by path and optional version.

list_doc_versions

List available documentation versions with page counts.

No arguments.

search_wiki

Full-text search across wiki pages. Returns matching pages with latest revision content.

get_wiki_page

Get a wiki page with its latest revision content.

get_wiki_history

Get revision history for a wiki page.

search_discord_topics

Find PostgreSQL Discord discussions semantically related to a query. Returns only the channel, approximate date range, and participants of relevant conversations — never message content or links (per the Discord community agreement).

list_discord_channels

List monitored Discord channels with message counts.

No arguments.

search_symbols

Search code symbols by name, kind, or language. Uses multi-tier search: BM25 full-text, trigram fuzzy match, and body content search.

semantic_search_code

Search code symbols by semantic similarity using vector embeddings. Requires embeddings.

hybrid_search_code

Combined keyword + semantic code search using Reciprocal Rank Fusion. Requires embeddings to be generated.

find_pattern

Search for a regex pattern in code symbol bodies. Uses trigram indexes for acceleration.

get_symbol

Get full details for a code symbol by its qualified name, including source code, signature, documentation, and file location.

get_signature

Get the function/method signature and doc comment for a symbol.

blame_symbol

Show the commit history that modified a symbol's file, filtered to the symbol's line range.

symbols_in_file

List all code symbols defined in a file, ordered by line number.

get_callers

Find all symbols that call/reference the given symbol (reverse call graph).

get_callees

Find all symbols that the given symbol calls/references (forward call graph).

get_dependents

Get transitive dependents: all symbols in the blast radius if this symbol changes.

get_impact

Analyze the impact of modifying a symbol: risk level, blast radius, affected communities and execution flows.

get_tests_for

Find test symbols that reference the given symbol.

get_execution_flows

Trace execution flow paths through the call graph from entry points.

detect_changes

Detect which symbols changed between two commits by comparing file content hashes.

find_dead_code

Find functions/methods with zero incoming call graph edges (potentially unused code).

codebase_map

Get a directory-level overview of the codebase showing file counts and symbol counts per directory.

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.

code_index_status

Get code indexing statistics: files indexed, symbol counts by kind and language, edge count, community count.

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 status.

get_commitfest

Get a single commitfest with entries grouped by status and the top contributors (authors with the most entries).

commitfest_stats

Overview of all indexed commitfests: count by status, top contributors (entries authored), distinct people / commitfests / entries totals.

No arguments.

list_entries

List commitfest entries (proposed patch series). Filterable by status, commitfest number, or topic; paginated.

get_entry

Full detail for a commitfest entry: title, status, authors, reviewers, committer, thread message-ids, branches, last-updated time.

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.

build_status_freshness

Most recent :entry/last-build-at observation across all entries. Use to detect a stalled cfbot scraper.

No arguments.

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 shared :entry/thread-message-id (precise) and falling back to title-prefix substring (weak).

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 predictable latency.

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 :entry/thread-message-id is in the schema.)

find_failing_patches

List commitfest entries whose latest cfbot.cputube.org build is failing on at least one platform. Filterable by entry status (defaults to active reviewable statuses) and platform.

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 committed yet?' question.

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_rebase_needed_patches

Entries cfbot reports as no longer applying to master tip (:entry/applies-cleanly is false). These need an author rebase.

get_patch_build_history

Build matrix for one entry: per-platform/config status, log URL, observation time, applies-cleanly flag, rollup.

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 animal's. Note: buildfarm runs commit SHAs and cfbot runs cf/<id> branches, so this verb correlates by branch overlap and time window — not by direct schema join.

buildfarm_overview

High-level buildfarm health: animal count, recent run counts, currently-failing animals, top owners, OS / branch breakdown, and freshness.

No arguments.

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='failed' DESC, name ASC).

get_animal

Profile of one buildfarm animal: hardware/OS/compiler/owner, branches tracked, last build status, plus the last 20 runs (any branch).

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.

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_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 that branch — not by git topological order, since the buildfarm tables don't carry commit ordering.

commit_buildfarm_status

Per-animal status for one PostgreSQL commit: every animal that ran this commit, on which branch, with status and stage_failed. Returns a {passed,failed,flapping,unknown} rollup alongside.

get_contributor

Get a contributor's profile: canonical name, canonical email, all release-by-role counts, sample commits, owned buildfarm animals.

list_contributors

List PostgreSQL community contributors aggregated across git trailers (Reviewed-by, Tested-by, etc.), commit author/committer headers, and buildfarm animal owners. Sorted by total contributions descending. Filterable by release / role / source.

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 authored / reviewed / tested / reported / committed (per-role distinct-commit counts).

contribution_summary

Summary of contribution counts per release: unique people, distinct commits, role breakdown (count(DISTINCT commit_sha) per role, canonical authoritative repos only), and revert-commit count. Powers the /community hero strip.

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 work.

list_sources

Enumerate every data source backing the MCP server (mailing-list inboxes, git repositories, doc sites, wiki, discord). Returns each source with its kind, item count, last-update timestamp, and freshness classification (fresh/stale). The universe is small (~50 inboxes, ~10 repos, a few docs/wiki sources); no pagination is required, but limit/offset are accepted for forward compatibility.

get_source_info

Detail for a single source by name. Returns kind, item_count, last_update, next_sync, freshness_status, and description.