Skip to content

Postgres Schema Gallery

Real PostgreSQL schemas behind well-known open-source products, reviewed by db-architecture-review, each with a rotatable 3D explorer - greenstevester/postgres…

Postgres Schema Gallery screenshot

About Postgres Schema Gallery

The front page draws all seven live and turning, with the reviewer's findings behind each one.

The real PostgreSQL schemas behind well-known open-source products, documented and reviewed by ArchLens Postgres , each with a rotatable 3D explorer.

Seven products in the first cut: Temporal, Miniflux, Listmonk, Matrix Synapse, Sourcegraph, Cal.com, and GitLab CE at 1,429 tables as the stress test. The front page shows every schema as a live, slowly turning miniature; each card opens the full explorer and the docs with the reviewer's findings.

Nothing third-party lives in this repository. products.json names each product's repository, a pinned commit, the schema file, and its licence. On every push to main a workflow fetches those files at those commits, derives plain SQL where needed (Go migration strings for Miniflux, a Prisma schema for Cal.com), runs the reviewer as a library, writes one documentation folder per product, records a three-second clip of each explorer turning plus the wide animated banner, renders the front page, and deploys site/ to GitHub Pages.

The front page draws its miniatures live with WebGL. A browser without WebGL gets each product's recorded clip instead, with the flat schema map as its poster, plus a note saying where that browser's WebGL switch is and that a private window (extensions off) is the quickest test.

Discussion

Sign in to join the discussion.

Loading comments…

Tagged

Alternatives to Postgres Schema Gallery

Tools in the same space, ranked by how they are performing in the directory.

Compare all
  • Pr Lens

    PR Lens draws every PR as animated architecture and data-flow diagrams, inside the pull request itself.

    /Developer Tools
  • Leadcode

    Every client gets a workspace signed in to their own GitHub, Claude and Codex accounts.

    Freemium/Developer Tools
  • Kcc

    KCC (a.k.a. Kindle Comic Converter) is a comic and manga converter for ebook readers.

    /Developer Tools
  • Kafma

    Kafma is a Kafka GUI client and desktop IDE.

    /Developer Tools
  • ServeTheHome

    We test the MikroTik CRS804-4DDQ-hRM a 4-port 400GbE network switch that we have been using for local AI clusters

    Paid/Developer Tools
  • Vol 2

    Fifteen years of Show HN: the thirty-four repeat fliers and the top ten of every year.

    Open source/Developer Tools