r/selfhosted • u/cevheribozoglan • Sep 30 '26
Wednesday Exceptions LibreDB Studio: open-source, free, self-hosted SQL IDE that runs in your browser, for 46 databases
Repo: https://github.com/libredb/libredb-studio
Demo: https://app.libredb.org
Deploy it next to your database with Docker or Helm and open it in the browser. No SSH tunnels, no desktop client on every laptop.
Postgres, MySQL, Oracle, SQL Server, MongoDB, Redis, ClickHouse, DuckDB, Cassandra and more. MIT licensed, SSO and the AI assistant included.
2
u/GarethActual Oct 01 '26
That YouTube URL is rather unfortunate.
Nonetheless the app looks interesting.
1
u/cevheribozoglan Oct 01 '26
I had not noticed until you said it. YouTube picked that ID. I tucked it behind a link now.
Thanks for taking a look anyway!
1
u/jbarr107 Sep 30 '26
Can this query LibreOffice "Base" files? The name LibreDB indicates that it might.
1
u/cevheribozoglan Sep 30 '26
No, not a .odb file itself: its embedded HSQLDB/Firebird database isn't something Studio can read. If your Base file is a front end to PostgreSQL, MySQL or SQLite, though, you can point Studio at that database directly.
And no relation to LibreOffice
1
1
u/K4milLeg1t Sep 30 '26
The UI kinda reminds me of PostMan. It's like super similar
1
u/cevheribozoglan Sep 30 '26
Ha, Sidebar, tabs, editor on top and results below is a layout a lot of dev tools landed on, and it works for queries the same way it works for requests.
1
u/wardyorgason Oct 01 '26
I saw this when I was looking for an easy way to connect to DBs on my tailscale network (to avoid copying DB settings from the different computers I work on). I ended up going with CloudBeaver, however, and it has been great for managing my MySQL databases (they support more than that).
Here is a link for any interested: https://github.com/dbeaver/cloudbeaver/
1
u/cevheribozoglan Oct 02 '26
Glad CloudBeaver is working well for you, it's a solid project and I used DBeaver happily for years.
One thing worth knowing if you ever need more than MySQL: the free Community Edition is SQL only. Its bundled drivers are Postgres, MySQL/MariaDB, Oracle, SQL Server, ClickHouse, DuckDB, SQLite, Trino and a few more: https://github.com/dbeaver/cloudbeaver/tree/devel/server/drivers MongoDB, Redis, Cassandra and Couchbase are in the second table on their supported databases page, which is marked Enterprise / AWS Edition: https://dbeaver.com/docs/cloudbeaver/Supported-databases/
That's the gap LibreDB Studio tries to fill: those engines, SSO and the AI assistant are all in the MIT version.
3
-4
u/cevheribozoglan Sep 30 '26
Some projects that list it in their official docs:
PostgreSQL: https://www.postgresql.org/download/products/1#:~:text=LibreDB%20Studio
Redis: https://redis.io/docs/latest/develop/tools/#libredb-studio
MariaDB: https://mariadb.com/docs/server/clients-and-utilities/graphical-and-enhanced-clients/libredb-studio
ClickHouse: https://clickhouse.com/docs/integrations/connectors/tools/gui#libredb-studio
DuckDB: https://duckdb.org/docs/preview/guides/sql_editors/libredb_studio
YugabyteDB: https://docs.yugabyte.com/stable/integrations/tools/libredb-studio/
StarRocks: https://docs.starrocks.io/docs/integrations/IDE_integrations/LibreDB_Studio/
DragonflyDB: https://www.dragonflydb.io/docs/integrations/libredb-studio
OpenSearch: https://opensearch.org/community-projects/#:~:text=LibreDB%20Studio
Apache Cloudberry (Incubating): https://cloudberry.apache.org/docs/ecosystem/sql-clients/libredb-studio/
Trino: https://trino.io/ecosystem/client-application#libredb-studio
Aiven: https://aiven.io/docs/products/postgresql/howto/connect-libredb-studio
•
u/asimovs-auditor Sep 30 '26 edited Sep 30 '26
Expand the replies to this comment to learn how AI was used in this post/project.