@dbcube/studio 🧊

A local database GUI for Dbcube projects — browse, edit and visualize your data for PostgreSQL, MySQL, SQLite and MongoDB from one app.

npx dbcube studio

Opens on http://localhost:9944 (falls back to the next free port if busy) and auto-launches your browser.

Features

• Database picker — switch between every database in dbcube.config.js.
• Table editor — paginated data grid with sorting, insert / edit / delete.
• Foreign keys as selects — when a column is an FK, editing shows a dropdown of the referenced rows (with a friendly label), not a raw id field.
• Enum & boolean inputs rendered as selects; JSON/text as textareas.
• Table definition — columns, types, PK, FK, nullability and defaults.
• Schema Visualizer — draggable table nodes with FK relationship edges.
• Triggers — list DB triggers (Postgres / MySQL / SQLite).
• Migrations — applied .alter.cube history + pending files.
• SQL and NoSQL — everything runs through the Dbcube ORM, so the same UI works across all engines, including MongoDB.

Flags

dbcube studio --port 9944      # preferred port (auto-fallback if taken)
dbcube studio --host 0.0.0.0   # expose on the network
dbcube studio --no-open        # don't open the browser

How it works

@dbcube/studio is a zero-dependency Node HTTP server that:

1. Reads your dbcube.config.js to list databases.
2. Uses the dbcube ORM (already in your project) for all reads/writes.
3. Introspects schema with the same verified information_schema / PRAGMA / listCollections queries as dbcube run pull.
4. Serves a single-page app (no build step) for the UI.

Nothing leaves your machine — it talks only to the databases in your config.