> ## Documentation Index
> Fetch the complete documentation index at: https://docs.levelrail.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Self-host SQLPad with Docker

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

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.

This page describes the Levelrail template for SQLPad (Database Tools). It deploys the services below as one Docker Compose app on your own server. Project site: [https://getsqlpad.com/](https://getsqlpad.com/).

Recommended memory: about 256 MiB.

## Services, ports and volumes

| Service | Image | Container ports | Volumes |
| - | - | - | - |
| `sqlpad` | `sqlpad/sqlpad:7.5.7` | 3000 | `data -&#62; /var/lib/sqlpad` |

## Environment variables

| Service | Variable | Value |
| - | - | - |
| `sqlpad` | `SQLPAD_ADMIN` | Preset in the template |
| `sqlpad` | `SQLPAD_ADMIN_PASSWORD` | Generated at deploy |
| `sqlpad` | `SQLPAD_APP_LOG_LEVEL` | Preset in the template |
| `sqlpad` | `SQLPAD_DB_PATH` | Preset in the template |

Passwords and keys marked as generated are created for you when the app is deployed and stored as secrets. Values are not shown here.

## Security and requirements

Level: **Standard**.

What this template needs:

* Passwords and keys are generated at deploy time (`sqlpad`): SQLPAD\_ADMIN\_PASSWORD.
* No health check, so a deploy is judged by the process starting (`sqlpad`).
* Stores data in named volumes (`sqlpad`): data.

What Levelrail adds around it:

* Automatic HTTPS and an ingress shield in front of every domain.
* Secrets are generated, stored encrypted and masked in logs and the UI.
* Named volumes can be backed up and restored.
* One-step rollback to the previous revision.
* Exposure report shows what is reachable from outside.
* Host firewall rules managed for published ports.

## Deploy SQLPad with Levelrail

In the dashboard, open **Apps**, choose **New app**, then **Browse templates**, and select SQLPad. Review the Compose body and deploy.

With the CLI:

```bash theme={"dark"}
levelrail-cli templates deploy sqlpad --name my-sqlpad
```

See the [service template catalog](https://docs.levelrail.com/templates-and-registry.md) for how templates work, and [Getting started](https://docs.levelrail.com/getting-started.md) if you have not installed Levelrail yet.

## More Database Tools templates

* [Adminer](https://docs.levelrail.com/self-host/adminer.md)
* [ArangoDB](https://docs.levelrail.com/self-host/arangodb.md)
* [Baserow](https://docs.levelrail.com/self-host/baserow.md)
* [Bytebase](https://docs.levelrail.com/self-host/bytebase.md)
* [Apache Cassandra](https://docs.levelrail.com/self-host/cassandra.md)

All templates are listed in the [self-host gallery](https://docs.levelrail.com/self-host.md).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.