drawDB

container Database / Development / Tools

Database diagram editor for drawing entity relationships in the browser, then exporting them as SQL for MySQL, PostgreSQL, SQLite, MariaDB or SQL Server, or importing an existing schema to see it.

Install drawDB

It isn't in the main Portainer Templates list yet, so use this one. Portainer takes one URL at a time, so it swaps out whatever list you had before.

In Portainer, head to Settings --> App Templates, paste this in as the URL and save.

https://raw.githubusercontent.com/NotAFlightRisk/portainer-templates-extras/main/templates.json
  1. Open App Templates and pick drawDB.
  2. The form works as it comes, so change only what you want to.
  3. Hit Deploy the container, then open http://<your-server>:8098 in a browser.

Before you start

Open http://<your-host>:8098/editor. There's no login and nothing to back up on the server, since diagrams are saved in your browser's own storage, so another browser or a cleared cache starts empty. File --> Export as --> JSON keeps a copy, and File --> Import from brings it back. Plain /editor makes a fresh copy of your last diagram on every visit, so bookmark the /editor/diagrams/... address it moves you to. Share and version history need drawDB's separate backend, which isn't included. Icon fonts load from jsDelivr and cdnjs, and the home page at / pulls in tweets and a GitHub star count from outside services. Docs: drawdb-io.github.io/docs

Ports and storage

Change the left side of a port if it clashes with something else on your server. The volumes are where the data lives, so keep them when you update.

On your serverIn the container
809880/tcp

More apps