r/selfhosted • • Sep 30 '26

Wednesday Exceptions LibreDB Studio: open-source, free, self-hosted SQL IDE that runs in your browser, for 46 databases

Post image

Repo: https://github.com/libredb/libredb-studio

Demo: https://app.libredb.org

Youtube Demo!

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.

0 Upvotes

14 comments sorted by

•

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.

→ More replies (1)

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

u/jbarr107 Sep 30 '26

Unfortunate. I thought the "Libre" reference might be valid.

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

u/OverAster Sep 30 '26 • Bravo

More slop for the slop pile. Yum yum.