# postgr.esq

> 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://postgr.esq/mcp): JSON-RPC 2.0 over Streamable HTTP. The native interface; ~90 tools across mail, code intelligence, git, docs, wiki, commitfest.
- [OpenAPI 3.1 spec](https://postgr.esq/openapi.yaml): REST surface over the same data.
- [Swagger UI](https://postgr.esq/api): interactive REST playground.
- [GraphQL endpoint](https://postgr.esq/api/graphql): canonical POST endpoint, schema requires `inbox: String!` arg. GET returns `{"error":"missing query"}`.
- [How-to guide](https://postgr.esq/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://postgr.esq/m/<inbox>/?q=<query>&format=json` — search with filters (subject, from, mid, after, before, regex, k for fuzzy regex)
- `https://postgr.esq/m/<inbox>/<message-id>/raw` — full RFC822 message
- `https://postgr.esq/m/<inbox>/N-N.mbox.gz` — message-range mbox
- `https://postgr.esq/m/<inbox>/new.atom` — recent threads
- `git clone https://postgr.esq/m/<inbox>.git` — public-inbox v2 format archive
- `git clone ssh://git@git.postgr.esq:22/<inbox>.git` — SSH variant

## Status & docs

- [/status](https://postgr.esq/status): live service health, ingestion timestamps, MCP tool utilization.
- [/about](https://postgr.esq/about): data sources, extensions used, ownership, support.
- [/contact](https://postgr.esq/contact): how to reach the operator.
- [/legacy](https://postgr.esq/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/postgresq/* git repos).
- No paywalls, no rate-limits beyond standard abuse protection.