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

DevFeed: [LibreDB Studio: an open source, self-hosted SQL IDE for PostgreSQL in the browser](<https://devfeed.tech/articles/libredb-studio-an-open-source-self-hosted-sql-ide-for-postgresql-in-the-browser-4716.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/libredb-studio-an-open-source-self-hosted-sql-ide-for-postgresql-in-the-browser-3368/>)

Published: 2026-08-20T00:00:00Z

Content type: article

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [ide](<https://devfeed.tech/topics/ide.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [browser](<https://devfeed.tech/topics/browser.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [API](<https://devfeed.tech/topics/api.md>), [Authentication](<https://devfeed.tech/topics/authentication.md>), [OpenID connect (OIDC)](<https://devfeed.tech/topics/oidc.md>), [Authorization](<https://devfeed.tech/topics/authorization.md>), [Back end](<https://devfeed.tech/topics/backend.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [backend](<https://devfeed.tech/tags/backend.md>), [browser](<https://devfeed.tech/tags/browser.md>), [ide](<https://devfeed.tech/tags/ide.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [self-hosted](<https://devfeed.tech/tags/self-hosted.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

LibreDB Studio is an MIT-licensed, self-hosted SQL IDE for PostgreSQL that runs in the browser and can be deployed as a container, Helm chart, or npm package. The article describes its database-aware query editing, transaction controls, schema introspection, monitoring, optional query assistant, and local-account or OIDC authentication with role-based access control. Release 0.12.0 is highlighted.

## Source excerpt

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 and libredb.org.