# Deploy LibreDB Studio with Easypanel

URL: /templates/libredb-studio

LibreDB Studio is the modern, AI-powered open-source SQL IDE. It lets you connect to and query PostgreSQL, MySQL, Oracle, SQL Server, SQLite, libSQL, DuckDB, MongoDB, Redis, Couchbase, ClickHouse, Elasticsearch, OpenSearch, Cassandra, Trino, Druid, Prometheus and Apache Kafka directly from your browser, with an optional AI assistant to help write and explain queries. It ships as a single container, stores its data in a local SQLite file by default, and creates an initial admin and user account on first start.

## Installation notes

Once the deployment is running, open the app at its domain.

Sign in with the admin account. The email is the Admin Email you set
(admin@libredb.org by default), and the password is the generated
ADMIN_PASSWORD value, which you can find under the service's Environment
tab.

A second, lower-privilege account is created alongside the admin one, using
the User Email you set and the generated USER_PASSWORD, also on the
Environment tab.

After signing in you can add your database connections and start
querying. Application data is kept on the volume mounted at /app/data,
so it survives restarts and redeploys.

Do not change JWT_SECRET after you have saved connections. It signs your
sessions and encrypts their stored credentials, so changing it leaves those
credentials unreadable.

The AI assistant stays off until a model provider is configured on the
Environment tab. LLM_API_KEY alone is enough for the default Gemini provider.
Another provider is chosen with LLM_PROVIDER, and a custom or external one
also needs LLM_API_URL. LLM_MODEL is optional and overrides the provider's
own default.


## Benefits

### Multi-Database Support

Query PostgreSQL, MySQL, MongoDB, Redis, Elasticsearch, Prometheus, Apache Kafka and more from a single, unified browser-based interface.

### AI-Powered Queries

An optional AI assistant helps you write, optimize and explain SQL queries, lowering the barrier for complex database work.

### Simple Self-Hosting

Runs as a single container with SQLite storage by default, so there is no external database to manage for the IDE itself.

## Features

### Browser-Based SQL IDE

Connect to your databases and run queries from anywhere using only a web browser, with no desktop client to install.

### Built-in Authentication

Creates an initial admin and user account on first start, with passwords and JWT secret generated automatically.

### Persistent Storage

Application data is stored on a persistent volume mounted at /app/data so your configuration survives restarts and redeploys.

## Configuration

- `appServiceName` (App Service Name, required): libredb-studio

- `appServiceImage` (App Service Image, required): ghcr.io/libredb/libredb-studio:0.17.0

- `adminEmail` (Admin Email, required): admin@libredb.org

- `userEmail` (User Email, required): user@libredb.org

## Services

- libredb-studio: app (ghcr.io/libredb/libredb-studio:0.17.0)

## Resources

- [Website](https://libredb.org/)

- [Github](https://github.com/libredb/libredb-studio)

- [Documentation](https://github.com/libredb/libredb-studio/tree/main/docs)

- [Template source](https://github.com/easypanel-io/templates/tree/main/templates/libredb-studio)