LibreDB Studio
LibreDB Studio is a browser-based SQL IDE you run on your own server. It connects to PostgreSQL, MySQL, SQLite, libSQL, DuckDB, Oracle, SQL Server, MongoDB, Redis, Couchbase, ClickHouse, Apache Druid, Elasticsearch, OpenSearch, Apache Trino and Apache Cassandra. Optional AI query assistance works with a local Ollama model, and read-only access is enforced by the database itself rather than by parsing SQL.
LibreDB Studio
In Development
This script is currently in active development and may be unstable or incomplete. Use in production environments is not recommended.
This script is currently in active development and may be unstable or incomplete. Use in production environments is not recommended.
Installation
Default install:
1
bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVED/main/ct/libredbstudio.sh)"
Default Credentials
| Username | Password |
|---|---|
admin@libredb.org | None |
Notes
The admin password is generated during install and written to /etc/libredb-studio/env inside the container.
The install sets AUTH_COOKIE_SECURE=false because the container is reached over plain HTTP. Remove that line when you put the app behind HTTPS.
The AI panel is hidden unless a model is configured, and nothing leaves the container while it is unconfigured.