pgsimcity
An explorable 3D city where buildings stand for PostgreSQL internals. It helps people see how queries, memory, checkpoints and replication behave, as a learning aid.
Pick a small issue you can reproduce, then fix it with your AI coding agent.
Share on XLicense: Apache-2.0
Overview
PGSimCity is an explorable 3D city that shows how PostgreSQL works internally. Buildings stand for PostgreSQL components and motion shows how they interact. You can follow a query, investigate a growing table, or see what changes when memory, checkpoints and replication become bottlenecks. It runs in a browser with WebGL2 and needs no installation. A guided case starts from a table that keeps growing even though autovacuum is running.
Key features
- 3D city where buildings represent PostgreSQL internals
- Guided investigation of a vacuum blockade
- Follow a query or a growing table through the system
- Runs in the browser with WebGL2, no install
Best for
Developers and DBAs who want a visual way to learn PostgreSQL internals and practice diagnosing problems. It needs a browser with WebGL2.
- Upstream
- NikolayS/PGSimCity
- Fork on GitHub
- Guo-astro/pgsimcity
- Upstream stars
- 763
- Category
- Developer tools and infrastructure
- Language
- TypeScript
- License
- Apache-2.0
- Forked
- 2026-07-30
- Sync status
- In syncLast synced 2026-10-20
More in Developer tools and infrastructure
An open-source TypeScript engine for calculating Zi Wei Dou Shu charts and consulting traditional references. It helps developers build charting and interpretation tools.
Forked 2026-10-18Last synced 2026-10-20License: MITDeveloper tools and infrastructureGitHub
ImHex is a hex editor for inspecting and editing binary files. Reverse engineers, programmers, and forensic users can search and patch bytes or describe file structures with its pattern language.
Forked 2026-10-17Last synced 2026-10-20License: GPL-2.0Developer tools and infrastructureGitHub
Numa is a portable DNS resolver for local development and privacy. It blocks ads, gives local services names like frontend.numa, and runs without depending on a cloud account.
Forked 2026-10-17Last synced 2026-10-20License: MITDeveloper tools and infrastructureGitHub
Handwired turns ordinary JavaScript logic into differentiable neural-network-style calculations, so programs can run as matrix operations in JavaScript or WebGPU. It is for experimenting with GPU execution and optimization of code written in a traditional style.
Forked 2026-10-16Last synced 2026-10-20License: MITDeveloper tools and infrastructureGitHub