ClavisDB 0.2.0 adds a visual Schema Designer with interactive ER diagrams and
built-in query profiling, so you can understand both the shape of your data
and how your queries actually run.
Added
- Schema Designer — a Supabase-style, interactive ER diagram for any database.
Open it from the workspace header, the database row in the schema sidebar, or
File → Schema Designer. Pan, zoom, drag tables, fit-to-view and a minimap
are all built in, and node positions are remembered per connection. - Real-time diagrams — the diagram is introspected live and updates instantly
when you change the schema in-app (adding/dropping columns, indexes or foreign
keys), with a manual Refresh always available. - Relationship explorer — click any relationship line to inspect its foreign
key: source → referenced columns,ON DELETE/ON UPDATEactions, and index
coverage (columns without a supporting index are flagged). Click a table to see
its outgoing and incoming relationships and its indexes. - Schema documentation — add descriptions to tables and individual columns.
Descriptions are saved on your device and persist across sessions, and existing
native database comments are shown as placeholders. - Query profiling — an Explain button in the query editor shows the
engine's execution plan alongside execution timing. An Analyze action
(available for read queries) runsEXPLAIN ANALYZEto capture real row counts
and timings. Plans are engine-aware across MySQL/MariaDB, PostgreSQL and SQLite.
Changed
- The schema sidebar's database rows now expose a quick action to open the
database directly in the Schema Designer.
Fixed
pnpm devcould fail to resolve workspace database adapters on a fresh checkout
because dependency packages weren't built first; the dev pipeline now builds
workspace dependencies before starting.