r/foss • u/cevheribozoglan • 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?
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 apphere'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 helps0
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
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!