WebDataStudio 1.3.0

A database client that runs on the server instead of on one laptop: PostgreSQL, MySQL/MariaDB, SQL
Server, SQLite, Oracle, DuckDB, ClickHouse, MongoDB and Redis in one container. Schema explorer, SQL
editor with completion and history, a visual query builder, result charts, ER diagrams drawn from the
foreign keys, schema editing, a column-by-column comparison between two connections, saved and
scheduled queries with file export, and an MCP endpoint so an agent can query the same connections
under the same rules.

• Upstream: https://github.com/fgilde/WebDataStudio (MIT)
• Docs: https://fgilde.github.io/WebDataStudio/
• Image: ghcr.io/fgilde/webdatastudio:v1.3.0, pinned to the manifest-list digest
  sha256:e7769d9690315217296bc7cb7bd0ea278ea02eef41c7cb4911e5b767f0ed3347
  (linux/amd64 + linux/arm64, public, built by the project's own CI)
• I am the developer of the app and the submitter of this package.

Package

webdatastudio/
  umbrel-app.yml
  docker-compose.yml
  data/.gitkeep

One service behind app_proxy (port: 8118 → container 8080), running as 1000:1000, with
${APP_DATA_DIR}/data:/data for saved connections, query history, layouts and the studio's own
SQLite database. No host paths, no Docker socket, no privileged mode, no extra capabilities, no
raw published ports, no dependencies.

Credentials

The studio has no login screen at all when neither WDS_USER nor WDS_PASSWORD is set, so the
package always sets both: admin and ${APP_PASSWORD}, with deterministicPassword: true so
umbrelOS shows the password on the app page.

Testing

• npm run lint:apps -- webdatastudio --check-images: clean.
• docker buildx imagetools inspect ghcr.io/fgilde/webdatastudio:v1.3.0 lists linux/amd64 and
  linux/arm64 under the pinned index digest.
• Ran the pinned image with --user 1000:1000 and the same bind mount: the UI answers, /api/*
  gives 401 without a session, a login with the packaged credentials returns 200 and a wrong
  password 401, and webdatastudio.db is created in the mounted directory. Restarting the
  container against the same directory keeps the data.
• Screenshots and the logo are attached below for App Store assets; nothing image-related is
  committed in this PR.

Screenshots and logo

Logo: https://raw.githubusercontent.com/fgilde/WebDataStudio/master/docs/assets/icon.png (SVG source:
https://raw.githubusercontent.com/fgilde/WebDataStudio/master/docs/assets/icon.svg)

Screenshots: