Self-host SQLPad on a VPS
Web based SQL editor for running queries against many databases, with saved queries, charts and sharing. The admin account is created from the install form.
levelrail-cli templates install sqlpad --name my-sqlpadSpecification
- Status
- Listed
- Category
- Database Tools
- Services
- sqlpad
- Ports
- 3000
- Volumes
- 1
- Memory
- about 256 MiB
- arm64
- unknown
- amd64
- unknown
- Settings to fill in
- none
- License
- Permissive license, MIT
- Listing
- Community template
About SQLPad
Web based SQL editor for running queries against many databases, with saved queries, charts and sharing. The admin account is created from the install form.
What it deploys
SQLPad runs as one service in a single Compose app, listening on port 3000, with 1 named volume mount.
| Service | Image | Tag | Ports | Volumes |
|---|---|---|---|---|
| sqlpad | sqlpad/sqlpad | 7.5.7 | 3000 | data -> /var/lib/sqlpad |
Before you install
- CPU architecture. arm64 unknown. The scan could not read a manifest or the tag is chosen at install time. This is not a claim either way.
- Listed. It is in the catalog. Back up the data volume before changing an image tag.
Settings and environment
You do not have to fill in anything. 1 secret is generated at deploy and stored encrypted. Values are never shown here.
| Service | Variable | Value |
|---|---|---|
| sqlpad | SQLPAD_ADMIN | Preset by the template |
| sqlpad | SQLPAD_ADMIN_PASSWORD | Generated at deploy |
| sqlpad | SQLPAD_APP_LOG_LEVEL | Preset by the template |
| sqlpad | SQLPAD_DB_PATH | Preset by the template |
First run
- Sign in with the admin email and the generated password shown in the deployment variables, then add a connection to your database.
Install SQLPad on a VPS
-
Install Levelrail on a fresh VPS
Run this as root on a Linux server (amd64 or arm64) with ports 80 and 443 reachable. The installer prints a setup link.
curl -fsSL https://levelrail.com/install.sh | sudo sh -
Sign in
Open the setup link, choose a password, then log the CLI in. The CLI install command is
curl -fsSL https://levelrail.com/install-cli.sh | shif the machine does not have it. See Getting started.levelrail-cli login --device -
Read the template
Shows the entry, including its full compose.yaml.
levelrail-cli templates get sqlpad -
Install it
This template has an install form, so the CLI fills each setting from --env, a generated secret or its default.
levelrail-cli templates install sqlpad --name my-sqlpadTo put a service behind a domain at install, add
--domain SERVICE=HOST:levelrail-cli templates install sqlpad --name my-sqlpad --domain sqlpad=sqlpad.example.com
Without a domain the app gets an sslip.io address. You can also deploy it from the dashboard: Apps, New app, Browse templates, then SQLPad.
Docs and upstream
More in Database Tools
- SonicFast, lightweight schema less search index server that stores identifiers instead of documents. The install form carries config.cfg as an editable file and a generated channel password.
- SurrealDBA multi-model database for documents, graphs and relations with a SQL-like query language, using the RocksDB engine on a named volume. The root password is generated at install. Source available under the BSL.
- ScyllaDBA wide column database compatible with Cassandra, running as one node in developer mode with a data volume. It has no web page, so connect over the project network at scylladb:9042.
- TiDBA MySQL compatible distributed SQL database, run here as a single node on local storage for development and testing. Apache-2.0 licensed. The root user has no password, so keep it private.
- TimescaleDBPostgreSQL with the TimescaleDB extension for time series data, with a persistent volume and a generated password. The core is Apache-2.0 and some features fall under the Timescale License. It is not published on the host, so reach it from other services in this project at timescaledb:5432.
- RethinkDBA document database with live query feeds and a web admin console, on the official image with a data volume. The console has no login, so restrict access before exposing it. Client driver port 28015 stays private.