Skip to content

0.1.9

Choose a tag to compare

@ZioMark13 ZioMark13 released this 10 Aug 13:18
252a4ec

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.