PGSimCity turns PostgreSQL internals into an interactive 3D city

PGSimCity is an educational project that renders the PostgreSQL engine as an explorable 3D ‘city,’ aiming to make the database’s internal machinery visible and intuitive rather than abstract. Instead of reading documentation about how queries flow through the system, users watch a working model that maps PostgreSQL’s core mechanics onto interactive visual structures, loading a ‘city code’ to drive the simulation.

The target audience is developers, DBAs, and students who want an intuition for what actually happens under the hood — the kind of internals normally learned only through dense reference material or source code. By framing engine behavior as something you can navigate spatially, the project bets that visualization lowers the barrier to understanding a notoriously deep system.

The author is upfront that this is an early, unreviewed prototype and that both the model and its explanations almost certainly contain inaccuracies, inviting corrections via GitHub issues and pull requests. That caveat matters: it’s a promising teaching aid to explore, not yet a reliable reference to cite.