# LibreDB Studio

LibreDB Studio is an open source (MIT), self-hosted SQL IDE. It is open source and self-hosted, installable on ZimaOS, TrueNAS, Kubernetes (Helm), Unraid and Docker Hub.

Canonical page: https://ourlocalhost.com/app/1646/libredb-studio

## Description

LibreDB Studio is an open source (MIT), self-hosted SQL IDE. Use a clean web UI to connect to your SQL databases, browse schemas, write and run queries, and manage your data from any browser on your network. It runs as a single container and stores its own settings in an embedded SQLite file under appdata, so there is no extra database to set up just to run it, and your data persists across container updates.

## Platform availability

Available on 6 of 10 platforms: Unraid, TrueNAS, ZimaOS, Proxmox, Helm, Any server.

## Health score

71/100 (Good), based on 4 of 5 factors.
- Maintained: 100 (last commit 10 days ago)
- Popular: 62 (1,327 GitHub stars)
- Easy to install: 85 (6 install platforms, install notes, Docker image)
- Security check: 10 (3 serious findings, 10 minor, CI, tests)

## Security check

3 serious findings: A private key is committed in the source code; A private key is committed in the source code; A private key is committed in the source code.
Automated checks on commit 6c16e41, 26 Oct 2026. Not an audit.

## Links

- ZimaOS: https://github.com/IceWhaleTech/CasaOS-AppStore/tree/main/Apps/LibreDBStudio
- TrueNAS: https://apps.truenas.com/catalog/libredb-studio/
- Kubernetes (Helm): https://artifacthub.io/packages/helm/libredb-studio/libredb-studio
- Unraid: https://ca.unraid.net/apps/libredb-studio-0a5x41a1cy1kay?q=LibreDB-Studio
- GitHub: https://github.com/libredb/libredb-studio
- Documentation: https://libredb.org/docker-compose/
- Official website: https://libredb.org
- Docker Hub: https://hub.docker.com/r/libredb/libredb-studio

## Common questions

### What port should I open for LibreDB Studio in Docker?

Use port 3000. The Docker quick start maps 3000 to 3000 and says to open localhost:3000.

### Why does login redirect back to the login page when I access LibreDB Studio by a LAN IP?

Set AUTH_COOKIE_SECURE=false when the browser reaches it by a non-localhost address or without HTTPS. Without that, the health check can pass while login fails silently.

### Can I edit data in all supported databases from LibreDB Studio?

Druid, Elasticsearch, and OpenSearch are read-only because their SQL does not support UPDATE or CREATE TABLE. LibreDB Studio reports those controls as unsupported instead of failing.

## Alternatives

- Adminer: Adminer is a lightweight, full-featured database management tool written in PHP that runs as a single deployable file for homelab administr…
- Beekeeper studio: Beekeeper Studio is a cross-platform, open-source SQL editor and database manager that helps developers and database administrators connect…
- DBeaver: A versatile, open-source database tool for developers and administrators supporting multiple databases via JDBC drivers with extensive plug…
- DataGrip: DataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers.
- DbGate: DbGate is a cross-database SQL and NoSQL client that lets you manage MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MongoDB, SQLite, and…
- HeidiSQL: Supports MySQL, MariaDB, Microsoft SQL, and PostgreSQL for data viewing, editing, and exporting with no tracking and offline capabilities.
- MySQL Workbench: MySQL Workbench is a unified visual tool for database architects, developers, and database administrators to design, develop, and manage My…
- TablePro Database Client: TablePro is a free, open-source database client for macOS and iOS.
- Valentina Studio: FREE native AI enabled database manager for RDBMS: DuckDB, MariaDB, MySQL, Parquet, PostgreSQL, SQLite, SQL Server, Valentina DB, and Mongo…
- pgAdmin: pgAdmin is a web-based administration tool for the PostgreSQL database.
- phpMyAdmin: phpMyAdmin is a free, open-source web interface for administering MySQL and MariaDB databases over the web.

---
Source: Our Local Host (https://ourlocalhost.com/app/1646/libredb-studio), the self-hosted and open-source app directory.
