Every PostgreSQL mailing list since 1991, linked to the commits, code, commitfest and docs.
Maintain this server? Claim it
Call this server's tools from your browser. Nothing to install.
Requests go through mcptry because browsers can't call most MCP servers directly. Header values are sent to the server for that request only and are never stored or logged.
Tool list from our last check. Connect live to refresh it.
Run timeline for one animal. Filterable by branch and start cutoff; ordered newest first.
Animal name
Max runs (1-1000, default 100)
Only runs with started_at >= this RFC3339 timestamp
Restrict to a single PG branch
Tool list last changed Oct 25, 2026.
Run timeline for one animal. Filterable by branch and start cutoff; ordered newest first.
| Argument | Type | Description |
|---|---|---|
| name* | string | Animal name |
| limit | number | Max runs (1-1000, default 100) |
| since | string | Only runs with started_at >= this RFC3339 timestamp |
| branch | string | Restrict to a single PG branch |
{
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Animal name"
},
"limit": {
"type": "number",
"description": "Max runs (1-1000, default 100)"
},
"since": {
"type": "string",
"description": "Only runs with started_at >= this RFC3339 timestamp"
},
"branch": {
"type": "string",
"description": "Restrict to a single PG branch"
}
}
}Animals run by one owner: list, branches each tracks, last status, first_seen_at and elapsed days since first observation.
| Argument | Type | Description |
|---|---|---|
| owner_name | string | Owner name (exact) |
| owner_email | string | Owner email (exact) |
{
"type": "object",
"required": [],
"properties": {
"owner_name": {
"type": "string",
"description": "Owner name (exact)"
},
"owner_email": {
"type": "string",
"description": "Owner email (exact)"
}
}
}Per-line blame of a postgres file at any commit (code-history index): the commit that wrote each line, as `git blame` with git's default diff. ignore_revs (default true) passes through the pgindent/reformat commits of .git-blame-ignore-revs when they replaced lines one-for-one; reverse adds the commit that removed each line later on the version's branch. At most 2000 lines per call; commits lists author, date and subject per short sha. Not the same as git_blame, which returns a file's commit history.
| Argument | Type | Description |
|---|---|---|
| path* | string | Path from the repository root |
| reverse | boolean | Also name the commit that later removed each line (default false) |
| version | string | Commit to read: a SHA or 7+ hex prefix, a branch (master, REL_17_STABLE), a tag (REL_17_0), a major (17, 9.6), a release (17.2), <ref>@YYYY-MM-DD (the branch's last commit by that day), or <ref>~N. Default: the newest release branch's head. |
| end_line | number | Last line (default start_line + 1999) |
| repository | string | Repository; only postgres is in the code-history index for now (the default). |
| start_line | number | First line (default 1) |
| ignore_revs |
Show the commit history that modified a symbol's file, filtered to the symbol's line range.
| Argument | Type | Description |
|---|---|---|
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| qualified_name* | string | Fully qualified symbol name |
{
"type": "object",
"required": [
"qualified_name"
],
"properties": {
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"qualified_name": {
"type": "string",
"description": "Fully qualified symbol name"
}
}
}Browse threads within a specific date range. Useful for exploring what was discussed during a particular time period.
| Argument | Type | Description |
|---|---|---|
| after* | string | Start date (YYYY-MM-DD or YYYYMMDD) |
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| limit | number | Maximum threads to return (1-200, default 50) |
| before* | string | End date (YYYY-MM-DD or YYYYMMDD) |
{
"type": "object",
"required": [
"after",
"before"
],
"properties": {
"after": {
"type": "string",
"description": "Start date (YYYY-MM-DD or YYYYMMDD)"
},
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum threads to return (1-200, default 50)"
},
"before": {
"type": "string",
"description": "End date (YYYY-MM-DD or YYYYMMDD)"
}
}
}Most recent :entry/last-build-at observation across all entries. Use to detect a stalled cfbot scraper.
No arguments.
{
"type": "object",
"required": [],
"properties": {}
}High-level buildfarm health: animal count, recent run counts, currently-failing animals, top owners, OS / branch breakdown, and freshness.
No arguments.
{
"type": "object",
"required": [],
"properties": {}
}List every pg.ddx.io calendar feed (iCalendar URLs) with event counts: all events, regions, countries, conference series, the PostgreSQL release cycle, teams and organisations.
No arguments.
{
"type": "object",
"required": [],
"properties": {}
}Check whether a pull request has been merged upstream. Returns the latest patch series head commit and any merge information.
| Argument | Type | Description |
|---|---|---|
| pr_url* | string | Forge pull request URL |
{
"type": "object",
"required": [
"pr_url"
],
"properties": {
"pr_url": {
"type": "string",
"description": "Forge pull request URL"
}
}
}Get code indexing statistics: files indexed, symbol counts by kind and language, edge count, community count.
| Argument | Type | Description |
|---|---|---|
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Search the postgres source at any commit, branch, tag or date (or across history), from the code-history index: every line of every commit, byte-exact. A literal by default; match=regex for a PostgreSQL regex (^ and $ are per line; \b \< \> as in grep), match=identifier for any of snake_case/CamelCase/UPPER spellings. File sets agree with `git grep -l` at the same commit. Results name the resolved sha and ref. complete=false means the totals are lower bounds (cut says why). With history (all | <rev> | A..B) it returns every matching line any commit in the range had, with the commit that added it and the one that removed it.
| Argument | Type | Description |
|---|---|---|
| limit | number | Results per page (1-2000, default 100) |
| match | string | How to read query (default literal) |
| paths | array | Directories or globs to search under, e.g. src/backend/storage |
| query* | string | Text, regex or identifier to find |
| offset | number | Results to skip (paging) |
| output | string | lines (default): each matching line with its number; files: paths with match counts; counts: [path, count] pairs |
| context | number | Lines of context around each match (0-20, default 0) |
Get a directory-level overview of the codebase showing file counts and symbol counts per directory.
| Argument | Type | Description |
|---|---|---|
| depth | number | Directory depth for grouping (default 2) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"depth": {
"type": "number",
"description": "Directory depth for grouping (default 2)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Combine several pg.ddx.io calendar feeds into ONE subscription. Give feed paths or URLs as listed by calendar_feeds (e.g. events/region/europe, series/pgconf-eu, teams/committers, people/<8hex>, https://pg.ddx.io/cal/orgs/edb.ics; 1-200). Returns the combined feed's hash, canonical feed list, https url and webcal url. The same selection always yields the same URL.
| Argument | Type | Description |
|---|---|---|
| feeds* | array | Feed paths or /cal/ URLs to combine |
| excludes | array | Feeds whose events are removed from the combination (but not), e.g. events/country/rs or teams/security-team |
{
"type": "object",
"required": [
"feeds"
],
"properties": {
"feeds": {
"type": "array",
"items": {
"type": "string"
},
"description": "Feed paths or /cal/ URLs to combine"
},
"excludes": {
"type": "array",
"items": {
"type": "string"
},
"description": "Feeds whose events are removed from the combination (but not), e.g. events/country/rs or teams/security-team"
}
}
}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 {passed, failed, flapping, unknown} rollup. commit_sha is a SHA (>= 7 hex) or a branch, tag or major version (17, 9.6) for the commit it points at. Cite the commit SHA and the log urls.
| Argument | Type | Description |
|---|---|---|
| commit_sha* | string | A commit SHA (>= 7 hex), or a branch, tag or major version (17, 9.6) for the commit it points at |
{
"type": "object",
"required": [
"commit_sha"
],
"properties": {
"commit_sha": {
"type": "string",
"description": "A commit SHA (>= 7 hex), or a branch, tag or major version (17, 9.6) for the commit it points at"
}
}
}Everything linked to one commit: subject, author and date with its sha, 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, first_version incl. betas, shipped=false when it was reverted before that release), reverted_by (the commits that revert it, each with its own reverted_by) and reverts, read from git tags and commit messages, never guessed. commit_id takes a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N or a commit_id from another tool; repository defaults to postgres. The diff itself is not included (git_diff, or git_show_file for one file). Cite the sha and the thread's https://postgr.es/m/<message_id>.
| Argument | Type | Description |
|---|---|---|
| commit_id* | string | The commit: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. |
{
"type": "object",
"required": [
"commit_id"
],
"properties": {
"commit_id": {
"type": "string",
"description": "The commit: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool."
}
}
}Overview of all indexed commitfests: count by status, top contributors (entries authored), distinct people / commitfests / entries totals.
No arguments.
{
"type": "object",
"required": [],
"properties": {}
}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.
| Argument | Type | Description |
|---|---|---|
| release | string | Restrict to one release; empty = all releases. |
{
"type": "object",
"required": [],
"properties": {
"release": {
"type": "string",
"description": "Restrict to one release; empty = all releases."
}
}
}What relates to one stored item, and what happened to it. ref: a Message-ID or message URL, a commit SHA or URL, a docs URL or page.html, a wiki URL or title, a commitfest URL, CVE-YYYY-NNNNN, or feature:<words> (matched to commitfest titles; ref.entries_used says which). Returns related threads, commits (with releases and reverted_by), docs, wiki pages, commitfest entries and people, each with why, strongest first: explicit links, shared identifiers, then similar topic. For a postgres commit, thread, entry or feature, timeline says which release shipped it and whether it was reverted or back-patched: status plus dated events (first post, commitfest listings, commits with branch and first release, reverts), each with its source url. kinds narrows; limit_per_kind (default 5, max 25). ~3 s budget: late parts go in timed_out. Same as GET /api/v2/related.
| Argument | Type | Description |
|---|---|---|
| ref* | string | The item: e.g. [email protected], https://www.postgresql.org/docs/current/brin.html, Don't Do This, b536d5a0bd7a, CVE-2024-10979, feature:incremental backup |
| kinds | array | Result kinds to return (default all) |
| version | string | Docs version for a page given without one (default current), e.g. 17 |
| timeline | boolean | Include the timeline (default true) |
| limit_per_kind | number | Items per kind (1-25, default 5) |
Detect which symbols changed between two commits by comparing file content hashes.
| Argument | Type | Description |
|---|---|---|
| to_commit | string | Target commit: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. Default HEAD. |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| from_commit* | string | Base commit: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. |
{
"type": "object",
"required": [
"from_commit"
],
"properties": {
"to_commit": {
"type": "string",
"description": "Target commit: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. Default HEAD."
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"from_commit": {
"type": "string",
"description": "Base commit: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool."
}
}
}Discussion / Closes / Fixes / Backpatch-through trailers attached to one commit. Returns the raw trailer text and any URL extracted. For the messages those links resolve to, plus the committers announcement and messages citing the SHA, use git_search (mail_refs on each result).
| Argument | Type | Description |
|---|---|---|
| commit_sha* | string | The commit: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. |
{
"type": "object",
"required": [
"commit_sha"
],
"properties": {
"commit_sha": {
"type": "string",
"description": "The commit: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool."
}
}
}Get embedding coverage statistics: how many messages have embeddings, which model was used, and when embeddings were last generated.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
{
"type": "object",
"required": [],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
}
}
}Repository branches tracked for a commitfest entry. Joins commitfest.entry_repos with ag_repositories so callers see repo name + branch_name + is_authoritative.
| Argument | Type | Description |
|---|---|---|
| cf_id* | number | commitfest.postgresql.org entry id |
{
"type": "object",
"required": [
"cf_id"
],
"properties": {
"cf_id": {
"type": "number",
"description": "commitfest.postgresql.org entry id"
}
}
}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).
| Argument | Type | Description |
|---|---|---|
| cf_id* | number | commitfest.postgresql.org entry id |
{
"type": "object",
"required": [
"cf_id"
],
"properties": {
"cf_id": {
"type": "number",
"description": "commitfest.postgresql.org entry id"
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| branch* | string | PG branch (e.g. master) |
| end_sha* | string | Later commit SHA (window upper bound) |
| start_sha* | string | Earlier commit SHA (window lower bound) |
{
"type": "object",
"required": [
"branch",
"start_sha",
"end_sha"
],
"properties": {
"branch": {
"type": "string",
"description": "PG branch (e.g. master)"
},
"end_sha": {
"type": "string",
"description": "Later commit SHA (window upper bound)"
},
"start_sha": {
"type": "string",
"description": "Earlier commit SHA (window lower bound)"
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| name | string | Person's name (substring; used when email is not given) |
| role | string | Restrict to one role |
| string | Person's canonical email | |
| limit | number | Max rows (1-500, default 50) |
| release | string | Restrict to one release |
{
"type": "object",
"required": [],
"properties": {
"name": {
"type": "string",
"description": "Person's name (substring; used when email is not given)"
},
"role": {
"type": "string",
"description": "Restrict to one role"
},
"email": {
"type": "string",
"description": "Person's canonical email"
},
"limit": {
"type": "number",
"description": "Max rows (1-500, default 50)"
},
"release": {
"type": "string",
"description": "Restrict to one release"
}
}
}Find functions/methods with zero incoming call graph edges (potentially unused code).
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results (1-200, default 50) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results (1-200, default 50)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Find commitfest entries where the given person is an author. Looks up by email (exact) or by name (substring, case-sensitive).
| Argument | Type | Description |
|---|---|---|
| name | string | :person/name substring (case-sensitive) |
| string | Exact :person/email | |
| limit | number | Max entries to return (1-500, default 100) |
{
"type": "object",
"required": [],
"properties": {
"name": {
"type": "string",
"description": ":person/name substring (case-sensitive)"
},
"email": {
"type": "string",
"description": "Exact :person/email"
},
"limit": {
"type": "number",
"description": "Max entries to return (1-500, default 100)"
}
}
}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.)
| Argument | Type | Description |
|---|---|---|
| message_id* | string | RFC822 Message-ID, with or without angle brackets |
{
"type": "object",
"required": [
"message_id"
],
"properties": {
"message_id": {
"type": "string",
"description": "RFC822 Message-ID, with or without angle brackets"
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| limit | number | Max recent failed runs (1-200, default 50) |
| animal_name* | string | Buildfarm animal name (e.g. fairywren) |
{
"type": "object",
"required": [
"animal_name"
],
"properties": {
"limit": {
"type": "number",
"description": "Max recent failed runs (1-200, default 50)"
},
"animal_name": {
"type": "string",
"description": "Buildfarm animal name (e.g. fairywren)"
}
}
}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 active reviewable statuses, e.g. needs-review, ready-for-committer); platform narrows to one CI platform; limit caps the list. Cite https://commitfest.postgresql.org/patch/<cf_id>/.
| Argument | Type | Description |
|---|---|---|
| limit | number | Max entries (1-500, default 100) |
| platform | string | Restrict to entries failing on this platform keyword (e.g. linux, macos, windows, freebsd, netbsd, openbsd). |
| entry_status | string | Restrict to entries in this status (e.g. needs-review, ready-for-committer). Default: any active status. |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Max entries (1-500, default 100)"
},
"platform": {
"type": "string",
"description": "Restrict to entries failing on this platform keyword (e.g. linux, macos, windows, freebsd, netbsd, openbsd)."
},
"entry_status": {
"type": "string",
"description": "Restrict to entries in this status (e.g. needs-review, ready-for-committer). Default: any active status."
}
}
}Most recent failing buildfarm runs across the entire fleet. Filterable by branch and start cutoff. Use to answer 'what is broken right now?'
| Argument | Type | Description |
|---|---|---|
| limit | number | Max runs (1-1000, default 100) |
| since | string | Only runs with started_at >= this RFC3339 timestamp (default: 24h ago) |
| branch | string | Restrict to a single PG branch |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Max runs (1-1000, default 100)"
},
"since": {
"type": "string",
"description": "Only runs with started_at >= this RFC3339 timestamp (default: 24h ago)"
},
"branch": {
"type": "string",
"description": "Restrict to a single PG branch"
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| limit | number | Max entries (1-500, default 100) |
| min_days | number | Minimum days since last update (default 14) |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Max entries (1-500, default 100)"
},
"min_days": {
"type": "number",
"description": "Minimum days since last update (default 14)"
}
}
}Patches that pass on some platforms but not others. Example: passing on linux but failing on macos -> portability bug.
| Argument | Type | Description |
|---|---|---|
| limit | number | Max entries (1-500, default 100) |
| failing_on | string | Platform keyword the entry must be failing on (e.g. macos) |
| passing_on | string | Platform keyword the entry must be passing on (e.g. linux) |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Max entries (1-500, default 100)"
},
"failing_on": {
"type": "string",
"description": "Platform keyword the entry must be failing on (e.g. macos)"
},
"passing_on": {
"type": "string",
"description": "Platform keyword the entry must be passing on (e.g. linux)"
}
}
}Search for a regex pattern in code symbol bodies. Uses trigram indexes for acceleration.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results (1-100, default 50) |
| pattern* | string | Regular expression pattern |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [
"pattern"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results (1-100, default 50)"
},
"pattern": {
"type": "string",
"description": "Regular expression pattern"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Entries cfbot reports as no longer applying to master tip (:entry/applies-cleanly is false). These need an author rebase.
| Argument | Type | Description |
|---|---|---|
| limit | number | Max entries (1-500, default 100) |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Max entries (1-500, default 100)"
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results (1-50, default 20) |
| query* | string | Search term (subject keyword, Message-ID substring, or commit hash) |
{
"type": "object",
"required": [
"query"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results (1-50, default 20)"
},
"query": {
"type": "string",
"description": "Search term (subject keyword, Message-ID substring, or commit hash)"
}
}
}Find messages similar to a given message using its embedding vector. Useful for finding related discussions or duplicate threads.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| limit | number | Maximum results to return (1-50, default 10) |
| message_id* | string | Message-ID of the message to find similar messages for |
{
"type": "object",
"required": [
"message_id"
],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum results to return (1-50, default 10)"
},
"message_id": {
"type": "string",
"description": "Message-ID of the message to find similar messages for"
}
}
}Find occurrences of a literal in current (HEAD) source, restricted to a syntactic kind: "strings" (inside double quotes), "comments" (after // or /*), or "all".
| Argument | Type | Description |
|---|---|---|
| kind | string | One of "all" (default), "strings", or "comments". |
| literal* | string | Literal text to find. Regex metachars are escaped. |
| repository | string | Restrict results to this repository name. |
| max_results | number | Max matches to return (1-500, default 50). |
{
"type": "object",
"required": [
"literal"
],
"properties": {
"kind": {
"type": "string",
"description": "One of \"all\" (default), \"strings\", or \"comments\"."
},
"literal": {
"type": "string",
"description": "Literal text to find. Regex metachars are escaped."
},
"repository": {
"type": "string",
"description": "Restrict results to this repository name."
},
"max_results": {
"type": "number",
"description": "Max matches to return (1-500, default 50)."
}
}
}Profile of one buildfarm animal: hardware/OS/compiler/owner, branches tracked, last build status, plus the last 20 runs (any branch).
| Argument | Type | Description |
|---|---|---|
| name* | string | Animal name (e.g. elasmobranch, fairywren) |
{
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Animal name (e.g. elasmobranch, fairywren)"
}
}
}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_thread attachments. Text attachments come back as decoded text (a .patch is ready to read or `git apply`), binary ones as base64 with encoding=base64; size is the decoded byte count. Cite the message as https://postgr.es/m/<message_id>.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| index | number | 1-based attachment index (from get_message attachment metadata) |
| filename | string | Substring to match against attachment filenames |
| message_id* | string | Message-ID (with or without angle brackets) |
{
"type": "object",
"required": [
"message_id"
],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"index": {
"type": "number",
"description": "1-based attachment index (from get_message attachment metadata)"
},
"filename": {
"type": "string",
"description": "Substring to match against attachment filenames"
},
"message_id": {
"type": "string",
"description": "Message-ID (with or without angle brackets)"
}
}
}Find messages by a specific author, optionally filtered by date range. Uses the f: (from) search prefix.
| Argument | Type | Description |
|---|---|---|
| after | string | Only return messages after this date (YYYY-MM-DD or YYYYMMDD) |
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| limit | number | Maximum results to return (1-200, default 50) |
| author* | string | Author name or email to search for |
| before | string | Only return messages before this date (YYYY-MM-DD or YYYYMMDD) |
| offset | number | Offset for pagination |
{
"type": "object",
"required": [
"author"
],
"properties": {
"after": {
"type": "string",
"description": "Only return messages after this date (YYYY-MM-DD or YYYYMMDD)"
},
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum results to return (1-200, default 50)"
},
"author": {
"type": "string",
"description": "Author name or email to search for"
},
"before": {
"type": "string",
"description": "Only return messages before this date (YYYY-MM-DD or YYYYMMDD)"
},
"offset": {
"type": "number",
"description": "Offset for pagination"
}
}
}Find all symbols that the given symbol calls/references (forward call graph).
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results (1-100, default 50) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| qualified_name* | string | Fully qualified symbol name |
{
"type": "object",
"required": [
"qualified_name"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results (1-100, default 50)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"qualified_name": {
"type": "string",
"description": "Fully qualified symbol name"
}
}
}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 to call sites. HEAD only; macro expansion and function pointers are not followed. limit caps the list. Read a caller with git_show_file at its line.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results (1-100, default 50) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| qualified_name* | string | Fully qualified symbol name |
{
"type": "object",
"required": [
"qualified_name"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results (1-100, default 50)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"qualified_name": {
"type": "string",
"description": "Fully qualified symbol name"
}
}
}One postgres commit from the code-history index: message, parsed trailers (names only), Discussion threads (links to the archived thread on /m/), back-patch siblings on other branches, first_releases (per branch the change landed on: sha, release such as 14.23, first_version incl. betas, shipped=false when reverted before that release; null release = not yet released), reverted_by and reverts, files changed with line counts, and its diff rendered from the index (at most 3000 lines; diff_complete says whether it was cut). Accepts a SHA (7+ hex), branch, tag or any version form.
| Argument | Type | Description |
|---|---|---|
| diff | boolean | Include the diff (default true) |
| paths | array | Only diff files under these paths |
| commit* | string | SHA or prefix (7+ hex), or any version form (REL_17_0, master~2) |
| context | number | Diff context lines (0-1000, default 3) |
| repository | string | Repository; only postgres is in the code-history index for now (the default). |
{
"type": "object",
"required": [
"commit"
],
"properties": {
"diff": {
"type": "boolean",
"description": "Include the diff (default true)"
},
"paths": {
"type": "array",
"items": {
"type": "string"
},
"description": "Only diff files under these paths"
},
"commit": {
"type": "string",
"description": "SHA or prefix (7+ hex), or any version form (REL_17_0, master~2)"
},
"context": {
"type": "number",
"description": "Diff context lines (0-1000, default 3)"
},
"repository": {
"type": "string",
"description": "Repository; only postgres is in the code-history index for now (the default)."
}
}
}Get a single commitfest with entries grouped by status and the top contributors (authors with the most entries).
| Argument | Type | Description |
|---|---|---|
| number* | number | Commitfest sequence number, e.g. 59 |
{
"type": "object",
"required": [
"number"
],
"properties": {
"number": {
"type": "number",
"description": "Commitfest sequence number, e.g. 59"
}
}
}List Louvain community clusters detected in the call graph. Communities group related symbols by functional area.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum communities (1-100, default 20) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Maximum communities (1-100, default 20)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Get details and member symbols for a specific community.
| Argument | Type | Description |
|---|---|---|
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| community_id* | number | Community ID |
{
"type": "object",
"required": [
"community_id"
],
"properties": {
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"community_id": {
"type": "number",
"description": "Community ID"
}
}
}A contributor's profile 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 with sha, and buildfarm animals they own. People who hid their page are excluded from name lookups. For what they did recently use whats_new. Cite https://pg.ddx.io/community/<hash>.
| Argument | Type | Description |
|---|---|---|
| name | string | :person/canonical-name substring (case-insensitive). Used only when email is not provided. |
| string | Exact :person/canonical-email match |
{
"type": "object",
"required": [],
"properties": {
"name": {
"type": "string",
"description": ":person/canonical-name substring (case-insensitive). Used only when email is not provided."
},
"email": {
"type": "string",
"description": "Exact :person/canonical-email match"
}
}
}Show all past mailing list submissions by a contributor (matched by email address or name).
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results (1-100, default 50) |
| contributor* | string | Contributor email address or display name |
{
"type": "object",
"required": [
"contributor"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results (1-100, default 50)"
},
"contributor": {
"type": "string",
"description": "Contributor email address or display name"
}
}
}Get transitive dependents: all symbols in the blast radius if this symbol changes.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results (1-200, default 50) |
| max_depth | number | Maximum BFS depth (1-5, default 3) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| qualified_name* | string | Fully qualified symbol name |
{
"type": "object",
"required": [
"qualified_name"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results (1-200, default 50)"
},
"max_depth": {
"type": "number",
"description": "Maximum BFS depth (1-5, default 3)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"qualified_name": {
"type": "string",
"description": "Fully qualified symbol name"
}
}
}One PostgreSQL documentation page as text: path (e.g. "brin.html" or "sql-createtable.html") and optional version ("17", "current"; default the latest). Returns its url, path and stored text (body) with fetched_at. Use search_docs to find the path. Cite the returned url.
| Argument | Type | Description |
|---|---|---|
| path* | string | URL path of the documentation page |
| version | string | Documentation version (default: latest available) |
{
"type": "object",
"required": [
"path"
],
"properties": {
"path": {
"type": "string",
"description": "URL path of the documentation page"
},
"version": {
"type": "string",
"description": "Documentation version (default: latest available)"
}
}
}One commitfest entry by cf_id (the number in commitfest.postgresql.org/patch/<cf_id>/): title, status, commitfest, authors, reviewers, committer, its mail threads and branches. Read the thread with get_thread; cfbot state with find_failing_patches. Cite https://commitfest.postgresql.org/patch/<cf_id>/.
| Argument | Type | Description |
|---|---|---|
| cf_id* | number | commitfest.postgresql.org entry id |
{
"type": "object",
"required": [
"cf_id"
],
"properties": {
"cf_id": {
"type": "number",
"description": "commitfest.postgresql.org entry id"
}
}
}Trace execution flow paths through the call graph from entry points.
| Argument | Type | Description |
|---|---|---|
| max_depth | number | Maximum BFS depth (1-10, default 8) |
| max_flows | number | Maximum flows to return (1-50, default 20) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"max_depth": {
"type": "number",
"description": "Maximum BFS depth (1-10, default 8)"
},
"max_flows": {
"type": "number",
"description": "Maximum flows to return (1-50, default 20)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Analyze the impact of modifying a symbol: risk level, blast radius, affected communities and execution flows.
| Argument | Type | Description |
|---|---|---|
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| qualified_name* | string | Fully qualified symbol name |
{
"type": "object",
"required": [
"qualified_name"
],
"properties": {
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"qualified_name": {
"type": "string",
"description": "Fully qualified symbol name"
}
}
}Get metadata for an inbox (name, addresses, message count, last activity)
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
{
"type": "object",
"required": [],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
}
}
}Return aggregate statistics about an inbox: message counts by time period, top authors, and activity trends.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| period | string | Aggregation period: "day", "week", "month" (default), or "year" |
| top_authors | number | Number of top authors to return (1-50, default 10) |
{
"type": "object",
"required": [],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"period": {
"type": "string",
"description": "Aggregation period: \"day\", \"week\", \"month\" (default), or \"year\""
},
"top_authors": {
"type": "number",
"description": "Number of top authors to return (1-50, default 10)"
}
}
}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).
| Argument | Type | Description |
|---|---|---|
| name* | string | Inbox name |
{
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Inbox name"
}
}
}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 removed; full_text=true for everything, quotes included), attachments [{index, filename, content_type, size}] and has_patch. Never raw MIME: get_attachment returns an attachment's content, get_raw_message the RFC 822 source. Finds the list itself unless inbox is given. Cite as https://postgr.es/m/<message_id>.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| body_only | boolean | Older spelling of full_text=true: the whole decoded text (default false). |
| full_text | boolean | Return the whole decoded text, quoted replies and signature included (default false: the author's own words only). |
| message_id* | string | Message-ID (with or without angle brackets) |
| include_body | boolean | Include message body (default true) |
{
"type": "object",
"required": [
"message_id"
],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"body_only": {
"type": "boolean",
"description": "Older spelling of full_text=true: the whole decoded text (default false)."
},
"full_text": {
"type": "boolean",
"description": "Return the whole decoded text, quoted replies and signature included (default false: the author's own words only)."
},
"message_id": {
"type": "string",
"description": "Message-ID (with or without angle brackets)"
},
"include_body": {
"type": "boolean",
"description": "Include message body (default true)"
}
}
}Get email headers as structured key/value pairs. Returns all headers or a specific header by name.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| header | string | Specific header name to retrieve (e.g. "X-Mailer"); omit to get all headers |
| message_id* | string | Message-ID (with or without angle brackets) |
{
"type": "object",
"required": [
"message_id"
],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"header": {
"type": "string",
"description": "Specific header name to retrieve (e.g. \"X-Mailer\"); omit to get all headers"
},
"message_id": {
"type": "string",
"description": "Message-ID (with or without angle brackets)"
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| message_id* | string | Message-ID (with or without angle brackets) |
{
"type": "object",
"required": [
"message_id"
],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"message_id": {
"type": "string",
"description": "Message-ID (with or without angle brackets)"
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| after* | number | Article number cursor; returns messages with article numbers greater than this value. Use 0 for the first call. |
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| limit | number | Maximum messages to return (1-1000, default 200) |
{
"type": "object",
"required": [
"after"
],
"properties": {
"after": {
"type": "number",
"description": "Article number cursor; returns messages with article numbers greater than this value. Use 0 for the first call."
},
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum messages to return (1-1000, default 200)"
}
}
}Get the git branches created from a patch series. Shows what branches were applied from email patches for code intelligence analysis.
| Argument | Type | Description |
|---|---|---|
| pr_url* | string | Forge pull request URL |
{
"type": "object",
"required": [
"pr_url"
],
"properties": {
"pr_url": {
"type": "string",
"description": "Forge pull request URL"
}
}
}Build matrix for one entry: per-platform/config status, log URL, observation time, applies-cleanly flag, rollup.
| Argument | Type | Description |
|---|---|---|
| cf_id* | number | commitfest.postgresql.org entry id |
{
"type": "object",
"required": [
"cf_id"
],
"properties": {
"cf_id": {
"type": "number",
"description": "commitfest.postgresql.org entry id"
}
}
}Get patch submission history for a forge pull request URL. Returns all iterations submitted to the mailing list.
| Argument | Type | Description |
|---|---|---|
| pr_url* | string | Forge pull request URL |
{
"type": "object",
"required": [
"pr_url"
],
"properties": {
"pr_url": {
"type": "string",
"description": "Forge pull request URL"
}
}
}Get the complete raw RFC 822 email bytes for a message. Useful for agents that need to parse headers/structure themselves or forward messages.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| message_id* | string | Message-ID (with or without angle brackets) |
{
"type": "object",
"required": [
"message_id"
],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"message_id": {
"type": "string",
"description": "Message-ID (with or without angle brackets)"
}
}
}Get commit frequency analysis and sync statistics for a repository. Returns median commit interval, recommended poll frequency, and recent fetch log.
| Argument | Type | Description |
|---|---|---|
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Per-repository summary: total commits, top 10 contributors, branches, language breakdown (from indexed symbols), and a sampled most-touched-paths list.
| Argument | Type | Description |
|---|---|---|
| name* | string | Repository name |
{
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Repository name"
}
}
}Get the function/method signature and doc comment for a symbol.
| Argument | Type | Description |
|---|---|---|
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| qualified_name* | string | Fully qualified symbol name |
{
"type": "object",
"required": [
"qualified_name"
],
"properties": {
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"qualified_name": {
"type": "string",
"description": "Fully qualified symbol name"
}
}
}Detail for a single source by name. Returns kind, item_count, last_update, next_sync, freshness_status, and description.
| Argument | Type | Description |
|---|---|---|
| name* | string | Source name (inbox name, repo name, source nick) |
{
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Source name (inbox name, repo name, source nick)"
}
}
}Get full details for a code symbol by its qualified name, including source code, signature, documentation, and file location.
| Argument | Type | Description |
|---|---|---|
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| qualified_name* | string | Fully qualified symbol name (e.g. 'MyClass.myMethod', 'pkg::func_name') |
{
"type": "object",
"required": [
"qualified_name"
],
"properties": {
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"qualified_name": {
"type": "string",
"description": "Fully qualified symbol name (e.g. 'MyClass.myMethod', 'pkg::func_name')"
}
}
}Find test symbols that reference the given symbol.
| Argument | Type | Description |
|---|---|---|
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| qualified_name* | string | Fully qualified symbol name |
{
"type": "object",
"required": [
"qualified_name"
],
"properties": {
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"qualified_name": {
"type": "string",
"description": "Fully qualified symbol name"
}
}
}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: quoted replies, signature and inline patch removed; full_text=true for the whole decoded text; never raw MIME), attachments [{index, filename, content_type, size}] and has_patch. Paged: 20 messages per call (limit max 500; offset/next_offset/has_more); bodies capped at max_body_chars (default 4000; 0 = no cap; body_truncated marks a cut). include_bodies=false gives a cheap outline. Finds the list itself unless inbox is given. Cite as https://postgr.es/m/<message_id>.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| limit | number | Messages per page (1-500, default 20). |
| offset | number | Skip this many messages; use next_offset from the previous page. |
| full_text | boolean | Whole decoded text of each message, quotes included (default false: own words only). |
| message_id* | string | Message-ID of any message in the thread |
| include_bodies | boolean | Include message bodies (default true). false returns an outline: headers only. |
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.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| message_id* | string | Message-ID of any message in the thread |
{
"type": "object",
"required": [
"message_id"
],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"message_id": {
"type": "string",
"description": "Message-ID of any message in the thread"
}
}
}Get revision history for a wiki page.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum revisions to return (1-100, default 20) |
| title* | string | Wiki page title |
{
"type": "object",
"required": [
"title"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum revisions to return (1-100, default 20)"
},
"title": {
"type": "string",
"description": "Wiki page title"
}
}
}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 find a title, get_wiki_history for older revisions. Cite https://wiki.postgresql.org/wiki/<title>.
| Argument | Type | Description |
|---|---|---|
| title* | string | Wiki page title |
{
"type": "object",
"required": [
"title"
],
"properties": {
"title": {
"type": "string",
"description": "Wiki page title"
}
}
}Show commit activity over time, bucketed by period. Useful for understanding development pace and trends.
| Argument | Type | Description |
|---|---|---|
| period | string | Aggregation period: "week", "month" (default), "quarter", or "year" |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"period": {
"type": "string",
"description": "Aggregation period: \"week\", \"month\" (default), \"quarter\", or \"year\""
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Get commit statistics per author: total commits, first and last commit dates. Ranked by commit count.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum authors to return (1-100, default 25) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Maximum authors to return (1-100, default 25)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Identify files with the fewest distinct authors (bus factor risk). Files modified by only one person are knowledge silos.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum files to return (1-100, default 25) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Maximum files to return (1-100, default 25)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Identify the most frequently modified files in the repository. High-churn files may indicate hotspots or unstable code.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results to return (1-100, default 25) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results to return (1-100, default 25)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Find files that are frequently changed together. Logical coupling can reveal hidden dependencies between components.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum pairs to return (1-100, default 25) |
| min_count | number | Minimum co-change count to include a pair (default 2) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Maximum pairs to return (1-100, default 25)"
},
"min_count": {
"type": "number",
"description": "Minimum co-change count to include a pair (default 2)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Aggregate file churn by directory to find the most actively changed areas of the codebase.
| Argument | Type | Description |
|---|---|---|
| depth | number | Directory depth for aggregation (default 1) |
| limit | number | Maximum directories to return (1-100, default 25) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"depth": {
"type": "number",
"description": "Directory depth for aggregation (default 1)"
},
"limit": {
"type": "number",
"description": "Maximum directories to return (1-100, default 25)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}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 sha, commit_id, author, date, summary and status (added/modified/deleted). Renames are not followed. Up to `limit` commits (default 100, max 1000); has_more says there are older ones.
| Argument | Type | Description |
|---|---|---|
| path* | string | File path within the repository |
| limit | number | Maximum commits to return (1-1000, default 100). |
| commit | string | List the commits on the history of this commit: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. Default HEAD. |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [
"path"
],
"properties": {
"path": {
"type": "string",
"description": "File path within the repository"
},
"limit": {
"type": "number",
"description": "Maximum commits to return (1-1000, default 100)."
},
"commit": {
"type": "string",
"description": "List the commits on the history of this commit: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. Default HEAD."
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| path | string | Limit results to a specific file path |
| limit | number | Commit-range mode: maximum commits to return (1-1000, default 100) |
| author | string | Commit-range mode: filter by author name or email (substring match) |
| to_commit | string | Content-diff mode: commit to diff to: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. Default HEAD. |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| base_branch | string | Commit-range mode: base side of the range (excluded). Defaults to the repository's default branch when head_branch is set. |
| from_commit | string | Content-diff mode: commit to diff from: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. |
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 (any branch, tag or major version such as 17 or 9.6; default the indexed default branch). Each commit: sha (40-hex, cite it), commit_id, message (subject for a branch log), author and dates. limit default 50, max 200; offset pages; has_more. repository defaults to postgres.
| Argument | Type | Description |
|---|---|---|
| path | string | Filter commits to those touching this file path |
| limit | number | Maximum commits to return (1-200, default 50) |
| since | string | Only commits after this date (YYYY-MM-DD or RFC3339) |
| until | string | Only commits before this date (YYYY-MM-DD or RFC3339) |
| author | string | Filter by author name or email (substring match) |
| branch | string | Restrict the log to commits reachable from this branch (e.g. cf/5556). Default: the repository's default branch. |
| offset | number | Offset for pagination (default 0) |
| repository | string |
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` with every word). Each commit: sha (40-hex, cite it), commit_id, message, author, date, people credited, and 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}. repository defaults to postgres; limit default 50, max 200. Details with commit_history.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results to return (1-200, default 50) |
| query* | string | Search query string |
| search_in | string | What to search: "messages" (commit messages, default) or "paths" (file paths) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [
"query"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results to return (1-200, default 50)"
},
"query": {
"type": "string",
"description": "Search query string"
},
"search_in": {
"type": "string",
"description": "What to search: \"messages\" (commit messages, default) or \"paths\" (file paths)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}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.6, <ref>~N or a commit_id; default HEAD; an unknown name or path is an error, never a silent HEAD. Returns at most 2000 lines per call: start_line/end_line pick the range, total_lines gives the length and cut=true says more follow. Lines are numbered with a tab (numbered=false gives the exact bytes). Each result has sha (cite it with the path and lines) and ref. Binary files return a note instead of content.
| Argument | Type | Description |
|---|---|---|
| path* | string | File path within the repository |
| commit | string | Commit to read the file at: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. Default HEAD. An unknown name is an error, never a silent HEAD. |
| end_line | number | Last line to return (1-based, inclusive). Default: the end of the file, capped at start_line + 1999. |
| numbered | boolean | Prefix each line with its line number and a tab (default true). false returns the exact file bytes. |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| start_line | number | First line to return (1-based). Default 1. |
Literal-text search of the CURRENT source only (HEAD of master for postgres, the default branch elsewhere), like `git grep -F` (regex characters are escaped; case_insensitive=true for -i). Returns up to max_results files (default 50, max 500), each with repo_name, file_path, line_no and snippet (its first matching line). For any other commit, branch, tag, major version or date, for every match with context, or to search history, use code_search (version=, history=). Read a hit with read_file or git_show_file; cite path:line with the sha.
| Argument | Type | Description |
|---|---|---|
| text* | string | Literal substring to search for. Regex metachars are escaped before searching. |
| repository | string | Restrict results to this repository name. |
| max_results | number | Max matches to return (1-500, default 50). |
| case_insensitive | boolean | Match case-insensitively (default false). |
{
"type": "object",
"required": [
"text"
],
"properties": {
"text": {
"type": "string",
"description": "Literal substring to search for. Regex metachars are escaped before searching."
},
"repository": {
"type": "string",
"description": "Restrict results to this repository name."
},
"max_results": {
"type": "number",
"description": "Max matches to return (1-500, default 50)."
},
"case_insensitive": {
"type": "boolean",
"description": "Match case-insensitively (default false)."
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| repo | string | Tracked repo whose default branch to trace (default: postgres). |
| inbox | string | Mailing list to search for discussion (default: pgsql-hackers). |
| limit | number | Max items per section (default 5). |
| content* | string | Free text: a diff/hunk, file path(s), symbol name, commit subject, feature name, or error text. |
{
"type": "object",
"required": [
"content"
],
"properties": {
"repo": {
"type": "string",
"description": "Tracked repo whose default branch to trace (default: postgres)."
},
"inbox": {
"type": "string",
"description": "Mailing list to search for discussion (default: pgsql-hackers)."
},
"limit": {
"type": "number",
"description": "Max items per section (default 5)."
},
"content": {
"type": "string",
"description": "Free text: a diff/hunk, file path(s), symbol name, commit subject, feature name, or error text."
}
}
}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. Returns up to limit threads (default 20, max 50), best first, each its best message: inbox, message_id, subject, from, date, thread_id, fused_score (0-1), similarity and a short excerpt of the author's own words. Like a ranked `git log --grep` for mail. Cite as https://postgr.es/m/<message_id>; read with get_thread or get_message (inbox from the result). author, since and until restrict both arms to one sender and a date window.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Lists to search: omit (or "all") for every list, the default; one name such as pgsql-bugs; or several, comma-separated ("pgsql-hackers,pgsql-bugs"). Names from list_inboxes. Aliases: list, inbox_name. |
| limit | number | Maximum results to return (1-50, default 20) |
| query* | string | Search query (supports both keywords and natural language). Operators: after:/before:YYYY[-MM[-DD]], d:A..B, site:<list|docs|wiki|commits>, from:/author:, intitle:/s:, intext:/b:, to:/cc:, filetype:patch, has:patch, link:<url glob> (messages linking to a URL; link:example.org = any URL on that host), /regex/ (case:yes for case-sensitive), -operator to negate. Operators without words list matches newest first. |
| since | string | Only messages sent on or after this date (UTC): YYYY, YYYY-MM, YYYY-MM-DD, an ISO date-time, or 2w / 6m / 1y ago. |
| until |
Combined keyword + semantic code search using Reciprocal Rank Fusion. Requires embeddings to be generated.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results (1-100, default 20) |
| query* | string | Search query (supports keywords and natural language) |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
| keyword_weight | number | Weight for keyword results in fusion (0.0-1.0, default 0.5) |
{
"type": "object",
"required": [
"query"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results (1-100, default 20)"
},
"query": {
"type": "string",
"description": "Search query (supports keywords and natural language)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"keyword_weight": {
"type": "number",
"description": "Weight for keyword results in fusion (0.0-1.0, default 0.5)"
}
}
}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).
| Argument | Type | Description |
|---|---|---|
| os | string | Restrict to animals running this OS (exact match against ag_buildfarm_animals.os) |
| limit | number | Max animals (1-500, default 100) |
| owner | string | Restrict to a single owner_name or owner_email (exact match) |
| branch | string | Restrict to animals tracking this PostgreSQL branch (e.g. master, REL_18_STABLE) |
| status | string | Restrict to animals with this last_status: passed, failed, flapping, unknown |
{
"type": "object",
"required": [],
"properties": {
"os": {
"type": "string",
"description": "Restrict to animals running this OS (exact match against ag_buildfarm_animals.os)"
},
"limit": {
"type": "number",
"description": "Max animals (1-500, default 100)"
},
"owner": {
"type": "string",
"description": "Restrict to a single owner_name or owner_email (exact match)"
},
"branch": {
"type": "string",
"description": "Restrict to animals tracking this PostgreSQL branch (e.g. master, REL_18_STABLE)"
},
"status": {
"type": "string",
"description": "Restrict to animals with this last_status: passed, failed, flapping, unknown"
}
}
}List tracked branches for a repository, including head commit and default branch status.
| Argument | Type | Description |
|---|---|---|
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| status | string | Filter by commitfest status: open, in-progress, or closed |
{
"type": "object",
"required": [],
"properties": {
"status": {
"type": "string",
"description": "Filter by commitfest status: open, in-progress, or closed"
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| role | string | Restrict to one role: authored, reviewed, tested, reported, committed, co-authored, suggested, signed-off, buildfarm-owner, ... |
| limit | number | Max contributors to return (1-500, default 100) |
| offset | number | Pagination offset (default 0) |
| source | string | Restrict to one source: git, buildfarm, email, wiki, commitfest |
| release | string | Restrict to one release tag, e.g. PG18 / PG17 / pre-9.6 |
{
"type": "object",
"required": [],
"properties": {
"role": {
"type": "string",
"description": "Restrict to one role: authored, reviewed, tested, reported, committed, co-authored, suggested, signed-off, buildfarm-owner, ..."
},
"limit": {
"type": "number",
"description": "Max contributors to return (1-500, default 100)"
},
"offset": {
"type": "number",
"description": "Pagination offset (default 0)"
},
"source": {
"type": "string",
"description": "Restrict to one source: git, buildfarm, email, wiki, commitfest"
},
"release": {
"type": "string",
"description": "Restrict to one release tag, e.g. PG18 / PG17 / pre-9.6"
}
}
}List monitored Discord channels with message counts.
No arguments.
{
"type": "object",
"required": [],
"properties": {}
}List available documentation versions with page counts.
No arguments.
{
"type": "object",
"required": [],
"properties": {}
}List commitfest entries (proposed patch series). Filterable by status, commitfest number, or topic; paginated.
| Argument | Type | Description |
|---|---|---|
| limit | number | Max entries to return (1-500, default 100) |
| topic | string | Restrict to entries with this :entry/topic value (substring match) |
| offset | number | Pagination offset (default 0) |
| status | string | Status keyword without leading colon, e.g. needs-review, ready-for-committer, waiting-on-author, committed, withdrawn, returned-with-feedback |
| commitfest_number | number | Restrict to entries from this commitfest (e.g. 59) |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Max entries to return (1-500, default 100)"
},
"topic": {
"type": "string",
"description": "Restrict to entries with this :entry/topic value (substring match)"
},
"offset": {
"type": "number",
"description": "Pagination offset (default 0)"
},
"status": {
"type": "string",
"description": "Status keyword without leading colon, e.g. needs-review, ready-for-committer, waiting-on-author, committed, withdrawn, returned-with-feedback"
},
"commitfest_number": {
"type": "number",
"description": "Restrict to entries from this commitfest (e.g. 59)"
}
}
}List the files of the postgres source under a directory at any commit, branch, tag or date (code-history index), with line counts; depth folds deeper paths into directories with file counts; glob filters paths.
| Argument | Type | Description |
|---|---|---|
| glob | string | Path glob, e.g. *.dat or src/include/catalog/*.h |
| path | string | Directory (default the root) |
| depth | number | Levels below path to list (default all) |
| limit | number | Entries (1-5000, default 500) |
| version | string | Commit to read: a SHA or 7+ hex prefix, a branch (master, REL_17_STABLE), a tag (REL_17_0), a major (17, 9.6), a release (17.2), <ref>@YYYY-MM-DD (the branch's last commit by that day), or <ref>~N. Default: the newest release branch's head. |
| repository | string | Repository; only postgres is in the code-history index for now (the default). |
{
"type": "object",
"properties": {
"glob": {
"type": "string",
"description": "Path glob, e.g. *.dat or src/include/catalog/*.h"
},
"path": {
"type": "string",
"description": "Directory (default the root)"
},
"depth": {
"type": "number",
"description": "Levels below path to list (default all)"
},
"limit": {
"type": "number",
"description": "Entries (1-5000, default 500)"
},
"version": {
"type": "string",
"description": "Commit to read: a SHA or 7+ hex prefix, a branch (master, REL_17_STABLE), a tag (REL_17_0), a major (17, 9.6), a release (17.2), <ref>@YYYY-MM-DD (the branch's last commit by that day), or <ref>~N. Default: the newest release branch's head."
},
"repository": {
"type": "string",
"description": "Repository; only postgres is in the code-history index for now (the default)."
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| limit | number | Forward-compat: max rows (default unlimited) |
| offset | number | Forward-compat: skip the first N rows |
| min_messages | number | Only return inboxes with at least this many messages |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Forward-compat: max rows (default unlimited)"
},
"offset": {
"type": "number",
"description": "Forward-compat: skip the first N rows"
},
"min_messages": {
"type": "number",
"description": "Only return inboxes with at least this many messages"
}
}
}List bridge-configured projects linking a forge repository to a mailing list inbox.
No arguments.
{
"type": "object",
"required": [],
"properties": {}
}List recent messages from an inbox
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| limit | number | Maximum messages to return (1-200, default 25) |
{
"type": "object",
"required": [],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum messages to return (1-200, default 25)"
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| limit | number | Forward-compat: max rows (default unlimited) |
| branch | string | Filter to repositories whose default branch matches this string |
| offset | number | Forward-compat: skip the first N rows |
| min_commits | number | Only return repositories with at least this many commits |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Forward-compat: max rows (default unlimited)"
},
"branch": {
"type": "string",
"description": "Filter to repositories whose default branch matches this string"
},
"offset": {
"type": "number",
"description": "Forward-compat: skip the first N rows"
},
"min_commits": {
"type": "number",
"description": "Only return repositories with at least this many commits"
}
}
}Every source behind this server with its kind (inbox, repository, docs, wiki, discord), item count, last update and freshness (fresh/stale): the 56 mailing lists, the git repositories, the documentation releases, the wiki and Discord. Use it to learn the inbox and repository names other tools accept and how current each is. kind filters; min_items drops small sources.
| Argument | Type | Description |
|---|---|---|
| kind | string | Filter to a single kind (inbox|repository|docs|wiki|discord) |
| limit | number | Forward-compat: max rows (default unlimited) |
| offset | number | Forward-compat: skip the first N rows |
| min_items | number | Only return sources with at least this many items |
{
"type": "object",
"required": [],
"properties": {
"kind": {
"type": "string",
"description": "Filter to a single kind (inbox|repository|docs|wiki|discord)"
},
"limit": {
"type": "number",
"description": "Forward-compat: max rows (default unlimited)"
},
"offset": {
"type": "number",
"description": "Forward-compat: skip the first N rows"
},
"min_items": {
"type": "number",
"description": "Only return sources with at least this many items"
}
}
}Browse recent threads (topic-level view). Returns thread summaries with message counts, date ranges, and latest message metadata.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| limit | number | Maximum threads to return (1-100, default 20) |
| before | number | Unix timestamp; only return threads with last activity before this time (for pagination) |
{
"type": "object",
"required": [],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum threads to return (1-100, default 20)"
},
"before": {
"type": "number",
"description": "Unix timestamp; only return threads with last activity before this time (for pagination)"
}
}
}Read a file of the postgres source at any commit, branch, tag or date from the code-history index: numbered lines, at most 2000 per call (page with start_line/end_line), byte-exact to git. Says total_lines and complete; binary files return their metadata only.
| Argument | Type | Description |
|---|---|---|
| path* | string | Path from the repository root, e.g. src/backend/access/transam/xlog.c |
| version | string | Commit to read: a SHA or 7+ hex prefix, a branch (master, REL_17_STABLE), a tag (REL_17_0), a major (17, 9.6), a release (17.2), <ref>@YYYY-MM-DD (the branch's last commit by that day), or <ref>~N. Default: the newest release branch's head. |
| end_line | number | Last line (default start_line + 1999) |
| repository | string | Repository; only postgres is in the code-history index for now (the default). |
| start_line | number | First line (default 1) |
{
"type": "object",
"required": [
"path"
],
"properties": {
"path": {
"type": "string",
"description": "Path from the repository root, e.g. src/backend/access/transam/xlog.c"
},
"version": {
"type": "string",
"description": "Commit to read: a SHA or 7+ hex prefix, a branch (master, REL_17_STABLE), a tag (REL_17_0), a major (17, 9.6), a release (17.2), <ref>@YYYY-MM-DD (the branch's last commit by that day), or <ref>~N. Default: the newest release branch's head."
},
"end_line": {
"type": "number",
"description": "Last line (default start_line + 1999)"
},
"repository": {
"type": "string",
"description": "Repository; only postgres is in the code-history index for now (the default)."
},
"start_line": {
"type": "number",
"description": "First line (default 1)"
}
}
}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.
| Argument | Type | Description |
|---|---|---|
| limit | number | Max entries (1-500, default 100) |
| since | string | RFC3339 cutoff (default: 7 days ago) |
{
"type": "object",
"required": [],
"properties": {
"limit": {
"type": "number",
"description": "Max entries (1-500, default 100)"
},
"since": {
"type": "string",
"description": "RFC3339 cutoff (default: 7 days ago)"
}
}
}Regular-expression search of the CURRENT source only (HEAD of master for postgres, the default branch elsewhere), like `git grep -E` with grep's line semantics: ^ and $ anchor at line starts and ends, . does not cross lines. PostgreSQL regex syntax (\s, \w, (?i) work). path_glob narrows by SQL LIKE pattern ("src/backend/%.c"), repository by name. Returns up to max_results files (default 50, max 500) with repo_name, file_path, line_no and snippet (its first matching line). For any other commit, branch, tag, major version or date, all matches with context, or history, use code_search with match=regex. Cite path:line with the sha.
| Argument | Type | Description |
|---|---|---|
| pattern* | string | POSIX extended regex pattern, e.g. "^static\\s+void\\s+ProcSignal". |
| path_glob | string | Restrict results to paths matching this SQL LIKE pattern, e.g. "%/src/backend/%.c". |
| repository | string | Restrict results to this repository name (exact match against ag_repositories.name). |
| max_results | number | Max matches to return (1-500, default 50). |
{
"type": "object",
"required": [
"pattern"
],
"properties": {
"pattern": {
"type": "string",
"description": "POSIX extended regex pattern, e.g. \"^static\\\\s+void\\\\s+ProcSignal\"."
},
"path_glob": {
"type": "string",
"description": "Restrict results to paths matching this SQL LIKE pattern, e.g. \"%/src/backend/%.c\"."
},
"repository": {
"type": "string",
"description": "Restrict results to this repository name (exact match against ag_repositories.name)."
},
"max_results": {
"type": "number",
"description": "Max matches to return (1-500, default 50)."
}
}
}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).
| Argument | Type | Description |
|---|---|---|
| release* | string | Release tag, e.g. PG18 / PG17 / pre-9.6 |
| per_role_limit | number | Top-N per role (1-100, default 20) |
{
"type": "object",
"required": [
"release"
],
"properties": {
"release": {
"type": "string",
"description": "Release tag, e.g. PG18 / PG17 / pre-9.6"
},
"per_role_limit": {
"type": "number",
"description": "Top-N per role (1-100, default 20)"
}
}
}Get detailed statistics for a git repository including commit count, file count, branch, and import state.
| Argument | Type | Description |
|---|---|---|
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}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, each the author's own words (quotes, signature and patch removed, cut at ~1200 chars) with url, inbox, message_id, from and date. found=false with a reason when the archive does not appear to discuss the question, instead of weak matches. Retrieval only: write the answer yourself. Cite each claim with its passage url or https://postgr.es/m/<message_id>; open a thread with get_thread. author, since and until restrict it to what one person wrote in a date window (filter echoes them).
| Argument | Type | Description |
|---|---|---|
| inbox | string | Lists to search: omit (or "all") for every list, the default; one name such as pgsql-bugs; or several, comma-separated ("pgsql-hackers,pgsql-bugs"). Names from list_inboxes. Aliases: list, inbox_name. |
| since | string | Only messages sent on or after this date (UTC): YYYY, YYYY-MM, YYYY-MM-DD, an ISO date-time, or 2w / 6m / 1y ago. |
| until | string | Only messages sent before this date (exclusive), same forms as since. With author: what that person had said by then. |
| author | string | Only messages this person sent: a name, an e-mail address or hash:<8 hex> (a person page). Resolved to every address they post from; an ambiguous name returns the candidates to choose from. |
| question* |
Keyword search of mailing-list messages (BM25 over subject, sender and the authors' own words), every list unless inbox narrows it. Operators in query: s:/intitle: subject, f:/from: sender, b:/intext: body, after:/before:/d:2024-01..2025-01 dates, site:<list>, filetype:patch, link:<url glob>, /regex/. Returns messages best first (limit default 50, max 200; offset pages; collapse_threads=true keeps one per thread), each with inbox, message_id, subject, from, date, thread_id and an excerpt, plus total and has_more. Use it for exact words, names and identifiers; hybrid_search for questions. Cite as https://postgr.es/m/<message_id>. author, since and until restrict it to one sender and a date window.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Lists to search: omit (or "all") for every list, the default; one name such as pgsql-bugs; or several, comma-separated ("pgsql-hackers,pgsql-bugs"). Names from list_inboxes. Aliases: list, inbox_name. |
| limit | number | Maximum results to return (1-200, default 50) |
| query* | string | Search query string. Operators: after:/before:YYYY[-MM[-DD]], d:A..B, site:<list|docs|wiki|commits>, from:/author:, intitle:/s:, intext:/b:, to:/cc:, filetype:patch, has:patch, link:<url glob> (messages linking to a URL; link:example.org = any URL on that host), /regex/ (case:yes for case-sensitive), -operator to negate. Operators without words list matches newest first. |
| since | string | Only messages sent on or after this date (UTC): YYYY, YYYY-MM, YYYY-MM-DD, an ISO date-time, or 2w / 6m / 1y ago. |
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
| Argument | Type | Description |
|---|---|---|
| k | number | Edit distance for fuzzy match (0-5, default 0) |
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| limit | number | Maximum results to return (1-200, default 50) |
| query* | string | POSIX regex pattern |
| offset | number | Offset for pagination |
| collapse_threads | boolean | Deduplicate results to one per thread (default false) |
{
"type": "object",
"required": [
"query"
],
"properties": {
"k": {
"type": "number",
"description": "Edit distance for fuzzy match (0-5, default 0)"
},
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum results to return (1-200, default 50)"
},
"query": {
"type": "string",
"description": "POSIX regex pattern"
},
"offset": {
"type": "number",
"description": "Offset for pagination"
},
"collapse_threads": {
"type": "boolean",
"description": "Deduplicate results to one per thread (default false)"
}
}
}Unified search across all document sources (docs, wiki, and email). Returns results ranked by relevance.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results to return (1-50, default 20) |
| query* | string | Search query (supports both keywords and natural language). Operators apply to every source they fit: after:/before:, site:docs|wiki|mail|commits, intitle:, from:, link:<url glob>, /regex/ (see GET /api/v2/links and the /search page's syntax help). |
{
"type": "object",
"required": [
"query"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results to return (1-50, default 20)"
},
"query": {
"type": "string",
"description": "Search query (supports both keywords and natural language). Operators apply to every source they fit: after:/before:, site:docs|wiki|mail|commits, intitle:, from:, link:<url glob>, /regex/ (see GET /api/v2/links and the /search page's syntax help)."
}
}
}Full-text search of commitfest entries (title first, then author/reviewer/committer names), in the current commitfest by default, or commitfests="all" (back to 2014) or a comma list of numbers. Websearch syntax: "phrase", -term, or. Each result: cf_id, title, status, commitfest(s), people, last update, the commitfest.postgresql.org patch url and the pg.ddx.io thread link. limit default 20, max 50. Details with get_entry; cite the patch url.
| Argument | Type | Description |
|---|---|---|
| limit | integer | Max results (default 20, max 50) |
| query* | string | Search query, e.g. NUMA or "Tom Lane" |
| commitfests | string | "current" (default: the commitfest commitfest.postgresql.org/current/ shows), "all", or a comma list of commitfest numbers, e.g. "62,61" or "current,55"; see /api/v2/commitfest/commitfests |
{
"type": "object",
"required": [
"query"
],
"properties": {
"limit": {
"type": "integer",
"description": "Max results (default 20, max 50)"
},
"query": {
"type": "string",
"description": "Search query, e.g. NUMA or \"Tom Lane\""
},
"commitfests": {
"type": "string",
"description": "\"current\" (default: the commitfest commitfest.postgresql.org/current/ shows), \"all\", or a comma list of commitfest numbers, e.g. \"62,61\" or \"current,55\"; see /api/v2/commitfest/commitfests"
}
}
}Search postgres commits (code-history index), newest first, like git log: range (a rev, or A..B; default the newest release branch), message (regex, case-insensitive), author (regex over author, committer and Author/Co-authored-by/Reviewed-by trailers), paths, since/until (YYYY-MM-DD), changed_lines (a regex an added or removed line matches, as git log -G) and occurrences (a string whose count in a file changed, as git log -S).
| Argument | Type | Description |
|---|---|---|
| limit | number | Commits (1-200, default 30) |
| paths | array | Path prefixes the commit touched |
| range | string | A rev (its line back to the root) or A..B; default the newest release branch |
| since | string | YYYY-MM-DD (committed on or after) |
| until | string | YYYY-MM-DD (committed before) |
| author | string | Regex over author, committer and credit trailers |
| offset | number | Commits to skip |
| message | string | Regex over the commit message |
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).
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results to return (1-25, default 10) |
| query* | string | Natural language query to find semantically related Discord discussions |
{
"type": "object",
"required": [
"query"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results to return (1-25, default 10)"
},
"query": {
"type": "string",
"description": "Natural language query to find semantically related Discord discussions"
}
}
}Full-text search of the PostgreSQL documentation (websearch syntax: "phrase", -term, or), title matches first. Searches the current release unless version (one, e.g. "17") or versions (several) is given; a page matching in several selected versions is one result listing each version and its URL. Returns title, path, url, the versions it matched and a snippet. Read a page with get_doc_page; cite its postgresql.org/docs url.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results to return (1-50, default 20) |
| query* | string | Search query string |
| version | string | One documentation version (e.g. "18", "17"; "current" = the current release). Ignored when versions is given. |
| versions | array | Documentation versions to search, e.g. ["18", "17"] (default: the current release; see list_doc_versions) |
{
"type": "object",
"required": [
"query"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results to return (1-50, default 20)"
},
"query": {
"type": "string",
"description": "Search query string"
},
"version": {
"type": "string",
"description": "One documentation version (e.g. \"18\", \"17\"; \"current\" = the current release). Ignored when versions is given."
},
"versions": {
"type": "array",
"items": {
"type": "string"
},
"description": "Documentation versions to search, e.g. [\"18\", \"17\"] (default: the current release; see list_doc_versions)"
}
}
}Find patch series by parsing [PATCH v2 3/7]-style subject prefixes. Returns structured patch metadata including version, sequence, total, and series grouping.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name. |
| limit | number | Maximum results to return (1-100, default 50) |
| query | string | Additional search query to filter patches |
{
"type": "object",
"required": [],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum results to return (1-100, default 50)"
},
"query": {
"type": "string",
"description": "Additional search query to filter patches"
}
}
}Find C functions, macros, types and variables by name in the indexed source (HEAD): BM25 on names, then fuzzy and body matches. Filter by kind (function, struct, macro, ...), language, repository. Each result: qualified_name, name, kind, language, file, start_line and end_line. Like `ctags`/`git grep -w` for definitions. Follow with get_callers, or git_show_file with start_line/end_line to read the body.
| Argument | Type | Description |
|---|---|---|
| kind | string | Filter by symbol kind: function, class, method, struct, enum, interface, trait, etc. |
| limit | number | Maximum results (1-200, default 50) |
| query* | string | Search query (symbol name, partial name, or keyword) |
| language | string | Filter by language: go, python, c, cpp, rust, java, typescript, javascript, etc. |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [
"query"
],
"properties": {
"kind": {
"type": "string",
"description": "Filter by symbol kind: function, class, method, struct, enum, interface, trait, etc."
},
"limit": {
"type": "number",
"description": "Maximum results (1-200, default 50)"
},
"query": {
"type": "string",
"description": "Search query (symbol name, partial name, or keyword)"
},
"language": {
"type": "string",
"description": "Filter by language: go, python, c, cpp, rust, java, typescript, javascript, etc."
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}Full-text search (websearch syntax) of wiki.postgresql.org. By default searches each page's current text; history=true searches every revision and returns, per page, the latest matching revision (rev_id, revision_url, author, comment, timestamp, is_current) and how many matched; since/until bound the revision dates. Read a page with get_wiki_page; cite its wiki url.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results to return (1-50, default 20) |
| query* | string | Search query string |
| since | string | With history: only revisions at or after this date (YYYY-MM-DD or ISO-8601) |
| until | string | With history: only revisions before the end of this date (YYYY-MM-DD or ISO-8601) |
| history | boolean | Search every revision, not only the current text (default false) |
{
"type": "object",
"required": [
"query"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results to return (1-50, default 20)"
},
"query": {
"type": "string",
"description": "Search query string"
},
"since": {
"type": "string",
"description": "With history: only revisions at or after this date (YYYY-MM-DD or ISO-8601)"
},
"until": {
"type": "string",
"description": "With history: only revisions before the end of this date (YYYY-MM-DD or ISO-8601)"
},
"history": {
"type": "boolean",
"description": "Search every revision, not only the current text (default false)"
}
}
}Search messages on every list (or the lists in inbox) by semantic similarity using vector embeddings; each result names its inbox. 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.
| Argument | Type | Description |
|---|---|---|
| inbox | string | Lists to search: omit (or "all") for every list, the default; one name such as pgsql-bugs; or several, comma-separated ("pgsql-hackers,pgsql-bugs"). Names from list_inboxes. Aliases: list, inbox_name. |
| limit | number | Maximum results to return (1-50, default 20) |
| query* | string | Natural language query to search for semantically similar messages |
{
"type": "object",
"required": [
"query"
],
"properties": {
"inbox": {
"type": "string",
"description": "Lists to search: omit (or \"all\") for every list, the default; one name such as pgsql-bugs; or several, comma-separated (\"pgsql-hackers,pgsql-bugs\"). Names from list_inboxes. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum results to return (1-50, default 20)"
},
"query": {
"type": "string",
"description": "Natural language query to search for semantically similar messages"
}
}
}Search code symbols by semantic similarity using vector embeddings. Requires embeddings.
| Argument | Type | Description |
|---|---|---|
| limit | number | Maximum results (1-50, default 20) |
| query* | string | Natural language query |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [
"query"
],
"properties": {
"limit": {
"type": "number",
"description": "Maximum results (1-50, default 20)"
},
"query": {
"type": "string",
"description": "Natural language query"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}List all code symbols defined in a file, ordered by line number.
| Argument | Type | Description |
|---|---|---|
| path* | string | File path within the repository |
| repository | string | Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [
"path"
],
"properties": {
"path": {
"type": "string",
"description": "File path within the repository"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}PostgreSQL community events in a date window: conferences, PGDays, meetups, online events, Call for Papers and registration deadlines, conference talks (with speakers and their pg.ddx.io person hash), Talking Postgres episodes, release dates and commitfests. Same data as the iCalendar feeds at https://pg.ddx.io/calendars (community event listings from the PostgreSQL Event Calendar, curated by Andreas Scherbaum).
| Argument | Type | Description |
|---|---|---|
| to | string | End date YYYY-MM-DD (default from + days) |
| days | integer | Look-ahead window in days (default 90, max 730) |
| from | string | Start date YYYY-MM-DD (default today) |
| kind | string | event, cfp, deadline, session (a conference talk), release, or signal |
| limit | integer | Max rows (default 50, max 500) |
| where | string | Country (ISO code or name, e.g. 'de', 'Germany'), region slug (europe, north-america, south-america, asia-pacific, middle-east-africa), a series slug (pgconf-eu, talking-postgres, ...), or 'online' |
| offset | integer | Pagination offset |
| person |
Catch up: everything a person or group did, and where they were named, in a window, newest first per kind (mail grouped by thread). who: a name (fuzzy; close matches return ambiguous [{name, hash}]), email, hash:<8 hex>, team:<slug>, org:<name>, new:<window>, a phrase ('the core team'), or a list. since/until: ISO date, today, 2w/14d/1m, pg19 (a release's development window), all; default 14 days. during: a calendar event uid/url. topic narrows by hybrid search. Kinds: waiting (one person, no topic: what is on their radar, each with group, priority 0-100 and why), mail_from, mail_to_cc, mail_mention, git_author, git_credit, git_mention, wiki_edit, wiki_mention, commitfest, calendar, roster. Names, page hashes and urls only, never addresses. ~4 s budget; late kinds go in timed_out with partial=true. Cite each item's url. Same as GET /api/v2/activity.
| Argument | Type | Description |
|---|---|---|
| who* | any | Who: 'Tom Lane', 'team:core-team', 'org:Amazon/AWS', 'new:30d', a 8-hex person hash, an email; a string or a list of strings |
| kinds | array | Result kinds to return (default all) |
| limit | number | Items per kind (1-100, default 20) |
| since | string | Window start: 2026-10-01, 2w, 14d, 1m, today, pg19, all (default 14 days ago) |
| topic | string | Optional topic that narrows every kind, e.g. NUMA, benchmarking |
| until |
| boolean |
| Pass through .git-blame-ignore-revs commits (default true) |
{
"type": "object",
"required": [
"path"
],
"properties": {
"path": {
"type": "string",
"description": "Path from the repository root"
},
"reverse": {
"type": "boolean",
"description": "Also name the commit that later removed each line (default false)"
},
"version": {
"type": "string",
"description": "Commit to read: a SHA or 7+ hex prefix, a branch (master, REL_17_STABLE), a tag (REL_17_0), a major (17, 9.6), a release (17.2), <ref>@YYYY-MM-DD (the branch's last commit by that day), or <ref>~N. Default: the newest release branch's head."
},
"end_line": {
"type": "number",
"description": "Last line (default start_line + 1999)"
},
"repository": {
"type": "string",
"description": "Repository; only postgres is in the code-history index for now (the default)."
},
"start_line": {
"type": "number",
"description": "First line (default 1)"
},
"ignore_revs": {
"type": "boolean",
"description": "Pass through .git-blame-ignore-revs commits (default true)"
}
}
}| exclude | array | Path globs to drop |
| history | string | Search history instead of one commit: all, a rev (everything up to it on its line), or A..B (B's line after A, as git log A..B) |
| include | array | Path globs to keep, e.g. *.c, src/include/**/*.h |
| version | string | Commit to read: a SHA or 7+ hex prefix, a branch (master, REL_17_STABLE), a tag (REL_17_0), a major (17, 9.6), a release (17.2), <ref>@YYYY-MM-DD (the branch's last commit by that day), or <ref>~N. Default: the newest release branch's head. |
| budget_ms | number | Time budget (100-15000, default 10000) |
| repository | string | Repository; only postgres is in the code-history index for now (the default). |
| case_sensitive | boolean | Default true |
{
"type": "object",
"required": [
"query"
],
"properties": {
"limit": {
"type": "number",
"description": "Results per page (1-2000, default 100)"
},
"match": {
"enum": [
"literal",
"regex",
"identifier"
],
"type": "string",
"description": "How to read query (default literal)"
},
"paths": {
"type": "array",
"items": {
"type": "string"
},
"description": "Directories or globs to search under, e.g. src/backend/storage"
},
"query": {
"type": "string",
"description": "Text, regex or identifier to find"
},
"offset": {
"type": "number",
"description": "Results to skip (paging)"
},
"output": {
"enum": [
"lines",
"files",
"counts"
],
"type": "string",
"description": "lines (default): each matching line with its number; files: paths with match counts; counts: [path, count] pairs"
},
"context": {
"type": "number",
"description": "Lines of context around each match (0-20, default 0)"
},
"exclude": {
"type": "array",
"items": {
"type": "string"
},
"description": "Path globs to drop"
},
"history": {
"type": "string",
"description": "Search history instead of one commit: all, a rev (everything up to it on its line), or A..B (B's line after A, as git log A..B)"
},
"include": {
"type": "array",
"items": {
"type": "string"
},
"description": "Path globs to keep, e.g. *.c, src/include/**/*.h"
},
"version": {
"type": "string",
"description": "Commit to read: a SHA or 7+ hex prefix, a branch (master, REL_17_STABLE), a tag (REL_17_0), a major (17, 9.6), a release (17.2), <ref>@YYYY-MM-DD (the branch's last commit by that day), or <ref>~N. Default: the newest release branch's head."
},
"budget_ms": {
"type": "number",
"description": "Time budget (100-15000, default 10000)"
},
"repository": {
"type": "string",
"description": "Repository; only postgres is in the code-history index for now (the default)."
},
"case_sensitive": {
"type": "boolean",
"description": "Default true"
}
}
}{
"type": "object",
"required": [
"ref"
],
"properties": {
"ref": {
"type": "string",
"description": "The item: e.g. [email protected], https://www.postgresql.org/docs/current/brin.html, Don't Do This, b536d5a0bd7a, CVE-2024-10979, feature:incremental backup"
},
"kinds": {
"type": "array",
"items": {
"enum": [
"mail",
"git",
"docs",
"wiki",
"commitfest",
"people"
],
"type": "string"
},
"description": "Result kinds to return (default all)"
},
"version": {
"type": "string",
"description": "Docs version for a page given without one (default current), e.g. 17"
},
"timeline": {
"type": "boolean",
"description": "Include the timeline (default true)"
},
"limit_per_kind": {
"type": "number",
"description": "Items per kind (1-25, default 5)"
}
}
}| max_body_chars |
| number |
| Cap each body at this many characters (default 4000; 0 = no cap). |
{
"type": "object",
"required": [
"message_id"
],
"properties": {
"inbox": {
"type": "string",
"description": "Mailing list name, e.g. pgsql-general. Defaults to pgsql-hackers when omitted. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Messages per page (1-500, default 20)."
},
"offset": {
"type": "number",
"description": "Skip this many messages; use next_offset from the previous page."
},
"full_text": {
"type": "boolean",
"description": "Whole decoded text of each message, quotes included (default false: own words only)."
},
"message_id": {
"type": "string",
"description": "Message-ID of any message in the thread"
},
"include_bodies": {
"type": "boolean",
"description": "Include message bodies (default true). false returns an outline: headers only."
},
"max_body_chars": {
"type": "number",
"description": "Cap each body at this many characters (default 4000; 0 = no cap)."
}
}
}| head_branch | string | Commit-range mode: head side of the range (included). When set, switches to commit-range mode. |
| message_filter | string | Commit-range mode: filter commits whose message matches this string (case-insensitive substring; passed to git log --grep) |
{
"type": "object",
"required": [],
"properties": {
"path": {
"type": "string",
"description": "Limit results to a specific file path"
},
"limit": {
"type": "number",
"description": "Commit-range mode: maximum commits to return (1-1000, default 100)"
},
"author": {
"type": "string",
"description": "Commit-range mode: filter by author name or email (substring match)"
},
"to_commit": {
"type": "string",
"description": "Content-diff mode: commit to diff to: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. Default HEAD."
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"base_branch": {
"type": "string",
"description": "Commit-range mode: base side of the range (excluded). Defaults to the repository's default branch when head_branch is set."
},
"from_commit": {
"type": "string",
"description": "Content-diff mode: commit to diff from: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool."
},
"head_branch": {
"type": "string",
"description": "Commit-range mode: head side of the range (included). When set, switches to commit-range mode."
},
"message_filter": {
"type": "string",
"description": "Commit-range mode: filter commits whose message matches this string (case-insensitive substring; passed to git log --grep)"
}
}
}| Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name. |
{
"type": "object",
"required": [],
"properties": {
"path": {
"type": "string",
"description": "Filter commits to those touching this file path"
},
"limit": {
"type": "number",
"description": "Maximum commits to return (1-200, default 50)"
},
"since": {
"type": "string",
"description": "Only commits after this date (YYYY-MM-DD or RFC3339)"
},
"until": {
"type": "string",
"description": "Only commits before this date (YYYY-MM-DD or RFC3339)"
},
"author": {
"type": "string",
"description": "Filter by author name or email (substring match)"
},
"branch": {
"type": "string",
"description": "Restrict the log to commits reachable from this branch (e.g. cf/5556). Default: the repository's default branch."
},
"offset": {
"type": "number",
"description": "Offset for pagination (default 0)"
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
}
}
}{
"type": "object",
"required": [
"path"
],
"properties": {
"path": {
"type": "string",
"description": "File path within the repository"
},
"commit": {
"type": "string",
"description": "Commit to read the file at: a SHA (>= 7 hex), branch, tag, major version (17, 9.6), <ref>~N, or a commit_id from another tool. Default HEAD. An unknown name is an error, never a silent HEAD."
},
"end_line": {
"type": "number",
"description": "Last line to return (1-based, inclusive). Default: the end of the file, capped at start_line + 1999."
},
"numbered": {
"type": "boolean",
"description": "Prefix each line with its line number and a tab (default true). false returns the exact file bytes."
},
"repository": {
"type": "string",
"description": "Repository name, e.g. pgbouncer. Defaults to postgres when omitted. Aliases: repo, repo_name."
},
"start_line": {
"type": "number",
"description": "First line to return (1-based). Default 1."
}
}
}| string |
| Only messages sent before this date (exclusive), same forms as since. With author: what that person had said by then. |
| author | string | Only messages this person sent: a name, an e-mail address or hash:<8 hex> (a person page). Resolved to every address they post from; an ambiguous name returns the candidates to choose from. |
| keyword_weight | number | Weight for keyword results in the fusion, 0.0-1.0 (default 0.65). Raise it for exact identifiers (function names, GUCs, error text); lower it to lean on semantic similarity. |
{
"type": "object",
"required": [
"query"
],
"properties": {
"inbox": {
"type": "string",
"description": "Lists to search: omit (or \"all\") for every list, the default; one name such as pgsql-bugs; or several, comma-separated (\"pgsql-hackers,pgsql-bugs\"). Names from list_inboxes. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum results to return (1-50, default 20)"
},
"query": {
"type": "string",
"description": "Search query (supports both keywords and natural language). Operators: after:/before:YYYY[-MM[-DD]], d:A..B, site:<list|docs|wiki|commits>, from:/author:, intitle:/s:, intext:/b:, to:/cc:, filetype:patch, has:patch, link:<url glob> (messages linking to a URL; link:example.org = any URL on that host), /regex/ (case:yes for case-sensitive), -operator to negate. Operators without words list matches newest first."
},
"since": {
"type": "string",
"description": "Only messages sent on or after this date (UTC): YYYY, YYYY-MM, YYYY-MM-DD, an ISO date-time, or 2w / 6m / 1y ago."
},
"until": {
"type": "string",
"description": "Only messages sent before this date (exclusive), same forms as since. With author: what that person had said by then."
},
"author": {
"type": "string",
"description": "Only messages this person sent: a name, an e-mail address or hash:<8 hex> (a person page). Resolved to every address they post from; an ambiguous name returns the candidates to choose from."
},
"keyword_weight": {
"type": "number",
"description": "Weight for keyword results in the fusion, 0.0-1.0 (default 0.65). Raise it for exact identifiers (function names, GUCs, error text); lower it to lean on semantic similarity."
}
}
}| string |
| The question, in plain language. |
| token_budget | number | Maximum tokens of evidence to return (default 4000, max 32000). |
{
"type": "object",
"required": [
"question"
],
"properties": {
"inbox": {
"type": "string",
"description": "Lists to search: omit (or \"all\") for every list, the default; one name such as pgsql-bugs; or several, comma-separated (\"pgsql-hackers,pgsql-bugs\"). Names from list_inboxes. Aliases: list, inbox_name."
},
"since": {
"type": "string",
"description": "Only messages sent on or after this date (UTC): YYYY, YYYY-MM, YYYY-MM-DD, an ISO date-time, or 2w / 6m / 1y ago."
},
"until": {
"type": "string",
"description": "Only messages sent before this date (exclusive), same forms as since. With author: what that person had said by then."
},
"author": {
"type": "string",
"description": "Only messages this person sent: a name, an e-mail address or hash:<8 hex> (a person page). Resolved to every address they post from; an ambiguous name returns the candidates to choose from."
},
"question": {
"type": "string",
"description": "The question, in plain language."
},
"token_budget": {
"type": "number",
"description": "Maximum tokens of evidence to return (default 4000, max 32000)."
}
}
}| until |
| string |
| Only messages sent before this date (exclusive), same forms as since. With author: what that person had said by then. |
| author | string | Only messages this person sent: a name, an e-mail address or hash:<8 hex> (a person page). Resolved to every address they post from; an ambiguous name returns the candidates to choose from. |
| offset | number | Offset for pagination |
| collapse_threads | boolean | Deduplicate results to one per thread, keeping the highest-scoring hit (default false) |
{
"type": "object",
"required": [
"query"
],
"properties": {
"inbox": {
"type": "string",
"description": "Lists to search: omit (or \"all\") for every list, the default; one name such as pgsql-bugs; or several, comma-separated (\"pgsql-hackers,pgsql-bugs\"). Names from list_inboxes. Aliases: list, inbox_name."
},
"limit": {
"type": "number",
"description": "Maximum results to return (1-200, default 50)"
},
"query": {
"type": "string",
"description": "Search query string. Operators: after:/before:YYYY[-MM[-DD]], d:A..B, site:<list|docs|wiki|commits>, from:/author:, intitle:/s:, intext:/b:, to:/cc:, filetype:patch, has:patch, link:<url glob> (messages linking to a URL; link:example.org = any URL on that host), /regex/ (case:yes for case-sensitive), -operator to negate. Operators without words list matches newest first."
},
"since": {
"type": "string",
"description": "Only messages sent on or after this date (UTC): YYYY, YYYY-MM, YYYY-MM-DD, an ISO date-time, or 2w / 6m / 1y ago."
},
"until": {
"type": "string",
"description": "Only messages sent before this date (exclusive), same forms as since. With author: what that person had said by then."
},
"author": {
"type": "string",
"description": "Only messages this person sent: a name, an e-mail address or hash:<8 hex> (a person page). Resolved to every address they post from; an ambiguous name returns the candidates to choose from."
},
"offset": {
"type": "number",
"description": "Offset for pagination"
},
"collapse_threads": {
"type": "boolean",
"description": "Deduplicate results to one per thread, keeping the highest-scoring hit (default false)"
}
}
}| budget_ms |
| number |
| Time budget (100-15000, default 10000) |
| repository | string | Repository; only postgres is in the code-history index for now (the default). |
| occurrences | string | String whose number of occurrences changed (git log -S) |
| changed_lines | string | Regex an added or removed line matches (git log -G) |
{
"type": "object",
"properties": {
"limit": {
"type": "number",
"description": "Commits (1-200, default 30)"
},
"paths": {
"type": "array",
"items": {
"type": "string"
},
"description": "Path prefixes the commit touched"
},
"range": {
"type": "string",
"description": "A rev (its line back to the root) or A..B; default the newest release branch"
},
"since": {
"type": "string",
"description": "YYYY-MM-DD (committed on or after)"
},
"until": {
"type": "string",
"description": "YYYY-MM-DD (committed before)"
},
"author": {
"type": "string",
"description": "Regex over author, committer and credit trailers"
},
"offset": {
"type": "number",
"description": "Commits to skip"
},
"message": {
"type": "string",
"description": "Regex over the commit message"
},
"budget_ms": {
"type": "number",
"description": "Time budget (100-15000, default 10000)"
},
"repository": {
"type": "string",
"description": "Repository; only postgres is in the code-history index for now (the default)."
},
"occurrences": {
"type": "string",
"description": "String whose number of occurrences changed (git log -S)"
},
"changed_lines": {
"type": "string",
"description": "Regex an added or removed line matches (git log -G)"
}
}
}| string |
| pg.ddx.io person hash (8 hex): only their talks/appearances |
| series | string | Series slug, e.g. pgconf-eu, pgconf-dev, posette, talking-postgres |
| speaker | string | Substring of a speaker's name |
{
"type": "object",
"required": [],
"properties": {
"to": {
"type": "string",
"description": "End date YYYY-MM-DD (default from + days)"
},
"days": {
"type": "integer",
"description": "Look-ahead window in days (default 90, max 730)"
},
"from": {
"type": "string",
"description": "Start date YYYY-MM-DD (default today)"
},
"kind": {
"type": "string",
"description": "event, cfp, deadline, session (a conference talk), release, or signal"
},
"limit": {
"type": "integer",
"description": "Max rows (default 50, max 500)"
},
"where": {
"type": "string",
"description": "Country (ISO code or name, e.g. 'de', 'Germany'), region slug (europe, north-america, south-america, asia-pacific, middle-east-africa), a series slug (pgconf-eu, talking-postgres, ...), or 'online'"
},
"offset": {
"type": "integer",
"description": "Pagination offset"
},
"person": {
"type": "string",
"description": "pg.ddx.io person hash (8 hex): only their talks/appearances"
},
"series": {
"type": "string",
"description": "Series slug, e.g. pgconf-eu, pgconf-dev, posette, talking-postgres"
},
"speaker": {
"type": "string",
"description": "Substring of a speaker's name"
}
}
}| string |
| Window end: now (default), today 08:00, 2026-10-21T08:00, pg19 |
| during | string | A calendar event uid or url, or pg19: sets since and until to its dates |
{
"type": "object",
"required": [
"who"
],
"properties": {
"who": {
"anyOf": [
{
"type": "string"
},
{
"type": "array",
"items": {
"type": "string"
}
}
],
"description": "Who: 'Tom Lane', 'team:core-team', 'org:Amazon/AWS', 'new:30d', a 8-hex person hash, an email; a string or a list of strings"
},
"kinds": {
"type": "array",
"items": {
"enum": [
"waiting",
"mail_from",
"mail_to_cc",
"mail_mention",
"git_author",
"git_credit",
"git_mention",
"wiki_edit",
"wiki_mention",
"commitfest",
"calendar",
"roster"
],
"type": "string"
},
"description": "Result kinds to return (default all)"
},
"limit": {
"type": "number",
"description": "Items per kind (1-100, default 20)"
},
"since": {
"type": "string",
"description": "Window start: 2026-10-01, 2w, 14d, 1m, today, pg19, all (default 14 days ago)"
},
"topic": {
"type": "string",
"description": "Optional topic that narrows every kind, e.g. NUMA, benchmarking"
},
"until": {
"type": "string",
"description": "Window end: now (default), today 08:00, 2026-10-21T08:00, pg19"
},
"during": {
"type": "string",
"description": "A calendar event uid or url, or pg19: sets since and until to its dates"
}
}
}