PostgreSQL

Postgres is an open-source relational database created by Mike Stonebraker and subsequently maintained and enhanced by a volunteer community and companies. It is presented as a widely used database whose open ownership contributed to its adoption and continued development.

PGSimCity is an independent, non-commercial educational visualization of PostgreSQL internals: an explorable 3D city that represents a PostgreSQL cluster and lets users inspect, walk through, and disrupt simulated database scenarios. It illustrates effects such as checkpoint-related latency spikes, long-running transactions that keep tables bloated, and the cost of synchronous_commit. The city is a scaled model rather than a PostgreSQL emulator; PostgreSQL source code does not run in the 3D scene, and its quantities are adjusted for visualization. Its optional Query flow and Machine can run PGlite, an in-memory PostgreSQL compiled to WebAssembly. The project targets PostgreSQL 18 and provides keyboard- and text-first routes for its lessons, while noting that the first-person 3D scene has no complete nonvisual equivalent.

Supabase is a hosted Postgres development platform for building production web, mobile, and AI applications, built from open-source components and available for self-hosting or local development. It provides a managed Postgres database, authentication and authorization, Row Level Security, auto-generated REST and GraphQL APIs, realtime database-change subscriptions over WebSockets, Edge Functions and serverless database functions, file storage, and an AI vector and embeddings toolkit. Its architecture combines PostgreSQL with services including PostgREST for REST APIs, GoTrue for JWT-based authentication and session management, Realtime for converting PostgreSQL replication changes to JSON broadcasts, Storage for S3-compatible file management with Postgres permissions, and pg_graphql for GraphQL access. It also provides dashboard tools such as table and SQL editors, policy management, deployment workflows, and official client libraries for JavaScript, Flutter, Swift, and Python, with additional community libraries for other languages.

pgbot is a read-only PostgreSQL observability and health-diagnosis tool for AI agents, applications, and operators. A static binary connects to PostgreSQL, reads the database's own statistics views, and produces deterministic, findings-first health reports, including a health score, critical/warning/note findings, verified healthy subsystems, and change information from local baselines. It provides focused commands for indexes, queries, tables, and vacuum, along with versioned JSON output for agents and scripts and an MCP mode. Its optional ask and explain commands add an AI interpretation of the same findings; inspection and database queries otherwise require no model key or external service. The project is in beta and uses a read-only pg_monitor role with session-level read-only, statement, and lock timeouts as additional safeguards.