LibreDB Studio: an open source, self-hosted SQL IDE for PostgreSQL in the browser

LibreDB Studio is an MIT-licensed, self-hosted SQL IDE for PostgreSQL that runs in the browser and deploys as a container or Helm chart.

It is deployed next to the database it manages, as a container, a Helm chart or an npm package, rather than installed on each developer's machine. PostgreSQL is its reference implementation: the provider is built on node-postgres, and the other supported engines follow the patterns established there.

On a PostgreSQL connection the editor uses pooled connections, explicit `BEGIN`/`COMMIT`/`ROLLBACK` transactions with an auto-rollback timeout, and query cancellation through `pg_cancel_backend` on the tracked backend PID. Schema introspection is written to stay responsive on databases with hundreds of tables: the table tree renders from a first pass while relationships stream in from a second. Monitoring reads the `pg_stat_*` views, including `pg_stat_statements` where the extension is installed, and degrades to what the connected role can actually see instead of failing when superuser-only views are unavailable.

The optional query assistant is constrained by the database rather than by prompt text. A run is given the real schema of the connected database before its first turn, so a drafted statement names objects that exist, and read-only runs execute inside `BEGIN READ ONLY` as a single statement over the extended protocol. Authentication is local accounts or OIDC, with role-based access control in front of
every API route.

The current release is 0.12.0. Source, documentation and the PostgreSQL provider reference are at [github.com/libredb/libredb-studio](https://github.com/libredb/libredb-studio) and [libredb.org](https://libredb.org).