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-sqlpad

Specification

Status
Listed
Category
Database Tools
Services
sqlpad
Ports
3000
Volumes
1
Memory
about 256 MiB
arm64
unknown
amd64
unknown
Settings to fill in
none
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.

ServiceImageTagPortsVolumes
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.

ServiceVariableValue
sqlpadSQLPAD_ADMINPreset by the template
sqlpadSQLPAD_ADMIN_PASSWORDGenerated at deploy
sqlpadSQLPAD_APP_LOG_LEVELPreset by the template
sqlpadSQLPAD_DB_PATHPreset by the template

First run

  1. 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

  1. 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
  2. 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 | sh if the machine does not have it. See Getting started.

    levelrail-cli login --device
  3. Read the template

    Shows the entry, including its full compose.yaml.

    levelrail-cli templates get sqlpad
  4. 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-sqlpad

    To 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.

More in Database Tools

All Database Tools templates