# DDX for PostgreSQL

> The Database Development neXus: for PostgreSQL. A read-only mirror of
> PostgreSQL community archives — mailing lists, git history, wiki,
> commitfest — exposed as MCP, REST, GraphQL, NNTP, IMAP, Atom feeds,
> and git clone URLs. Built for LLM agents and humans who treat them
> as collaborators.

## Programmatic interfaces

- [MCP endpoint](https://pg.ddx.io/mcp): JSON-RPC 2.0 over Streamable HTTP. The native interface; 100+ tools across mail, code intelligence, git, docs, wiki, commitfest.
- [OpenAPI 3.1 spec](https://pg.ddx.io/openapi.yaml): REST surface over the same data.
- [Swagger UI](https://pg.ddx.io/api): interactive REST playground.
- [GraphQL endpoint](https://pg.ddx.io/api/graphql): canonical POST endpoint. Inbox-scoped query fields (`inbox`, `messages`, `message`, `thread`, `search`) take an explicit `inbox: String!` argument; buildfarm/commitfest/repository fields take their own scoping args. GET returns `{"error":"missing query"}`.
- [How-to guide](https://pg.ddx.io/how-to): worked examples for every endpoint.

## Per-inbox surfaces

Substitute `<inbox>` with one of: pgsql-hackers, pgsql-announce, pgsql-bugs, pgsql-committers, pgsql-general, pgsql-docs, pgsql-jdbc, pgadmin-hackers, pgpool-hackers, …

- `https://pg.ddx.io/m/<inbox>/?q=<query>&format=json` — search with filters (subject, from, mid, after, before, regex, k for fuzzy regex)
- `https://pg.ddx.io/m/<inbox>/<message-id>/raw` — full RFC822 message
- `https://pg.ddx.io/m/<inbox>/N-N.mbox.gz` — message-range mbox
- `https://pg.ddx.io/m/<inbox>/new.atom` — recent threads
- `git clone https://pg.ddx.io/m/<inbox>.git` — public-inbox v2 format archive
- `git clone ssh://git@git.pg.ddx.io:22/<inbox>.git` — SSH variant

## Status & docs

- [/status](https://pg.ddx.io/status): live service health, ingestion timestamps, MCP tool utilization.
- [/about](https://pg.ddx.io/about): data sources, extensions used, ownership, support.
- [/community](https://pg.ddx.io/community): per-person contribution counts (authored, committed, reviewed-by, tested-by, reported-by, discussion, email-from) across the 18-repo PostgreSQL ecosystem. Toggle scope (PG core | ecosystem), time bucket (all-time | by release | by year), and branch (master only | all branches). Per-person pages at `/community/<hash>/` (8-hex prefix of `sha256(canonical_email)`).
- [/community/orgs/](https://pg.ddx.io/community/orgs/): the same data grouped by employer.
- [/api/v2/community/summary](https://pg.ddx.io/api/v2/community/summary), `/contributors`, `/list`, `/orgs`, `/person/<hash>`: REST endpoints reading from `community.mv_person_contribution_summary`.
- [/contact](https://pg.ddx.io/contact): how to reach the operator.
- [/legacy](https://pg.ddx.io/legacy): static mirror of the Berkeley POSTGRES historical archive (1986–1995, source / papers / patches / mailing list / tickets, all also indexed via MCP).

## What we do not have

- No write API. No user authentication. No personal data collection.
- We do not crawl your site. We mirror designated upstream archives only (lists.postgresql.org, public-inbox.org, codeberg.org/ddx/* git repos).
- No paywalls, no rate-limits beyond standard abuse protection.