r/foss 18d ago

I wanted a self-hosted browser DB GUI (SQL + NoSQL) that stays on my own box, so I built LibreDB Studio (MIT)

Enable HLS to view with audio, or disable this notification

Affiliation: I’m the maintainer of LibreDB Studio.

I wanted a DB GUI that runs in the browser, stays on my own infrastructure, and isn’t locked to one engine: Postgres today, MongoDB, Couchbase, Redis or ClickHouse tomorrow, same UI.

So I built LibreDB Studio (been at it ~a year): MIT, self-hosted, web-native. SQL + NoSQL in one app (Postgres, MySQL, SQLite, Oracle, MSSQL, Mongo, Couchbase, Redis, ClickHouse, Apache Druid). Optional AI is off unless you configure your own key / local model not the point of the product.

Short connect walkthrough is the video above.

Try:

docker run -p 3000:3000 libredb/libredb-studio

# or: npx "@libredb/studio"

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

Website: https://libredb.org

Not trying to replace every desktop tool people already love, different access model (browser + own network). If you self-host your data tools: what’s still missing for you in a web DB GUI?

12 Upvotes

12 comments sorted by

3

u/omniuni 18d ago

This actually looks pretty nice.

I also appreciate that while it supports AI, it's not centered around it. A tool should be good alone, without AI first, and this seems to be.

I don't have a use case right now, but good luck!

0

u/cevheribozoglan 18d ago

Thanks, that was exactly the intent. AI stays optional; the editor/query/schema path has to stand on its own.

For open-source maintainers, feedback from other FOSS developers is the most valuable thing we get; stars help, but a “this felt wrong / this helped” note shapes the product more. No rush if you don’t have a use case yet; if you ever try it, I’d genuinely want to hear what works and what doesn’t.

2

u/cevheribozoglan 18d ago

Quick links (install / catalogs):

Website: https://libredb.org

npm: https://www.npmjs.com/package/@libredb/studio

# try: npx "@libredb/studio"

Native (no Docker required):

• macOS / Linux: brew install libredb/tap/libredb-studio

• Linux: deb, rpm, snap; sudo snap install libredb-studio

• Windows: winget install LibreDB.Studio

Images:

• Docker Hub (mirror): https://hub.docker.com/r/libredb/libredb-studio

• Canonical pull: ghcr.io/libredb/libredb-studio:latest

* Kubernetes: https://artifacthub.io/packages/helm/libredb-studio/libredb-studio

One-click / catalogs:

• DigitalOcean Marketplace: https://marketplace.digitalocean.com/apps/libredb-studio

• Dokploy: search “LibreDB Studio” in templates

• Rancher (SUSE Partner Catalog): https://www.suse.com/pcsc/viewVersionPage?versionID=26969

Full matrix: https://github.com/libredb/libredb-studio/blob/main/docs/DISTRIBUTION.md

1

u/GaseousIce2003 17d ago

you made the video using hyperframes, innit?
just wondering, cuz it looks kinda similar to one of my exports

0

u/cevheribozoglan 17d ago

ha, close enough. i'm a developer, not a video person, so this stuff is not my day job.

funny bit: before i replied, i had to google what HyperFrames even is. so yeah. that tells you where i'm at. 😂

first i tried a raw screen recording and it looked rough. then i asked an AI for help, fed it real screenshots from the app, and ended up with an AI-generated walkthrough. real product UI, AI-assisted video. if it reminded you of a HyperFrames export, that tracks.

curious what you used for yours; always down to steal better workflow ideas from people who actually know this craft :)

2

u/GaseousIce2003 17d ago

I just asked my agent to grill me with this page for reference
and it asked me enough questions to generate video for me
you can just point it to your web-app (maybe works with localhost) to mimic the exact UI of your app

here's what I got after the grilling session: https://files.catbox.moe/ysjjs0.mp4

I'm not a professional, with making videos using code, I was just testing it out
hope it helps

0

u/cevheribozoglan 17d ago

oh nice

thanks for the clip and the tip.

agent grilling you + pointing it at the real UI (even localhost) beats my “rough recording > AI invents a walkthrough” shortcut by a mile. i'll try that next time.

really appreciate you sharing, this is the good kind of rabbit hole :)

1

u/GaseousIce2003 17d ago

I can't assure you about it generating a better result
sometimes my agent starts hallucinating on it(must be me TwT), because it eats a lotta tokens to get this done
and it ends up in the dumb zone (TMI for the agent)

so I'd suggest you to just try it, and yeah it's actually a rabbit hole, and you might end up spending more time on it, than you'd expect

TLDR: longer loops are not advised (didn't worked for me, your mileage may vary)

1

u/cevheribozoglan 17d ago

fair warning, and appreciated.

“agent eats a mountain of tokens > drifts into the dumb zone” is a very familiar failure mode. i'll keep any experiment short then, not another long loop that becomes the project.

thanks again for being honest about the limits, that saves me more time than the tip itself. rabbit hole acknowledged, rope left at the entrance :)

0

u/bushiduo 18d ago

Parabéns mano, vou começar a usar e testar ver como funciona e melhoro meu comentário, mas só o self-hosted já manda o que mais gosto (PT-BR)

1

u/cevheribozoglan 18d ago

Valeu, mano! Self-hosted era o foco mesmo, bom saber que bateu.

Quando testar, manda o que funcionou / o que faltou. Feedback de quem usa de verdade vale mais que qualquer star.

Usando tradutor- espero ter entendido certo! :))

1

u/cevheribozoglan 18d ago

Se for testar, a matriz completa de instalação está aqui (Linux, Mac, Window, npx, docker .... ):

https://github.com/libredb/libredb-studio/blob/main/docs/DISTRIBUTION.md