0.2.0

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 UPDATE actions, 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) runs EXPLAIN ANALYZE to 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 dev could 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.

0.1.9

ClavisDB 0.1.9 introduces ClavisAI, richer table-data workflows, multi-row
selection and a substantially expanded export system.

Added

• ClavisAI query builder — describe a read-only database query in natural
  language and let ClavisAI generate, validate and execute it against the
  selected database schema.
• Explicit @table mentions — type @ to search the live schema and tag
  one or more tables. Mentions receive full column context, appear as highlighted
  clickable chips and can open the referenced table directly.
• Licensed cloud AI proxy — Groq requests go through the ClavisDB Cloudflare
  Worker, keeping the provider API key out of the desktop application. License
  validation, per-license/IP rate limiting, request limits and read-only SQL
  enforcement are applied before execution.
• Offline AI fallback — licensed users retain a lightweight deterministic
  fallback when the cloud planner cannot be reached.
• Persistent ClavisAI conversations — chat history is stored per connection
  and survives closing the panel or restarting the app. A trash button clears
  the conversation explicitly.
• Markdown AI responses — answers support paragraphs, lists, code and
  scrollable GFM tables. Every assistant response has an icon-only button to
  copy its original Markdown.
• Table-specific search — search the currently open table independently of
  Global Search. Ctrl+F / Cmd+F focuses the table search field.
• Multi-row selection — select table rows with click, Ctrl/Cmd+click,
  Shift+click or pointer dragging. Selected rows remain visually highlighted.
• Bulk row deletion — delete multiple selected rows with one confirmation;
  each safely targeted mutation remains recorded in History.
• Selected-row export — export one row or any multi-row selection without
  exporting the rest of the table.
• HTML export — generate a standalone styled HTML table for full tables or
  selected rows.
• Per-format destinations — CSV, JSON, HTML and SQL INSERT exports each offer
  both Save and Copy to clipboard destinations.

Changed

• ClavisAI is now a general-purpose, schema-driven SQL query builder rather than
  assuming a particular FiveM, RedM or application-specific database layout.
• ClavisAI uses cloud-first planning when online. The deterministic engine no
  longer intercepts semantic or relational requests and is reserved for the
  offline fallback.
• The database configured on a connection is respected by the ClavisAI database
  selector instead of exposing unrelated databases.
• AI result sets are rendered as readable Markdown tables and generated SQL is
  kept in a separate expandable section.
• Table and selected-row export menus now use nested format/destination choices;
  context submenus automatically flip direction near screen edges.

Security

• ClavisAI remains unavailable without an active license, including its offline
  fallback, preventing free-tier clients from consuming hosted AI usage.
• Generated database operations are restricted to a single read-only
  SELECT, WITH, SHOW, DESCRIBE or EXPLAIN statement and capped at 100
  returned rows.
• Provider secrets remain server-side in Cloudflare Worker secrets and are never
  embedded in desktop builds.

0.1.8

Free Forever License

• ClavisDB now has a free forver mode, including all the current features

0.1.7

Full Linux Support & Mac OS

• Improved licensing system for Linux and MacOS
• Fixed GNOME & Taskbar icons on Linux
• Enhanced version checking system for Linux, Windows and MacOS

0.1.4

Table Designer now covers indexes and foreign keys, the connection dialog gains
a full SSH tunnel setup, and the FiveM/RedM Player Inspector becomes editable
with templated admin actions.

Added

• SSH tunnel in the connection dialog — connect through an SSH server with
  password, private key (with file picker + optional passphrase), or SSH agent
  authentication. SSH secrets are encrypted in the OS credential vault, never
  stored in plaintext.
• Table Designer: indexes — add indexes (single or multi-column, unique) and
  drop them, with the generated SQL shown for review before it runs.
• Table Designer: foreign keys — add foreign keys with referenced table and
  column pulled from live schema introspection, ON DELETE / ON UPDATE
  actions, and drop support — again with an editable SQL preview.
• Player Inspector admin actions (FiveM/RedM) — set or add/subtract money per
  account, set a character's job and grade, and delete a character, straight from
  the Player Card. Every action shows the exact SQL before executing (Safe
  Editing) and is logged in History. Supports QBCore/QBox, RSGCore, ESX and VORP.
• macOS release pipeline scaffolding — build config, entitlements and a
  GitHub Actions workflow are in place for signed, notarized .dmg builds
  (arm64 + x64). Not yet active (requires an Apple Developer account).

Changed

• Foreign keys are now shown in the table Structure view.
• Read-only connections continue to reject every new destructive operation
  (index/FK changes and player admin actions included).

Notes

• New DDL runs on the live database — index, foreign key and player actions are
  blocked on read-only connections and always show their SQL first.

0.1.3

Table Designer now covers indexes and foreign keys, the connection dialog gains
a full SSH tunnel setup, and the FiveM/RedM Player Inspector becomes editable
with templated admin actions.

Added

• SSH tunnel in the connection dialog — connect through an SSH server with
  password, private key (with file picker + optional passphrase), or SSH agent
  authentication. SSH secrets are encrypted in the OS credential vault, never
  stored in plaintext.
• Table Designer: indexes — add indexes (single or multi-column, unique) and
  drop them, with the generated SQL shown for review before it runs.
• Table Designer: foreign keys — add foreign keys with referenced table and
  column pulled from live schema introspection, ON DELETE / ON UPDATE
  actions, and drop support — again with an editable SQL preview.
• Player Inspector admin actions (FiveM/RedM) — set or add/subtract money per
  account, set a character's job and grade, and delete a character, straight from
  the Player Card. Every action shows the exact SQL before executing (Safe
  Editing) and is logged in History. Supports QBCore/QBox, RSGCore, ESX and VORP.
• macOS release pipeline scaffolding — build config, entitlements and a
  GitHub Actions workflow are in place for signed, notarized .dmg builds
  (arm64 + x64). Not yet active (requires an Apple Developer account).

Changed

• Foreign keys are now shown in the table Structure view.
• Read-only connections continue to reject every new destructive operation
  (index/FK changes and player admin actions included).

Notes

• New DDL runs on the live database — index, foreign key and player actions are
  blocked on read-only connections and always show their SQL first.