LibreDB Studio launches as open-source, self-hosted SQL IDE

LibreDB Studio has been introduced as an open-source, self-hosted SQL IDE under the MIT license. Designed to run directly alongside data in servers or containers rather than solely on local machines, it provides a unified web interface for over 16 database engines, including PostgreSQL, MySQL, SQLite, MongoDB, Redis, and SQL Server.

The tool features interactive ER diagrams, visual EXPLAIN functionality, schema diffing, and a DDL migration generator. It also includes a secure AI assistant with forced read-only execution at the database level.

For deployment, the software supports Docker, npx, Snap, Helm, and .deb/.rpm packages. When using Docker, users can configure a storage provider to save connections on the server rather than in the browser's local storage, ensuring persistence across different machines.