# WebDataStudio

WebDataStudio is a self-hosted cloud app. A database studio that runs in your browser: PostgreSQL, MySQL/MariaDB, SQL Server, SQLite, Oracle, DuckDB, ClickHouse, MongoDB and Redis in one container. It is open source and self-hosted, installable on Unraid.

Canonical page: https://ourlocalhost.com/app/3473/webdatastudio

## Description

A database studio that runs in your browser: 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 for AI agents. Connections are added in the studio or handed in as WDS_CONN_NAME variables. Set the admin user and password below - without both, the studio has no login screen at all. Read-only connections are enforced in the driver, not only in the interface.

## Platform availability

Available on 1 of 10 platforms: Unraid.

## Health score

62/100 (Good), based on 4 of 5 factors.
- Maintained: 86 (last commit 23 days ago)
- Popular: 21 (10 GitHub stars)
- Easy to install: 35 (1 install platform, install notes, Docker image)
- Security check: 94 (no serious findings, 1 minor, CI, tests)

## Links

- GitHub: https://github.com/fgilde/WebDataStudio
- Unraid: https://ca.unraid.net/apps/webdatastudio-12jxveq0mo3uke?q=WebDataStudio
- Documentation: https://fgilde.github.io/WebDataStudio/guide/
- Official website: https://fgilde.github.io/WebDataStudio/

## Common questions

### How can I provide database connections to WebDataStudio?

Connections can be added in the studio or handed in as WDS_CONN_NAME variables.

### What admin credentials are required?

Set both an admin user and password. Without both, the studio has no login screen.

### Are read-only connections only a UI setting?

No, read-only connections are enforced in the driver, not only in the interface.

### Does WebDataStudio replace migration, monitoring, or backup workflows?

No, it does not replace a migration tool, monitoring stack, or backup schedule. It is for inspecting and deliberately changing a database, with the statement shown before it runs.

---
Source: Our Local Host (https://ourlocalhost.com/app/3473/webdatastudio), the self-hosted and open-source app directory.
