Deploy LibreDB Studio on Pethost in one click
A SQL IDE in the browser for PostgreSQL, MySQL, SQLite, MongoDB, Redis and more
What happens
- You sign in to Pethost or make an account, with a passkey, GitHub or Google.
- No machine yet? You pick a plan, and we prepare one for you. The link waits in your browser until it is ready.
- New project opens at the app. You fill in what it asks for and click Create project: Email, Admin password.
- In a minute or two the app is live at its own address with HTTPS. Its secrets are made for it at random, and its data is in the nightly backup.
- It is a project like any other: its compose.yaml, its .env, its logs and a terminal are in the panel, and your agent can change it, roll it back or restore it.
First steps
Sign in with the email and the admin password you gave. Saved connections and queries are kept in the project’s volume; the databases it connects to must be reachable from the machine.
What it runs
The template is this compose.yaml and the variables it writes into the project’s .env. Pethost runs the file as it is written.
services:
libredb-studio:
image: libredb/libredb-studio:0.18.3
restart: unless-stopped
environment:
# Signs the sessions and seals the saved connections' passwords.
JWT_SECRET: ${JWT_SECRET}
ADMIN_EMAIL: ${ADMIN_EMAIL}
ADMIN_PASSWORD: ${ADMIN_PASSWORD}
# Connections, saved queries and the accounts in a SQLite file, not in the browser.
STORAGE_PROVIDER: sqlite
TRUSTED_PROXY_HOPS: 1
volumes:
- data:/app/data
volumes:
data: