Building LibreDB Studio, an open source SQL IDE you host yourself and open in a browser.

github

Yusuf Gundogdu • Peerlist

LibreDB Studio is an MIT licensed SQL IDE you deploy next to your data instead of installing on every machine. One Docker command and your whole team works from one URL.It connects to 42 databases through 16 drivers: PostgreSQL, MySQL, Oracle, SQL Server, SQLite, MongoDB, Redis, ClickHouse, Elasticsearch, Cassandra, Trino and more. The editor runs on the same engine as VS Code, and you get ER diagrams, schema diff with migration generation, a monitoring dashboard and an audit trail of every query.Nothing is paid. Single sign-on, role based access control and the AI agent are all in the free build. There is no paid edition.The AI agent is read only, and that is enforced by the database itself rather than by a parser. It works with a model on your own hardware: we measured 28 models on the same six tasks and 27 of them run locally through Ollama, the smallest at 2.5 GB. Configure no model and the AI never appears.We are listed in the official documentation of PostgreSQL, Redis, ClickHouse, MariaDB and Trino.