Database Traffic Control

PlanetScale is a managed cloud database platform for Vitess/MySQL, Neki sharded Postgres, and PostgreSQL. Vitess and Neki support horizontal scaling through sharding, while the platform provides connection pooling, read replicas, online schema changes, branch-per-environment workflows, automated backups, failover, and online cluster resizing and resharding. Its database workflow includes schema branches, deploy requests, revertable changes, and Database Traffic Control, which enforces query-traffic budgets to limit runaway queries and unexpected load spikes. PlanetScale exposes these capabilities through its platform tooling, APIs, CLI, and an MCP server for controlled agent-operated database changes. The service offers hosted deployments and a bring-your-own-cloud option through PlanetScale Managed, with deployments on AWS and GCP. The homepage states that multi-region deployments have a 99.999% SLA commitment and single-region deployments have a 99.99% commitment.

Tiger Data is a PostgreSQL data platform for combining transactional and analytical workloads in one database. It uses hybrid row and columnar storage, compression, and continuous aggregates, and is positioned for time-series workloads at scale. Tiger Cloud provides a fully managed PostgreSQL service with separated reads and writes through replica sets, plus tiered SSD and S3 storage.

PostgreSQL is an open-source relational database management system maintained by the PostgreSQL Global Development Group. It provides SQL-compliant, ACID transactions, MVCC concurrency, and extensibility through custom types, functions and extensions, and is used for general-purpose and enterprise database workloads.

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.

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.