# 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.
- [/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.