Database Studio

Database Studio

Database Studio is a built-in, IDE-grade database viewer and editor. Browse schemas, read and edit data, and run SQL — without deploying a separate container (pgAdmin, Supabase Studio) or re-entering credentials anywhere.

It connects to:

1. The platform’s own Postgres and the databases it provisions — zero configuration. ShipSquares already holds the sealed credentials and knows which database belongs to which app, so a fresh install needs no extra tool and no extra service.
2. Any external Postgres or MySQL/MariaDB server — through saved connection profiles whose credentials are sealed exactly like your other secrets.

What it does

• Connection switcher with auto-discovered managed connections and your saved external profiles.
• Live schema tree — databases → schemas → tables/views → columns, indexes, constraints, and foreign keys.
• Virtualized data grid — paginated, sortable, filterable, with foreign-key navigation.
• Inline editing behind a review-the-SQL-then-commit bar — edits are generated as primary-key-qualified, parameterized statements and applied in a single transaction.
• SQL runner — read-only by default, with an explicit write mode, statement timeouts, automatic row caps, and destructive-statement detection.

Safe by design

• Server-side proxy, always. Every connection originates from the control plane; your browser only ever speaks REST/WebSocket to ShipSquares and never receives database credentials.
• Read-only by default. Writing requires both an explicit per-connection toggle and the dbstudio:write permission. Destructive statements ask for confirmation.
• RBAC + audit. Access is permission-scoped and every write is recorded.
• Guarded internals. External hosts are checked against private ranges (SSRF guard), and the platform’s own control-plane database is owner-only and read-only.